The Purchase orders data source lets you report on orders you’ve placed with vendors: what was ordered, for which budget, how much has been received, and whether the order has been sent.
👉 To learn how to create and customize reports, see Getting Started With Reports.
When to Use Purchase Orders
Use it when you need to track what you’ve ordered from vendors and how much of it has been received. Here are some common reports and the fields to build them with.
Orders not fully received
Received and Total amount are already in a new report. Add Payment status and group by it.
Spend per vendor
Vendor is already in a new report. Group by it.
Orders per budget or project
Budget is already in a new report. Group by it, or add Project.
Orders that haven’t been sent
Filter Status to Finalized and Sent status to Unsent.
Upcoming deliveries
Delivery date is already in a new report. Sort by it.
📌 Amounts are shown in each purchase order’s own currency, and totals in your organization’s default currency. To see everything in one currency, use the Currency option above the report.
Example: Payment Status
Payment status compares Received with Total amount. The numbers are for illustration.
PO number | Total amount | Received | Payment status |
PO-1 | 1,000 | 0 | Not received |
PO-2 | 1,000 | 600 | Partially received |
PO-3 | 1,000 | 1,000 | Fully received |
Received is the sum of the received amounts on the purchase order’s bills.
Payment Status Means Received, Not Paid
Despite its name, Payment status shows how much of the order has been received on bills, not whether you paid the vendor. To see individual bills, use Bills.
Add Details From Related Items
Purchase orders has no related items with their own fields. To see the bills behind each order, use Bills.
Fields
Field | Description | Note |
Budget | The budget the purchase order was created for. |
|
Creator | The person who created the purchase order. |
|
Date of issue | The date the purchase order was issued. |
|
Delivery date | The date the order is expected to be delivered. |
|
Payment status | Whether the purchase order’s total has been received in full, in part, or not yet, based on its bills. | Calculated by comparing the Received amount with the Total amount. |
PO number | The unique number of the purchase order. |
|
Project | The project of the budget the purchase order is for. |
|
Received | The amount received on the purchase order so far. | The sum of the received amounts on all bills for this purchase order. |
Sent status | Whether the purchase order has been sent to the vendor. | Sent/Unsent. |
Status | Whether the purchase order is a draft or finalized. | Draft/Finalized. |
Subject | The subject of the purchase order. |
|
Total amount | The total amount of the purchase order, excluding tax. | Each purchase order is shown in its own currency. Totals are converted to your organization’s default currency. To see everything in one currency, use the Currency option above the report. |
Total amount (incl. tax) | The total amount of the purchase order, including tax. |
|
Total tax amount | The total tax on the purchase order. | The sum of the tax on each line item. |
Vendor | The vendor the purchase order was issued to. |
|