Inventory Aging Report Shows Different Age Between Single and All Locations

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 receive date" (i.e., the date received from the PO or IM modules) for aging purposes.  When you use single location, we use either "last receive date" or "last transfer receiving date."  In this case, you probably have some recent transfers to this location, which causes the system to consider that as the age date and distort the aging calculation.

Why do we use two different standards between single and multiple locations?  This is because in a single location scenario, it is quite possible that there are no receiving transactions for that location.  Therefore, to limit aging calculation to receiving transactions only may cause a problem for a single location aging calculation. On the other hand, if we calculate aging for all locations, it would be reasonable to expect that the receiving takes place for at least one of the locations. Using that receiving transactions for aging would be accurate.

So when you run an Aging Report for a single location and multiple locations, the aging value may not match.  The bottom line is that it is not possible for us to give you accurate aging information for a single location if there are transfer transactions.  The aging report for all locations will always show the true aging information for your organization regardless of whether you use transfer transactions or not.

Please also refer to the following similar knowledge base article on this issue:






    • 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 by Location Sequence Produces Different Result Than by Other Sequence

      Q - When I run I/M -> Reports -> Inventory Aging Report, if I choose to run by "location" sequence, the aging result is different than if I run by another sequence (e.g., by item). See sample screen below. Why is that? A - There's an inherent design ...

    • 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 ...

    • Warehouse Replenishment - Single Bin Environment

      Generate Replenishment Transfer Batch Before running the Restocking Suggestion Report, the PICKBIN attribute must be set up for all items that require replenishment from a secondary bin. For more information on how to set this up go to ...

    • 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 ...