I need a report for stock out. If someone help me how can I achieve the task (Qweb, Pentaho etc). Needed values are as under.
Product Name, Product Qty, Average Price (Used in sale orders), Sub Total.
Needed Filters are Date Range, Sales Person, Customer Category(tag),
Below is an example. hope that some one will help.
Sales Person: Administrator Date: Today Customers Area: Urban
| Name | Qty | Price (Average) | Sub Total |
| Digital Router Board | 5 | 100 | 500 |
| LCD Monitor | 2 | 100 | 200 |
| Totals | 7 | 700 |
In Above Table I had tried to show the results. here product like as digital router board is sold 5 times in 5 separate orders by a salesperson EX: Administrator and customers that purchased it are from EX: Urban Area and date is today.
Any help will be greatly appreciated.
