Report Inventory Aging by Location
(Inventory Aging Summary Report)
Access
Tabs: Selection, Sort
Use this routine to report on quantity and cost totals, by location, broken down under 0-30, 31-60, 61-90, 91+ columns according to the age of the inventory items.
Selection
RegionEnter the code of the region whose inventory you want to include in this report. If you click on the Arrow button, a list of regions appears from which you can choose one or more. If you click on the Action button, the Multiple Region Selection Window appears from which you can choose one or more regions. If you leave the field blank, you select all regions. If you select multiple regions, ‘ … ‘ appears in the field. Your selection displays to the right of the field. Note that this field is active only if you leave the Warehouse Location field blank.
Warehouse LocationEnter the code of the warehouse location whose inventory you want to include in this report. If you click on the Arrow button, a list of locations appears from which you can choose one or more. If you click on the Action button, the Multiple Location Selection Window appears from which you can choose one or more locations. If you leave the field blank, you select all locations. If you select multiple locations, ‘ … ‘ appears in the field. Your selection displays to the right of the field. Note that this field is active only if you leave the Region field blank.
ProductEnter the code for one or more products you want to include in this report. If you click on the Action button, the Multiple Product Selection window appears where you can select one or more products for this report. To include all products in the report, leave the field blank. Your selection displays to the right of the field.
Product GroupEnter the code for one or more product groups you want to include in this report. If you click on the Search button, you can choose from a list of product codes. If you click on the Action button, the Multiple Product Group Selection window appears where you can select one or more product groups for this report. To include all product groups in the report, leave the field blank. Your selection displays to the right of the field.
Product CategoryEnter the code for one or more product categories you want to include in this report. If you click on the Search button, a list of product categories from which you can choose If you click on the Action button, the Multiple Product Category Selection window appears from which you can select one or more product categories for this report. To include all product categories in the report, leave the field blank. Your selection displays to the right of the field.
BrandEnter the code for one or more brands you want to include in this report. If you click on the Search button, you can choose from a list of brands. If you click on the Action button, the Multiple Brand Selection window appears where you can select one or more brands for this report. To include all brands in the report, leave the field blank. Your selection displays to the right of the field.
VendorEnter the code for one or more brands you want to include in this report. If you click on the Search button, you can choose from a list of brands. If you click on the Action button, the Multiple Brand Selection window appears where you can select one or more brands for this report. To include all brands in the report, leave the field blank. Your selection displays to the right of the field.
Costing
Special Order
Products With Inactive Purchase Status
Inventory Type
Reason Codes (Include/Exclude)
Reason Codes
Sort
Note that to sort by region, Regional Processing must be active.
Primary Sort
BreakTo include subtotals for each item of primary sort criteria, click the box. For example, if you choose Location as your primary sort criteria, the report includes subtotals for each location.
Secondary Sort
BreakTo include subtotals for each item of secondary sort criteria, click the box. For example, if you choose Product as your secondary sort criteria, the report includes subtotals for each product.
Tertiary Sort
BreakTo include subtotals for each item of tertiary sort criteria, click the box. For example, if you choose Region as your tertiary sort criteria, the report includes subtotals for each region.
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.