This report is a summary of purchases or purchase returns over a specified period of time, grouped by part (see Purchase Orders). It is printed in landscape orientation.
Report totals include the total amount purchased or returned, including a subtotal for each part. The report may be sorted by part number, item description, or make and model. And it may be filtered by a part number or item description phrase as well as by make, model, business location, inventory location, and whether to include purchase orders and/or purchase returns.
Report Option Fields
Field |
Description |
Part No. |
Enter a part number for which to generate the report, leave blank for all part numbers, or use wildcard characters for multiple part numbers (see Filtering or Searching Data by Column (Field Filters) for a discussion of wildcard usage). |
Part Desc. |
Enter a part description for which to generate the report, leave blank for all part descriptions, or use wildcard characters for multiple part descriptions (see Filtering or Searching Data by Column (Field Filters) for a discussion of wildcard usage). |
Make |
Enter or select the make for which to generate the report or leave blank for all makes. |
Model |
Enter or select the model for which to generate the report or leave blank for all models. |
Bus. Location |
Enter or select the business location for which to generate the report or leave blank for all business locations. |
Inv. Location |
Enter or select the inventory location for which to generate the report or leave blank for all inventory locations. |
Group |
Select whether to include both purchase orders and purchase returns (the system default), only purchase orders, or only purchase returns. Purchase orders include orders with any status. |
Date Range |
Enter or select the starting date for records to include on the report or leave blank for all records before the ending date. Also enter or select the ending date for records to include on the report or leave blank for all records after the starting date. The date range is based on the purchase order date. |
Sort by |
Select the desired sort order, either by part number (the system default), by item description, or by make and model. |
If part descriptions entered with part numbers vary from purchase order to purchase order then the most commonly used part description will be listed. The Total Purchased amount column totals are determined by multiplying the quantity ordered by the unit price on the corresponding purchase order detail line. The Average Price column is the mean average.
This report is available only in the Repair SQL, Repair, and Repair Mobile editions.
More: