Getting Opening Stock

[Former Member]

Dear All,

Does anyone know how to get stock updates or stock at desired date at desired wear house, as we get it in audit report of inventory, i want to show this stock in my crystal report and not been able to do so. can anyone help me please.

Thanks and Regards,

Ahiresh Gaikwad

[Former Member · Accepted solution]

Please check this thread:

Thanks,

Gordon

[Former Member · Accepted solution]

Thank you for the reply

[Former Member]

Hi this is query for stock for perticular warehouse on a given date

SELECT T0.[ItemCode], T0.[Dscription], sum(T0.[InQty]- T0.[OutQty]) FROM

OINM T0 WHERE T0.[DocDate] <=getdate()

and T0.[Warehouse] =1

GROUP BY T0.[ItemCode], T0.[Dscription]

for opening of stock please filter the transtype = -2 for Opening Stock in the same table

Best Regards,

Umer Nasim