I'm trying to create a price list report for a customer that displays the lowest price available for an item per customer. I've tried using the old functionality and the forthcoming price management functionality and both are doing the same thing.
What I would like to happen is that I would select a customer and an item and it displays the lowest price available to that customer (whether that be from the all customer pricing, the individual customer pricing or the price group assigned to the customer).
If I select customer as the type, I'm not getting the lowest price for that customer (the price from the price group), I have to select price group as the type to see this.
Does anyone know if there is a report that actually displays the lowest price available to a customer (across all sales types), or a way to do this?
Thank you.