Skip to Content
0
Former Member
Jan 31, 2009 at 07:42 AM

Inventory Ageing Report Warehouse wise

132 Views

Hi all,

i urgently require a query from which we can get data for inventory ageing warehouse wise!

the data i want is in the following criteria:

selection criteria1 would be the date, 2nd would be warehouse,

the query that we are expecting should get us the "in stock" of the item on that particular date along with the goods receipt and the goods issued that is the in quantity and out quantity from OINM by FIFO, in intervals of 0-365, 365-730 and greater than 730.

Can anyone please suggest a query that would fetch these details? Hope to hear from you at the earliest.

Thanks & Regards,

Joseph Antony