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.