Hi,
We have a requirement for creating a Stock Balance Report grouped on Item groups and Items within warehouses. So, typically the stock balance report should look like this:
Item Group Item Warehouse Opening Qty In Qty Out Qty Balance Qty
Products P1 W1 50 10 20 40
W2 30 5 15 15
P2 W1 25 1 2 24
Services P3 W1 45 5 10 40
W2 80 10 20 70
The current Stock Balance report gives an entire list of items. How can I group these list of items?
Please advise.
Thanks
Uma