Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NetSuite has launched SuiteSuccess Wholesale Distribution Edition, in Japan. Please join us the webinar on February 12 that introduces NetSuite solution with demos and case studies for Wholesale Industry.
Register Now
SSP Allocations Report | Custom Field Returning Same Result for Multiple Lines
Hello
For a report that the community helped me build last year (thank you), an issue has been presented by the AR team :
We have a custom field available, Salesforce Line ID (our SF and NS are not integrated at this time), that houses an individual Product ID for each item on a Sales Order/Invoice/Revenue Arrangement.
For the purposes of the report above, we have pulled this field in from 'Source Number : Salesforce Line ID', so pulling the result from the custom field at the line level on the source transaction.
This is pulling in data from the indicated field, however, we are seeing the data duplicate in this singular column of results. The saved search results are at a Summary level, and we have several elements of the results set to 'Maximum of', but this element and two others are set to 'Group'. The two other elements are not returning duplicative results, only this particular data point is returning duplicates.
Melissa
NetSuite Certified Administrator