Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Sales Report Issues Help
I am trying to get a daily sales report based on classes. I have the fields set up but the cash sales are counted twice. I am trying to find how to group the cash sales. I dont have the option to group them.
Here is my setup:
Transaction Search
Criteria:
Type is cash sale
Class :websales etc.
Item: is not donation
Results:
Date
Type - Summary Type Group
Account - Summary Type Sum
Class - Group
The reason for the sum is because this is a cumulative sum of the days sales orders entered. The amount came back double what was entered, in drilling down I discovered the double amounts.
0