Inventory Aging Report

[former_member677811]

Hi,

Please provide Inventory Aging Report With Days Segregation 30,60,90,180,180+.

[former_member320372 · Accepted solution]

Hi,

Try this below Query. But it'll give you the aging for serial based items.

/Inventory Aging Report for Serial Number Item//

SELECT
T0.ItemCode,
T0.OnHand,
(SELECT COUNT(1) FROM OSRI WHERE DATEDIFF(DAY, InDate, GETDATE()) < 45 AND Status = 0 AND ItemCode = T0.ItemCode) AS ‘<45 Days(Qty)’,
(SELECT COUNT(1) FROM OSRI WHERE DATEDIFF(DAY, InDate,GETDATE()) >= 45 AND DATEDIFF(DAY, InDate, GETDATE()) < 90 AND Status=’0′ AND ItemCode = T0.ItemCode) AS ’45 to 90 Days(Qty)’,
(SELECT COUNT(1) FROM OSRI WHERE DATEDIFF(DAY, InDate,GETDATE()) >= 90 AND DATEDIFF(DAY, InDate, GETDATE()) < 180 AND Status=’0′ AND ItemCode = T0.ItemCode) AS ’90 to 180 Days(Qty)’ ,
(SELECT COUNT(1) FROM OSRI WHERE DATEDIFF(DAY, InDate,GETDATE()) >= 180 AND Status=’0′ AND ItemCode = T0.ItemCode) AS ‘>180 Days(Qty)’
FROM
OITM T0
WHERE
T0.OnHand > 0

AND T0.ManSerNum = ‘Y’

[ashishrbyadav]

THIS REPORT IS FOR ONLY ITEMS WHICH IS MANAGED BY SERIAL NUMBER MANAGEMENT