Applies to: RollMaster (RM) Core
This article covers the Catalog Listing report, including report navigation, filtering options, print/export behavior, and available selection criteria used to generate catalog item listings from Catalog Maintenance data.
Does Not Cover: Catalog Maintenance record creation/editing.
Menu Path: Inventory Control > Reports > Catalog Listing
For other Inventory Control programs, refer to the Inventory Contol module documentation.
This report will print out a listing of all catalog items entered in the system. You can customize this report by selecting one or more of the available options. This report essentially consolidates the fields in the Catalog Maintenance module and prints that information for each product. When exporting to Excel, the data will match the current Catalog Material Import spreadsheet. This is important for customers who export areas of the catalog, make adjustments, and then reimport catalog items from the Special Functions module. When you enter the Catalog Listing report module, the screen will appear as follows:
The screen above allows you to make selections to customize the data on the report or export. You will need to make your selections prior to hitting the Print or Excel buttons. The Enable Short Print (1) option at the top left has taken the place of the Catalog Listing – Short option in the Inventory Reports menu. By clicking this box, you will see one line per catalog item instead of three as with the regular report.
In the Beg and Ending Product Code fields (2), you can select a specific Product Code, or enter a range of Product Codes, i.e., Material Product Codes. At the Product Type (3) field, use the drop-down arrow to select a specific type. At the Beginning and Ending Style (4) and Beginning and Ending Color (5) fields, again, you can program for a specific style and color, or a range, or just one style with all colors, etc. Use the Vendor (6) button if you wish to print for a specific Vendor. In the Inventory Option (7) box, accept the default Both option, or you can print Inventory Only items or Non Inventory Only items. The same applies in the Stocking Option (8) box.
The Print Options (9) box provides a few additional options to consider. The Only Print Items with no cost option was added to print items that don’t have pricing so they can be updated with accurate pricing. The Only Print Sample Items option is tied to the Sample / Size field in the Catalog Maintenance module. If you are using this field and only wish to see those styles that you have samples for in your showroom, click this option. The Include dropped items option should be checked to include Inactive styles on the report. The next option will only be available if you selected the previous option. The Only Include Dropped Items, when checked, will print only Inactive styles, and no Active styles. The next option, Print Barcode Numbers on All Items, should be checked to include this data on the report or export. The next option in this section, Show Edocs Exist, can be checked to include a notification of which styles have Edocs, but will only work on the Excel export. The final option, Include Retail Price (Not used on “Export Print”, should only be checked if you are printing the report, and even then, only if you require that detail, as adding data this will significantly slow the printing of the report. The Original Print option will default. If you want all the data available on the Excel export, select the Export Print (Excel Only) option.
When you have selected all of your customized sort options, click either the Excel or Print buttons to continue. You can also click the Cancel button to exit the module. If you have programmed the Catalog Roundup module (explained above), the “A-J Level Retail Price” display fields on this report will reflect that programming. If User Controls are in place and a User is not allowed to see cost, no costs will appear on this printed report and those Users will not be able to see the Vendor ID or Private Label data from the catalog. All User Controls can be found in the System Control Maintenance module.