Purchase Summary by Vendor
This report is a summary of purchases or purchase returns over a specified period of time, grouped by vendor (see Vendors, and Purchase Orders).
Report totals include the total number of purchases or returns and the total value ordered or returned, including a subtotal for each vendor. The report may be sorted by purchase vendor account number, purchase vendor name, or value ordered or returned. And it may be filtered by purchase vendor, business location, and whether to include purchase orders and/or purchase returns.
Report Option Fields
|
Field |
Description |
|
Vendor |
Enter an assigned purchase vendor account number for which to generate the report, 0 for miscellaneous vendor accounts, or leave blank for all vendors. Optionally, select the purchase vendor name for which to generate the report. |
|
Bus. Location |
Enter or select the business location for which to generate the report or leave blank for all business 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 purchase vendor account number, by purchase vendor name (the system default), or by value ordered or returned. The date range is based on the purchase order date. |
When reporting on multiple purchase orders for the same vendor, then if the vendor account varies from purchase order to purchase order then the most commonly used vendor account will be listed. The Total Ordered amount column totals are determined by multiplying the quantity ordered by the unit price on the corresponding purchase order detail line.
This report is available only in the Repair SQL, Repair, and Repair Mobile editions.
Serialized Inventory Listing