Number of days inventory held

[kalakriti]

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]

Do you just want to know how many days the amount of stock is greater than 0?

[kalakriti]

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