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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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