Overview
The Inventory Aging date is commonly misunderstood. Because of this we have put together an explanation of how that is calculated here:
Aging DEPENDs on the ledger. So ledger must be completely recorded
You CANNOT have negative inventory in ANY bin.
Inventory NET MOVEMENT column should be the same as the TOTAL of the aging report.
Aging is based on which BIN it was received in first.
Example, for an Item X
Receiver 1234
Bin A
Date 10/1/2025
Receiver 5678
Bin B
Date 12/1/2025
1 if the Ship Doc 1234 is picked from Bin B then the remaining Inventory will be dated 10/1/2025 because it will still be in bin A
2 if you do a bin move (transfer as well) from Bin A to Bin C on 11/1/2025 then the aging will remain as 10/1/2025 , we try to roll up the original date.
3 if you 0 out the inventory in a bin through an adjustment or count and then readd it on 11/15/2025 on another adjustment or count on 11/16/2025 then the date of that inventory will be 11/16/2025.
