Discussions
SuiteWorld is where the NetSuite community comes together to learn, connect, and discover what’s next.
Whether you’re looking for product updates, practical tips, new ways to improve efficiency, or insights from other customers, SuiteWorld offers something for every stage of your NetSuite journey.
■ NetSuite 2026.2 Release Notes
■ NetSuite SuiteApps Release Notes
■ NetSuite Sneak Peeks
■ Release Preview Guide
■ Release Preview Test Plan Template
Cash Sales adding unexpected lines to searches
Hi, everyone,
(Firstly note that I realize there is a Sales by Item report. I am making a saved search of it for other reasons)
A little history: For go-live, we decided that we were going to import some historical sales data. We did this by creating one cash sale for every month that we wanted to save. Each cash sale held the quantity of every item we sold that month (they're big cash sales). It all worked great.
Now, I am creating a saved search that shows quantity sold per item per month. I have included Invoices and Return Authorizations as the types of transactions to include in the search, but I realized that I could get monthly data for months prior to go-live by including the cash sale transactions. However, when I do, the report doesn't show an additional line for each month, but