Skip to Content

Inventory Aging Report

Hi,

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 09 at 07:12 AM

    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’

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27 at 01:03 PM

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

    Add comment
    10|10000 characters needed characters exceeded