Running the Product Sales Analysis Report
- Open the Product Sales Analysis Report.
-
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.
-
For these fields, select a range of values to include in the
report:
- Product Code
- Family Code (Range)
- Item (Range)
- Click Preview to view the output before running the report.
- Click Print to run the report and print the output.
Parent topic: Finance Module