Inventory Aging Report

This report queries the item stockroom locations and item/warehouse records to determine the date of the last inventory receipt for a range of products. An inventory receipt could be from a purchase order receipt, completion of a job, or a customer order return.

You can display the results by warehouse, location, or by lot in groups of records displayed according to various time ranges, such as 30 days, 60 days, 90 days, or other ranges.

Aging for an item is determined by its latest transaction activity. Recent Purchase Order Receipt is an example of a transaction that affects an item's aging. If an item's latest activity consists of Move or Transfer types of transactions, the quantity is placed in the oldest aging bucket.