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
Filter Price List to show only items purchased by Customer
We've had a price increase and I'm trying to send multiple customers a price list showing the new price for items they have ordered in the past. I've created a price list via Transactions > Customers > Individual Price List.
This produces a list showing the customers net price for ALL 10,000 of our items using the item pricing group and the customers assigned price level for each pricing group.
Now I just need to filter this to show ONLY the items the customer has ordered in the past.
In the filter criteria I've found Customer Fields....Items Purchased but this forces me to input part numbers, which obviously I don't want to do, and shouldn't have to. It seems like this should be a simple thing to do, but I'm stuck.