Thursday 20 October 2016

NetSuite - How to create a report that shows sales per customer with a year-on-year comparison

1. Navigate to Reports > Financial > Comparative Income Statement > Customize
2. Edit Columns > Add Budget and Financial: Customer/Job: Name
3. Set Comparative Amount: Alternate Date Range = last fiscal year (e.g., 2015)
4. Set Filters > Budget and Financial: Account (Line): Name equal to Revenue or Sales (or whatever account is used in recording sales). Add.
5. Set Budget and Financial: Date: Enter From and To Dates. Click Done
6. Click Preview
Share:

0 comments:

Post a Comment