Item Stock ageing period

Modified on Wed, 06 Mar 2024 at 12:22 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 8th August 2015, 70 packets on 1st July 2015, 155 packets on 2nd March 2015, 200 packets on 24th september2014, and today is 10th 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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article