PDA

View Full Version : Number of days inventory held



kalakriti
06-26-2019, 11:41 AM
Need a formula which will calculate number of days
of inventory held based on the transaction date
to calculate the ageing of the Qty

File attached for your reference



Thanks

Bob Phillips
06-26-2019, 12:00 PM
Do you just want to know how many days the amount of stock is greater than 0?

kalakriti
06-27-2019, 02:32 AM
Do you just want to know how many days the amount of stock is greater than 0?






item
1-30
31-60
61-90
91-120
121-365
>365


Qty -
ATRIC PREMIUM
0
45
126
0
0
0


No of days


???
???







looking for something similar , in which i need to find out the days , based on FIFO


hope i have explained it.

Thanks for your assistance


regards