Skip to main content

Report Data Glossary: Purchase Orders

Field definitions for fields available in the Purchase orders data source in Productive Reports.

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.

Did this answer your question?