Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Grouped / Sum not working on Sales TX Report
Hi!
I have a user that created an item fulfillment report that groups by then Item Group Rate when main line = ANY.
He wants to add this column to our database but whether I use group or sum, on a header or line report, for the database, the values aren't tying out.
The header is not working because it's not summing nor grouping all the lines (my guess is because it's grouped by the document number and not product.) For the line report, for some reasons, it's not working either. I literally just get two records and unfortunately if you add amount in header to line, it doesn't tie out to the "any."