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:
- SuiteAnswers ID 37894 – Saved Search to Show the Lowest Vendor Price per Item
- SuiteAnswers ID 66953 – Item Saved Search that Displays Preferred Vendor and Vendor Price
However, these examples still follow the standard row-based structure.
Recommended Workaround:
- Create a Saved Search that returns:
- Export the Saved Search results to Excel.
- Use Excel’s Pivot Table functionality to:
- Display one row per item
- Convert Vendor names into columns
- Display Vendor Costs side-by-side for easier comparison
This approach allows users to create the desired comparison table format outside of NetSuite while still leveraging NetSuite Saved Search data as the source.
