Dear All,
We required Query Report from SAP b1 Inventory Opening Balance, Stock IN Out & Closing successful beneath format
Sr.No | Inventory GL-Code | Item Group Name | Item code | Item Description | UOM | Price | Warehouse Code | Opening Balance | Opening Total Value | Incoming(GRN,Goods Receipt | Incoming Total Value | Outgoing, Goods Issue,Consumption | Closing Balance | Closing Total Value |
1 | 123456 | Raw Material | 2233556644 | XXXX | Nos | 7 | XXX | 100 | 700 | 15 | 105 | 15 | 100 | 700 |