This report lists the quantity and dollar amount of each product purchased during a designated period of time. You can print the report in a detail or summary format.
To run the Product Purchases Report:
From the Reprts > End of Month Reports > Product Sales Reports menu, select Product Purchases to display the Product Purchases Report screen.
In the Br/Tr/All field, enter the branch or territory to include in this report. To include all branches and territories, enter ALL.
In the Start Date field, enter the first date in a range of dates for which to view purchases. This field supports variable dates.
In the End Date field, enter the last date in the range of dates for which to view purchases. This field supports variable dates.
In the Select By field, indicate whether to run the report for buy lines, buy groups, price lines, sell groups, or products. Based on your selection, the system names the next field accordingly. For example, if you enter Price Line in the Select By field, the next field is called Price Line.
In the (Buy Line / Buy Group / Price Line / Sell Group / Product) field, enter the value to use to select a subset of transactions for the report’s purchase analysis. Use the Multi Items hot key to enter multiple values. *Multi* displays in the field.
In the Sort By field, indicate whether to sort the data on the report by a specific column or group of columns. The default value is by Vendor.
In the Detail/Summary field, indicate what level of detail to print on the report.
Detail – Lists each transaction for each product.
Summary – Totals the transactions for each product.
In the Product Loc Qty Type field, select products for the report based on their return status type, such as Stock or Defective.
In the Vendor field, enter the vendor for which to run the report.
In the Directs (Inc/Exc/Only) field, indicate whether to include, exclude or run the report for direct orders only.
In the Returns (Inc/Exc/Only) field, indicate whether to include, exclude or run the report for returned items only
In the Vendor Consignments (Inc/Exc/Only) field, indicate whether to include, exclude or run the report for vendor consignment items only.
See Also: