Inventory Audit report query

[too_muihwee]

Hi,

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.

[Former Member]

Hi Mui,

Please check this post: Inventory Audit Report |

Let me know if you have any questions or need help to add any info to the queries.

Best Regards,

Rafael Oliveira

[Former Member]

Hi,

You may check this link....

http://wiki.sdn.sap.com/wiki/display/B1/SAP+B1+SQL+H-IN+Item+Inventory+Opening+and+Closing+Stock+per...

Thanks,

Priya

[too_muihwee]

Hi Priya,

Thanks for your reply, but the link showing report for summary qty instead of details and then each row it shows the cummulative qty like SAP standard Inventory Audit report. Still looking for answers.

[Former Member]

Hi.......

If you want to make Inventory Audit Query then please refer OINM Table where you get all the inventory journal details.........

Regards,

Rahul

[former_member541807]

hi Too Mui Hwee,

you may check this thread

http://scn.sap.com/thread/2064822

http://scn.sap.com/thread/1889531

http://scn.sap.com/thread/1409449

http://scn.sap.com/thread/1974390

http://scn.sap.com/thread/3146906

regards,

Fidel