コース概要

Do you want to take your Saved Search capabilities to the next level? Acquire the final set of skills you need to effectively mine your NetSuite data.

This two-day, instructor-led course will help you master NetSuite Saved Searches. You learn how to calculate and transform your search results so you can get the business intelligence you need to make your company even more successful.

Through demonstrations, hands-on exercises, and real-life use cases you study how to build searches using complex parenthetical expressions, add joins to access data, and use functions and summary types to format date and numeric values. Taking your skills even farther, you also learn how to incorporate formulas and SQL functions to translate values, calculate dates and numbers, generate matrix-style output, format dates and numbers, render results with embedded HTML, apply complex criteria, and more.


This course is right for you if you are...


Key Tasks Taught: How do I...

  • Enhance my search criteria by incorporating parenthetical expressions?
  • Use ‘Main Line is False’ in searches?
  • Use joins in searches to access other data elements?
  • Change the sorting behaviour of maximum and minimum search values?
  • Work with column labels by adding HTML tags and line breaks?
  • Perform basic computations between two or more NetSuite fields?
  • Return list/record fields as hyperlinks to easily navigate to other records via the search results?
  • Make best use of many Oracle SQL functions: CASE, DECODE, TO_CHAR, UPPER, INSTR, SUBSTR, TO_NUMBER, NVL, NULLIF, ROUND, FLOOR, LAST_DAY, ADD_MONTHS, REGEXP_LIKE, RANK, DENSE_RANK, COUNT, AVG, MEDIAN, and others?

期間: 2 days
価格: $1,600 USD

コースの詳細(データシート)

コーススケジュール

営業担当者とチャット

NetSuiteにご関心をお持ちですか?

チャットを開始