Wednesday 19 October 2016

NetSuite - How to create a report that will Display the Average Transaction Total of Sales Orders per Day

To create a report that will display the Average amount of the sales orders per day, please follow the steps below:

Navigate to Reports > Saved Searches > All Saved Searches > New > Transaction

Under Criteria tab > Standards subtab > Add the following filters:

Type is Sales Order

Main Line is True

Go to the Results tab and do the following:

On the Date column, set Summary Type = Group

On the Amount column, set Summary Type = Average

Rename the search


Save & Run.
Share:

0 comments:

Post a Comment