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