Running the Product Sales Analysis Report

  1. Open the Product Sales Analysis Report.
  2. On the form, specify this information:
    Use Price or Quantity
    Select Price to base the report on the invoiced price of the items or select Quantity to base the report on the quantity of the items.
    Sort By
    Select one of the following options for sorting the report:
    • Product Code: The report first sorts by product code, then by Item. It then gives a total by product code after each product code section and shows a grand total of all items at the end of the report.
    • Family Code: The report sorts by family code, then by Item. It then gives a total by family code after each family code section and shows a grand total of all items at the end of the report.
    Display Report Header
    Select this check box to include report headers in the output.
    As of Date
    Select a date to use as the last possible due date of a line item in order to qualify for this report. Any line item with a due date earlier than this date is included in the report. The current date is used by default.
    Increment Date
    Select this check box to automatically increment the date range and re-run the report.
  3. For these fields, select a range of values to include in the report:
    • Product Code
    • Family Code (Range)
    • Item (Range)
  4. Click Preview to view the output before running the report.
  5. Click Print to run the report and print the output.