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.
Please note that on Saturday, April 18, 2026, at 8:00 PM Pacific Time, our Case Management System will undergo a scheduled maintenance for approximately 15 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
How to filter Sales by Customer Report by Class?
We are using Class to categorize only Items. Then Class field value in Item records is selected from Class List values. Class List values are setup in a hierarchy for lesser to greater detail categorization.
The Class shows on both transactions in item lines, not main line. When creating a custom Sales by Customer report I used the Report Component Item and join field Item: Class as a filter to select only results for desired Items in specific Class categories. However, a report user has modified same custom report to add filter for Report Component Sales and Field Class = -No Class-. (screenshot below) The additional filter is returning very odd results.
0