Item Stock ageing period

Modified on Fri, 6 Dec at 5:08 PM

How to find out the Item Stock ageing period (0-180 days, 180-365 days, and Above 365) with respect to the stock date?

'StockQuantity' is the total available stock of the item as on today and StockDate is the stock received date.

UDDC Name : Stock Ageing Period

UDDC Formula : whenThen(noOfDaysByDate(StockDate,today()),(noOfDaysByDate(StockDate,today())>0&&noOfDaysByDate(StockDate,today())<=180),"0-180days",(noOfDaysByDate(StockDate,today())<=365&&noOfDaysByDate(StockDate,today())>180),"180-365 days","Above 365")

The Stock ageing period is calculated like this. If the number of days between stock received date and today is less than or equal to 180, then those stock will be considered under “0-180 days” stock. If it is greater than 180 and less than or equal to 365, then it will be considered under “180-365 days” stock , rest of all will come under “Above 365” days stock.

e.g: There are 240 cornflakes packets received on 8^th August 2015, 70 packets on 1^st July 2015, 155 packets on 2^nd March 2015, 200 packets on 24^th september2014, and today is 10^th November 2015.

In the ageing analysis, under “0-180 days” category, there will be 310 packets. Under “180-365 days” category, there will be 155 packets.
Under “Above 365” category, there will be 200 packets.

Item Stock Ageing period stock date Stock Quantity UDDC formula Business Intelligence Support Business Intelligence Articles Business Intelligence Training Smarten Support Smarten Knowledgebase Smarten Articles Smarten Training crosstab Tabular Geomap Graphs Smarten View Visualization