Stock Balance Report - Grouped on Item Groups


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.


Please close this issue. I was able to write Python code for this…