Please can someone give me an idea how I can create a report that looks at a customer and shows each of the their associated price lists? They buy via different Merchants and so get different prices. See example table below:
| CUSTOMER | MERCHANT 1 | MERCHANT 2 | MERCHANT 3 |
| Price List Item | |||
| product 1 | price 1/1 | price 2/1 | price 3/1 |
| product 2 | price 1/2 | price 2/2 | price 3/2 |
| product 3 | price 1/3 | price 2/3 | price 3/3 |
I have tried Reports and Advanced Find but none will drill down to the level of product and price?
Can anyone please help??
*This post is locked for comments
I have the same question (0)

Report
All responses (
Answers (