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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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