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!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Sales by Item Summary Report - Error in Quantity Sold
Hi All - as a newbie, this is my first post. help very appreciated.
I am trying to use the Item Summary Report to see how many of each item we sold. However, I have found that in cases where an invoice received 2 or more payments until paid in full, the items associated with that invoice are (incorrectly) summed for each payment instance associated with that invoice. This is confirmed by drilling into an item in the summary report to see the transactions associated with the total. An example:
The Item Detail Report correctly shows the following information - 3 partial payments against one invoice for a particular item that we sold two of for a unit price of $50, or a total revenue of $100:
0