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.
Report Filtered by Multi-Select Custom Item Field Inaccurate
We have a multi-select type custom item field. When creating a Sales Order Transaction Report that filters by these selections, we get inconsistent results. When filtering by some selections in this multi-select custom item field, reports return no items. Other selection filters return only a couple of the items when 165 items have that option selected on the multi-select field. We have reviewed the Multi-Select Custom Item Field, the Custom List for this field, and the items trying to find a pattern.
One pattern we found was that if we filter a report by the items first or only selection from this multi-select field, it returns the item. For example, it an item has Blue, Green, and Red selected in this field. Our report filtered by Blue seems to work because its always the items first selection in the list. If we filter the report by Green, we only get the items where blue is not selected so that Green is the first or only item in the list. Because all items with red selected also have either blue or green selected,