Inventory Location Catalog

The Inventory Location Catalog Report is a listing by location and system showing the part number, manufacturer, commodity and the seasonal part status.

 

In the Options area, select the Layout. The Standard Layout is formatted with field and group headings for easy viewing and printing. The Export Layout is formatted in columns to facilitate migration of the data into other programs like Excel. For Export, choose to hide the Header or not. In the Report Prompts area select the Group option if desired. In the filters area enable any fields you would like to use for filtering the data to be included on the report. Note that selecting a field for a filter does not cause that field to appear on the report. It becomes a search filter only to qualify which records are included. The fields that appear on the report are shown below. To save your parameters for repeated use enter a Parameter File Name under the report title and click on Save Parameters.

 

Click on Schedule to run your report. Select your Run Interval and any associated Dates and Times. Next define your Output Destination options, save them if desired and click on Schedule. A Report Schedule Confirmation screen will appear with the Job Number Id and other output information. Proceed to the Report Bin to retrieve and view the report when it's completed.

 

 

Database Tables

Data Fields/Columns

Grouping/Sorting

 

 

 

Company_Main Part Number Group 1
Loc_Gen Manufacturer     Defaults to Location
Manufacturer Part Description Group 2
Part_Code_Season Commodity     User Selection
Part_Inv_Store Season Sort By
Part_Orders NoStck     Defaults to Part Number
Part_Req Consgn  
Part_Xref Serial  
Parts

Acct

 
Po_Commodity

Dept

 
Unit_Sys

Core

 
Unit_Syscomp

Allow AutoRe

 
Unit_Syscomppart

UABC

 
Vendor

SABC

 
Vendor_Sec

 

 
Parts_Part_Inv_Loc

 

 

 

For more information see Anatomy of an M5 Report and the FleetFocus M5 Inventory Reports Guide.

 

 

 

NOTE: To view a list of System Flags and Role Privileges that may impact this screen, hover over the screen title in M5 to display the bubble help/tooltip. At the bottom of the bubble help/tool tip, there is a Settings hyperlink. Click that hyperlink to display the list of flags and privileges.

 

Additional training and technical documents on this subject may be available in the Resource Files area.