Skip to Content
Jul 03, 2012 at 02:57 AM

Inventory Audit report query



Need to know whether anyone has written a query for SAP B1's Inventory Audit report? Reason for re-write query is because my customer requested to have Supplier PO number to be reflected in this report. As you know it only shows GRPO number, so I have to re-write it in query.

They also need Unit Cost. I have problem to calculate the unit cost as I couldnt get the cummulative qty from OINM table. Anyone has idea on this? Thanks in advance.