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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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