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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.