NetSuite comes with variety of Standard reports which are dynamic and can be customized as per the need of business. But what if those reports doesn't fulfill the requirement of your business?
In that situation you can create an ad hoc report by your own.
Ad Hoc Report Creation
#1 Go to Reports > New Reports
#2 Select the Matric ( Type of report you want to create for example Sales, transaction, case etc)
#3 Give your Report a title.
#4 Select the Metric ( Type of data you want to build report on)
#5 Select the format of the report. There are three types of format available:
- Summary: Summary is the default report display, providing a summary view.
- Detail: Detail reports show a list of the items affecting the values in the report.
- Matrix: A matrix-style report is a summary report with a variable number of
columns.
The Column list in the report footer transforms a standard
report into a matrix or crosstab report.
- Select the component
- Select the Field
For Example if you want to see the Transaction Summary report which should include the amount and was subtotal by account Name.
- Report > New Report > Select Transaction from Metric > Give title to report > Select Metric on which you want to build the report in Transaction. ( In are case it is Amount) > Select the format ( in our case it is Summary) > select the component ( Account) > select the field ( Name) > Save Report or Run Report (if you do not want to save this report for future)