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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Sales by Customer Report
I have customized a Sales by Customer report to show the items purchased by each customer over a specific period of time, each item shows quantity, sale price, purchase price, revenue, etc.
The problem is it lists the items by transaction, so if a customer buys the same item 3 times in a 6month period, the item will list 3 separate times. I want it to consolidate the different transaction lines into one summed line.
Instead of 'Item A" listed 3 times with qty 5 and revenue $20 on each line, I want one line of Item A showing 15 total qty and the total revenue $60.
0