The PRODUCT REPORT lists all the products as selected and included quantity and value information. (Note that "value" is based on unit cost of a product and will only display for users who have been granted permissions to see costs on products.) It is sorted and printed by product category, then by product description. The report will list product number, description and quantity on hand. This report is useful as an inventory value worksheet.
The screen prompts are:
SELECT BY - Select to run this report by either LOCATION (if your user id is not configured with multiple location access, this field will be disabled) or by reporting REGION (if reporting regions have been configured within CONFIGURE SYSTEM SETTINGS > SYSTEM > REGION INFORMATION.)
REGION - If selecting to run this report by reporting REGION (above), “ALL REGIONS” will display by default. Use the drop down selection window to select to run this report for a specific region, or leave "ALL REGIONS". If running this report by reporting REGION, individual regions cannot be selected.
LOCATION - If running this report by LOCATION (above), select the specific location for which this report is to be run. Select either <ALL>, to run for all locations to which your user id has permissions, <SEL> to run for select locations to which your user id has permissions, or select one location from the list to which your user id has permissions.
ALL CATEGORIES - If this box is checked, the report will run for all product categories. Individual categories cannot be selected when this is checked.
CATEGORY - From the drop-down list, select the category for the report is to be run.
INCLUDE INACTIVE ITEMS - Indicate if inactive products are to appear on your Product Report.
PRINT VENDOR PRODUCT # - Indicate if the vendor's product number is to appear on the Product Report.
SORT OPTIONS - From the available options, indicate if the report is to sort by Category or Manufacturer.
PRODUCTS TO INCLUDE - From the available options, select if the report is to include Stock, Non-Stock or Both.
PRODUCT TYPE - Select to run this Product Report on Serialized, Non-Serialized or both.
INCLUDE ITEMS ON LOAN - Check this box to have items on loan show on this report.
INCLUDE ITEMS ON RETURN ORDER - Check this box to include items that are currently on a return order.
REPORT OPTIONS - Choose whether to print the Product Report or Export it to Excel.
Click CONTINUE to run the report with the selected criteria.
(**The Product Report can run automatically as scheduled within the Windows Scheduler. Auditdata (Client Services Department) for more information on this and other automation processes that are available.)
Click EXIT to close the window.