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 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
NSAW Invoice Data Returns Null if Sales Rep is a Group
I discovered an issue with an NSAW report I've been using where if the sales rep on an invoice is an employee group, the invoice is excluded from the data. I can look at the raw NetSuite - Customer Invoice data from the standard NSAW sales pipeline and see the invoice information, but if I include any data from the Sales Representative table, the data goes null if the transaction sales rep is a group.
Has anybody seen this before and knows a way to fix this?
Tagged:
0