This report provides a list of Purchase Orders Grouped by the Purchase Order Line Account. The report provides a Sub Totals by Purchase Order Account and Grand Totals. Also Totals Received and Totals Remaining.
Note: If a Purchase Order has multiple lines and those lines have different accounts the Purchase Order Number will appear for each Line Account Grouping.
Note: This report does not allow for configuration as all columns must be present and in their preconfigured location to provide the information required for this report.
Select the Date Range desired and the Report will display all records for that date range.
A sample report is shown below of what your report may look like:
The report display page has several options as shown in the video below.
The chart below provides descriptions of the columns:
| Column | Description |
| Header Columns |
|
| Purchase Order | Purchase Order Number |
| Reason | Description of Reason entered on Purchase Order |
| Vendor | Vendor ID of Purchase Order Vendor
|
Vendor Name
| Name of Purchase Order Vendor |
| Status | Status of Purchase Order |
| Order Date | Date the Purchase Order was created |
| Line Columns |
|
| Line No. | Purchase Order Line Number |
| Part Id | Inventory Part - Part ID for Inventory items or << Non-Stock>> for Non Inventory items |
| Description | Description of item being ordered |
| UOM | Unit of Measure of the Purchase Order Line Item |
| Unit Cost | Per Unit Cost of the Line Item
|
| Qty Received | Received Quantity of the Purchase Order Line Item
|
| Received Cost | Cost of Quantity Received |
| Qty Remaining | Difference between Order Quantity and Received Quantity
|
| Remaining Cost | Total Cost of Quantity remaining |
| Status | Purchase Order Line Status |
Account Total
|
|
| Account Number | Account Number for this Grouping |
| Total Received | Total Cost of all Received for this Account |
| Total Remaining | Total Remaining Cost for this Account |
| Total | Total for this Account |
| Report Footer |
| Grand Total of Line Received | Grand Total of all Lines for All Accounts Received |
Grand Total of Line Remaining
| Grand Total of all Lines for All Accounts Remaining Cost |
| Grand Total of Line Total | Grand Total of All Accounts for All Lines |