Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
NSC | Reporting Vendor Costs per Item in Separate Columns
Scenario:
The user wanted to create a report that displays multiple vendor costs for the same item side-by-side in separate columns for easier comparison. While standard saved searches could display vendor pricing information, the results only showed each vendor price as separate rows rather than consolidating all vendor prices into a single row per item.
Solution:
Standard NetSuite Saved Searches do not natively support a fully pivoted table format where:
- One row represents a single item
- Each vendor price appears in its own separate column
By default, vendor pricing results are displayed as separate rows for each vendor-item combination.
Relevant references include:
Niks Blando-Oracle | Ask A Guru?️
Learn how to Refer A Member|Earn the Answer Accepter Badge|Be the Content Creator of the Quarter|Vote for the content you want to see!
Expand your NetSuite knowledge by joining this month'sAsk A Guru Live about Advanced Accounting.RSVPon this event now!