Skip to Content
0
Former Member
May 18, 2010 at 01:20 PM

SQL Query for Stock Audit

1058 Views

Hi All,

I need SQL Query for Stock audit. I tried in inventory audit report in SAP B1 2007 B, But there is no Serial No

and Mfr Catlog No in that report.

I tried this query

SELECT T0.ItemCode, T0.ItemName, T0.IntrSerial, T0.CardCode, T0.CardName , T1.[SuppCatNum], T1.[OnHand] FROM OSRI T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode WHERE T1.[ItmsGrpCod] = 100

But this query retrive data current date instock only . i need instock on particular date Example : i want take stock audit for 09-10 year so i need instock on 31.03.2010.

thank you