NetSuite provides a variety of standard reports that are available at the Reports tab. These reports can be further customised using the Report Builder.
To select the type of data you want to report on:
-
On the Reports page or Reports tab menu, click New Report.
-
On the New Report list, select the Metric on which you want to report.
After you select the metric you want to report on, you are taken to a page with criteria specific to that metric. For example, if you choose to report on Forecast data, you are taken to a page entitled "New Forecast Report" that contains criteria related to forecast data only.
To set the criteria for your report:
-
In the Report Title field, a default title appears. This default title is based on the metric you chose and the default format.
For example, if you chose to report on Forecast data, the default title is Custom Forecast Summary.
Note: You can enter a custom title in this field but after you make any changes to this field (entering a custom description, adding or removing a space, etc.), it is no longer updated automatically.
-
Step 1: Select the field you want to report on
This list of fields contains only fields associated with the type of data you chose to report on. For example, if you clicked Forecast on the New Report page, the list of fields contains only fields associated with forecast transactions.
-
Step 2: Select the format of the report
You can choose to create a summary, detail or matrix report.
-
Step 3: Select how you want to subtotal the report
Select the field you want to subtotal your report by. For example, if you want to see your forecast grouped by location, select Location as the component and Name as the field.
-
Step 4 : Select how you want to summarise the data across columns
This step appears only if you chose to build a matrix report. You can then choose to view your matrix report divided into multiple columns based on the column you select. The report will then be summarised by that column across all columns. For example, if you are building a report based on forecast data and you want to view monthly forecast totals, select Month in the Column field. Your report will then have a column listed for each month for the date range selected in the footer.
-
-
When you have selected all criteria, you can:
-
Click Run Report to view the results of your new report. You can then use the options in the footer to further customise your report.
-
Click Save to both run the report and save the report. You can access the saved report by going to Reports > Saved Reports > All Saved Reports (Administrator).
-
Click More Customisation to display the Report Builder, where you can add more filters and sorting options, reorder or add columns to your ad hoc report, or choose display options for your report.
-