Report Inventory Aging by Product
(Inventory Aging Report)
Access
Use this report to display aging information for selected products. Selection criteria includes the following:
-
model number
-
product group
-
product category
-
brand
-
location
-
age (in days)
The option to include assigned pieces is also available. Primary sort is by location code.
The output of this report may be affected by Regional Processing restrictions.
If you select specific products at the Product field, you inactivate the Brand field.
ProductIndicate the product or products to be included in this report. One, multiple, or All products may be selected. To report on a single product select a specific product ID at this field. To report on All Products, leave this field blank. To report on multiple products, use the Multiple Product Selection screen (available from Actions) to select the products for this report.
GroupIndicate the product group or groups to be included in this report. One, multiple, or All groups may be selected. To report on a single group select a specific group code at this field. To report on All Groups, leave this field blank. To report on multiple groups, use the Multiple Product Group Selection screen (available from Actions) to select the groups for this report.
CategoryIndicate the category or categories to be included in this report. One, multiple, or All categories may be selected. To report on a single category select a specific category code at this field. To report on All Categories, leave this field blank. To report on multiple categories, use the Multiple Product Category Selection screen (available from Actions) to select the categories for this report.
BrandIndicate the brand or brands to be included in this report. One, multiple, or All brands may be selected. To report on a single brand, select a specific brand code at this field. To report on All Brands, leave this field blank. To report on multiple brands, use the Multiple Brand Selection screen (available from Actions) to select the brands for this report.
Region
LocationEnter the locations you want to include in this report. If you know the code of the location, enter it directly. If you click on the Arrow, you can choose a location from the list that appears. If you select Multiple Locations from the list, you access the Multiple Locations Selection Window, from which you can choose one or more locations. You can also access the Multiple Locations Selection window if you click on the Action button. If you click on the Search button in the Multiple Locations Selection Window, you access the Multiple Selection Lookup Window. Use this window to select all locations (that is, all locations available to you) by clicking on Select All.
At this and any other Location field, the locations you see (that is, the list of locations available to you) may be affected by Regional Processing restrictions.
Aged DaysEnter the age, in days, to include on this report. The report includes items older than the number of days you specify here.
Include Assigned PiecesTo include assigned (committed) in this report, check the box. Otherwise. leave the field blank.
Inventory TypeSelect the type of inventory to be reported. Select All Inventory for both retail and service parts products; select Retail Inventory to report on retail products only; select Parts Inventory to report on service parts products only.
Send Output toThe output destination of the report displays. To change the output destination, click on the Actions button and select Output Settings.
Export PathIf you select either the Personal Report Viewer (PRV), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.


Once the run-time options have been selected, choose Run to produce the report.