NetSuite Tips & Tricks

Saved Searches and Reports

  • When viewing NetSuite reports (not saved searches) use the following shortcuts on your keyboard:
  • Use Page Up to navigate to the previous page within a report.
  • Use Page Down to move to the next page of a report.
  • Press Home to quickly access the first page of a report.
  • Press End to reach the last page of a report.
  • Create an audit trail custom search by starting a new saved search and selecting Analytics Audit Trail as the search type. The results will show details about individuals responsible for any modifications made to records within a specific time frame.
  • Choose the level at which you want to view data. Utilize the “Main Line” criteria to decide whether you only want to see the header level of your record/transaction. The same logic applies to the “Tax Line” and “Shipping Line” criteria.
  • Merge data seamlessly using double pipes “||” for concatenation. Combine text, NetSuite columns, and even include HTML code as needed.
  • Easily fill in dates while on a date field: “t” for today, “y” for yesterday, “m” for last day of the month, “l –” for last day of the previous month, “+” to increase by one day, and “–” to decrease by one day.

Leave a comment

Your email address will not be published. Required fields are marked *