Inventory Aging Report by Location Sequence Produces Different Result Than by Other Sequence
- Let’s say you have two warehouse locations, A and B.
- You received inventory for item 123 with a qty. of 10 to location A 365 days ago. It is sitting there, not selling. It shows up on the aging report with an age of 365 days.
- Someone transfers this item 123, qty. of 10, to location B today.
- If you run the inventory aging by location, it will show that location A for item 123 has a zero qty, so the age is zero. It will show that location B for this item has a qty. of 10, and the age is also zero because you just transferred it to location B today. You can see there’s something wrong here.
The paradox in number 4 above shows that there’s a flaw in inventory aging by location. But there’s not much we can do about it.
On the other hand, if you print inventory aging by another sequence (e.g., by item) and you choose to print all locations, then we treat all location transactions as a whole and ignore the transfer between locations. As a result, we will show the inventory aging for item 123 as 365 days. If you choose to print only one location, then you will have the same issue. As long as you understand there's a limitation in the inventory aging report by location sequence (i.e., the age days may be incorrect due to transfer), you can use the "by location" inventory aging report with this limitation.
Since inventory aging by location may be incorrect, is there ever a reason to use Inventory Aging Report by Location? Yes, there is. For example, you can't go back in time to print an Elliott inventory stock status report as of a certain date, so some users like to run an Inventory Aging Report as of a specified date as a way to produce a past inventory stock status report.
Please also refer to the other similar Knowledge Base article about inventory aging for one or all locations:
https://support.netcellent.com/portal/en/kb/articles/inventory-aging-report-shows-different-age-between-single-and-all-locations
Related Articles
Limitations for Inventory Aging Report
Release Date: 08/15/2018 The Inventory Aging Report is a very valuable tool. It is primarily used to determine the aging of the inventory for all locations for the current date, but you could use it for a specific location or use it to determine the ...Inventory Aging Report Shows Different Age Between Single and All Locations
Q: When I run the Inventory Aging Report for a single location, the age of the same inventory is more recent than if I run it for all locations. How could that happen? A: When you run an Inventory Aging Report for "All" locations, we use the "last ...IMAGESCN Inventory Management Inventory Aging Report
Inventory Aging Report Application Overview The inventory aging report can provide the current inventory data breakdown into multiple aging buckets, like 30, 60, 90, or over 90 days. The period is user definable in Global Setup and can be overridden ...How to Run Inventory Stock Status Report for a Certain Date
Release Date: 8/1/2017 Q - I am trying to run an inventory report by location as of 10/31/16. I know that the Stock Status is a live report generally, so I am not sure how I would do this. Is there a way? A - Generally speaking, there are three ...IM04S2 Inventory Management Inventory Transaction Audit Report
Inventory Transaction Audit Trail Report Application Overview The Inventory Transaction Audit Trail Report provides a complete history of transactions affecting on-hand levels of an item or range of items. The report is generated two different ways ...