Use the Product Sales History report to measure how much you sold of an individual item.
Note: You can display the product sales history on your purchase order Body tab continually using the View > Show Product Sales History which may provide the information you seek on a order by order basis without having to run the Product Sales History report.
To run the Product Sales History report:
From the Purchase >Reports, select Product Sales History, to display the Product Sales History criteria window.
In the Branch/Territory field, enter the branch or territory for which you want to run the report. Type ALL to include all branches and territories.
In the As of Date field, enter the ending date of the period to include on the report. The date must be equal to or earlier than the current date. Enter a calendar date or a variable date.
In the Select by field, use the drop-down list to select which kind of report you want to run:
Buy Line - Sets the variable field name and hot key to Buy Line. Use the Multi button to select more than one line, group, or product for the report.
Price Line - Sets the variable field name and hot key to Price Line. Use the Multi button to select more than one line, group, or product for the report.
Note: Selection in this field determines the purpose of the next field. For example, if you select Buy Line in the Line Type field, the next field displays as the Buy Line field and the Buy Line hot key activates.
In the Select Items field, identify the product status to include in the report:
Item | Displays... |
ALL | all products with any status. This is the default. |
ACTIVE ONLY | products that are stock, have an on-hand amount, or are on open orders. |
Stock | stock products. |
NonStock | non-stock items. |
MiscCharg | miscellaneous charges attached to the item. |
Delete | products that are scheduled to be deleted from the product file when the quantity reaches zero. |
Review | products that are in review. |
Comment | products wtih a comment attached. |
Purge | products scheduled to be purged from the catalog when the stock and on-hand amount reaches zero and all open orders are closed. |
LotItem | products identified for lot billing. |
Note: Product status is assigned in Product File Maintenance. See Product Status Codes for full descriptions.
In the Break on Line area, indicate how to separate prices lines or buy lines on the report to make it more readable:
Yes - Inserts a blank line between price lines or buy lines on the report.
No - Prints with no spacing between the price lines or buy lines on the report.
Page - Prints the data for each price line or buy line on a separate page.
In the Double Space area, indicate whether to insert a blank line between every product in every price line includes in the report.
In the ShowKits area, indicate whether to show kits on the report. The kit components are always listed at the top of the report.
In the Sum Branch Quantities area, indicate whether to print combined totals, if the report included more than one branch, for each product in every included price line:
Yes - Prints only combined totals for each product in every included price line.
No - Prints detailed branch totals without a combined total for each product in every included price line.
In the ShowFuture Ledger field, indicate whether to show the sales commitments on the report.
Note: If you select Include, there is no display limit and the system shows all future orders.
In the ShowItems w/ Sales Only field, indicate whether to show only items with sales on the report.
In the Sort By Order Point field, indicate if you want to sort product sales history by order point.
In the Directs field, indicate if you want to have direct orders listed on the report.
See Also: