Tying Together the Item Group Tree and Reporting

[JayRam]

Stock Balance Report - Grouped on Item Groups

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 Servic…

@UmaG: Can you please work with Frappe and contribute your stock balance code typing in Item Group back to ERPNext. I’m reasonably certain everybody will need this as the whole point of setting up item groups and the hierarchy (tree) is for reporting purposes.

Thanks

Jay

[UmaG]

Jay,

I have sent a pull request for the same.

https://github.com/frappe/erpnext/pull/7965

Regards
Uma