You can run a report listing the breakdown of the inventory aging, which you can use to identify the oldest part or parts in your inventory. The parts are grouped in aging categories of 0 to 3 months, 4 to 6 months, 7 to 9 months, 10 to 12 months, 13 to 18 months, 19 to 24 months, and over 24 months old. It also lists the total part numbers and cost for the full inventory and the inventory more than 365 days old. From this report, you can drill down into the individual part numbers that make up each aging category.
Step 1. From the Parts Inventory main menu, select Reports.
Step 2. The Inventory Reports menu will open. Click Inventory Analysis.
Step 3. On the Inventory Analysis menu, select Age Analysis.
Step 4. An Age Analysis pop-up will open. Type the subsource number you want to report on or leave the For SubSource field blank (and press ENTER) to report on all subsources.
Step 5. A pop-up will verify that you want to compile the report. Click OK. The Inventory Analysis report will open in a separate screen.
Step 6. Click on a line of the report to view a list of the parts in that particular age bracket. When viewing the detail for a line, a single asterisk (*) next to a part number's extended value (Ext.) indicates the value includes the on-hand quantity of the part as well as clean and dirty core values associated with this part. Two asterisks (**) next to the on-hand quantity (O/H) indicate the value is related to dirty cores only, and there is a negative on-hand quantity of the actual part. If there is a zero (0) on-hand quantity with dirty cores associated with a part, the report will show "0" (zero) as the on-hand quantity. The cost displayed is the cost of the part. The extended value (Ext.) will be the value of the dirty cores, and there will be a single asterisk (*) next to that extended value.
The Last Act. column lists the last time the part number was active.
Step 7. To print the report for an age bracket, click the Print button on the bottom of the Inventory Age Analysis screen. Select To Printer to print a hardcopy report, To Screen to view a PDF version of the report on screen (which can then be printed or saved), or Export to Excel to save the report as a Microsoft Excel document.
The Aged Parts List will list each part by part number and name, cost, extended value, last activity date, and location.
To print the general Inventory Analysis for SubSource report listing totals for each age range, click the Back button on the Inventory Age Analysis screen to return to the Inventory Analysis screen. Click the Print button on the Inventory Analysis screen instead of the Inventory Age Analysis screen. Select To Printer to print a hardcopy report, To Screen to view a PDF version of the report on screen (which can then be printed or saved), or Export to Excel to save the report as a Microsoft Excel document.
The Inventory Analysis for SubSource report lists each age range (0 to 3 months, 4 to 6 months, 7 to 9 months, 10 to 12 months, 13 to 18 months, 19 to 24 months, and greater than 24 months), the number of part numbers in each, as well as that age range's total cost and the percentage it represents of the total inventory for the subsource.
Other articles you may find helpful:
Running a Report of Price and Part Number changes from the Last Parts Tape
Running a Non-Stock Parts Report
Running a Report to Track Reduced Parts Sale Pricing
Reporting the Oldest Saved Counter Ticket
Reporting the Oldest Open Purchase Order
Reporting the Oldest Parts Accounts Receivable