Running the Product Purchases Report

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:

  1. From the Reports > End of Month Reports > Product Sales Reports menu, select Product Purchases to display the Product Purchases Report window.

  1. In the Branch/Territory/All field, enter the branch or territory to include in this report. To include all branches and territories, enter ALL.

  2. In the Start Date field, enter the first date in a range of dates for which to view purchases. This field supports variable dates.

  3. In the End Date field, enter the last date in the range of dates for which to view purchases. This field supports variable dates.

  4. 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.

  5. 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 button to enter multiple values. *Multi* displays in the field.

  6. 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.

  7. In the Report Type field, indicate what level of detail to print on the report.

  1. In the Product Loc Qty Type field, select products for the report based on their return status type, such as Stock or Defective.

  2. In the Vendor field, enter the vendor for which to run the report.

  3. In the Directs field, indicate whether to include, exclude, or run the report for direct orders only.

  4. In the Vendor Consignments field, indicate whether to include, exclude, or run the report for vendor consignment items only.

  5. In the Vendor field, enter the vendor for which you want to run the report.

  6. In the Returns field, indicate whether to include, exclude, or run the report only for returned goods.

  7. Set options, if needed, and generate the report.

See Also:

Product Orders Report