The Inventory Listing produces an report of the inventory items that exist in each of your warehouse locations. The report outputs the warehouse location, item number, item description, default bin location and the on hand quantity for each of the items that are included on the report.
Selection Options: The Inventory Listing report includes the following selection options.
• Location EQ: Selects only Inventory Items in the selected inventory or warehouse location. If no location is specified, the report will include all inventory locations.
• Item Number Range: Allows you to select a range of inventory item numbers. The prompt buttons on the right hand side of the from and to windows can be used to display the Catalog Lookup program which can be used to specify the item number range to be included on the report.
• Description Range: Allows you to select a range of inventory items based on the item description. The prompt buttons that are located to the right of the selection can be used to activate the Catalog Lookup program which allows you to locate and select the description range to be used for the report.
• Prodline EQ: Selects only the Inventory Items which are assigned to the specified product line. The prompt button located on the right side of the selection window can be used to display the Prodline Selection list which can be used to select the product line to be used for the report.
• Group Eq: Selects only the Inventory Items which are assigned to the selected product group. The prompt button that is located on the right side of the window can be used to display the Group Selection list which can be used to select the product group to be used for the report.
• Class IN: Includes only the inventory items that are assigned to one of the product classes specified for the selection.
• Status In: Includes only inventory items which are assigned a status matching the status specified. Valid Inventory Status codes include A (active), H (hold) and I (inactive). The Inventory Valuation report defaults to include all 3 status codes.
• Inventory Default Vendor: Includes only the Inventory Items which have the specified vendor assigned as the default vendor for the item. The prompt button that is located next to the selection window can be used to display the Vendor Lookup program which allows you to locate and select the vendor to be used for the report.
• Buyer Eq: Includes only the Inventory items which are assigned to the specified Buyer in the Inventory Master file. The prompt button that is located to the right of the selection window can be used to activate the Salesman Selection List which allows you to locate and select the buyer to be used for the report.
• Product Description Sequence: This selection allows you to output the Inventory Listing in Product Description Sequence. The report defaults to output the selected item in location/item number sequence.
Output Format:
The following section displays a sample of the output produced by the Inventory Listing Report. This sample is based on the default List and Label Template for the report that is provided by Cove Systems. Please note that the report output and selection information can also be customized using the Advanced Reporting Options and the Design report options that are available in the system.
More: