How can I see list or report that products bought by customer or partner with price and balance?
Example:
Customer | jhon smith | ||||
Date | Sales Order Number | Product | Unit | Price | Customer Balance (cumulative) |
10.01.2015 | SO1 | Ipod | 1 | 100 | 100 |
10.01.2015 | SO1 | Apple | 2 | 5 | 110 |
11.01.2015 | SO2 | Computer | 1 | 500 | 610 |
12.01.2015 | SO3 | Ipod | 1 | 100 | 710 |