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
Please note that on Friday, March 20, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 4 hours. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Items with multiple price levels, best practice for combining in searches?
Hello. Have a slight issue here. Which is caused by us having the "multiple price levels" feature enabled.
Consider these results for an Item search:
This search causes a new item row to be printed for every occurrence of Price:level. (Lets say I have 2 price levels: Retail and Dealer).The item will be listed in two different rows, once showing the Retail price, and another time showing Dealer. So if I had 1,000 items in this report, there would be 2,000 rows.
This is not what I want .. I NEED there to be only one row per every item found (each row being unique using the vendor part number column as a unique ID in excel). I need the price to be printed in different columns, not different rows.
0