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
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.