What Is an Open Purchase Order Report?

An open purchase order report is the operational nerve center of the procurement function. It presents a complete, current view of every commitment a business has made to its vendors that has not yet been fully fulfilled — every order placed, every dollar committed, and every delivery promised but not yet received. Where the accounts payable aging report tracks money already owed for goods received, the open purchase order report tracks the layer before that: orders placed and in flight, representing future cash outflow and future inventory or expense recognition.

The open PO report answers a set of questions that procurement teams, operations leaders, and finance teams need answered continuously: what have we ordered that has not arrived yet? Which deliveries are at risk of being late? How much have we committed in total spend that has not yet hit the books as an invoice? And which partially received orders still have an outstanding balance that needs to be tracked to completion?

For operations and production planning teams, the open PO report is the supply visibility tool — confirming that raw materials, components, and supplies needed for upcoming production runs or fulfillment commitments are actually on order and tracking to arrive on time. For procurement teams, it is the active management queue — the list of orders that need expediting, vendor follow-up, or escalation. For finance teams, it is the foundation of the goods-received-not-invoiced (GR/NI) accrual calculation and a critical input to shortterm cash flow forecasting, since open PO commitments represent cash that will need to flow out of the business as deliveries are completed and invoiced.

Most ERP systems can produce a basic open PO list, but a list is not a report. A report that drives action surfaces the orders that are overdue, calculates the dollar value of risk exposure, separates fully open POs from partially received POs with remaining balances, and connects forward to the GR/NI accrual that finance needs at period-end. Building this operational intelligence layer on top of the raw ERP purchase order data is the reporting problem ReportingGuru solves.

Why Organizations Use Open Purchase Order Reports

Production and Fulfillment Planning Operations teams rely on the open PO report to confirm that materials and components needed for upcoming production schedules are genuinely on order and tracking toward on-time arrival. A production planner who discovers a critical component is two weeks overdue with no open PO report visibility learns about the problem only when the production line stops. A planner with real-time open PO visibility — including delivery risk flags — can expedite, substitute, or replan before the disruption occurs.
Delivery Risk Management and Expediting Not every open PO arrives on schedule. Vendors experience their own supply disruptions, shipping delays, and capacity constraints. The open PO report identifies which orders are approaching or past their promised delivery date — giving procurement teams the prioritized list of vendors to call, orders to expedite, and escalations to manage before a late delivery becomes a production or customer-facing problem.
Committed Spend and Cash Flow Visibility The total dollar value of all open purchase orders represents a real, committed future cash outflow — money the business has contractually agreed to pay once goods or services are received and invoiced. Finance and treasury teams use this committed spend figure, organized by expected receipt date, to forecast near-term cash requirements and ensure adequate liquidity is available when invoices come due. Without visibility into open PO commitments, cash flow forecasts that rely only on the current AP aging report understate the business’s true near-term obligations.
GR/NI Accrual Support When goods are received against a purchase order but the vendor’s invoice has not yet been processed through accounts payable, the business has incurred a real liability that GAAP requires be accrued at period-end — even though no formal AP invoice exists yet. The open PO report, combined with receiving data, is the primary source for calculating this goods-received-not-invoiced (GR/NI) accrual. Without a systematic open PO and receiving report, GR/NI accruals are estimated manually, increasing the risk of understated period-end liabilities and audit findings.
Budget Commitment Tracking Many organizations manage departmental and project budgets not just against actual spend but against committed spend — the total of actual expenditures plus open purchase order commitments not yet invoiced. A department that has spent 60% of its budget but has another 35% committed in open POs has effectively used 95% of its budget, even though the accounting system shows only 60% as an actual expense. Budget owners need open PO data to understand their true remaining budget capacity.
Partial Receipt and Backorder Tracking Many purchase orders are fulfilled in multiple shipments — a vendor ships part of the order now and the remainder later, often due to inventory constraints on the vendor’s side. Tracking the outstanding balance of partially received POs — how much was ordered, how much has arrived, and how much remains outstanding — is essential for accurate inventory planning and for knowing exactly what is still owed by each vendor in physical goods, separate from what is owed in dollars.
Vendor Performance Evaluation Aggregating open PO data over time — tracking how frequently each vendor delivers late, how often orders are only partially fulfilled, and how long it takes for outstanding balances to be resolved — produces the delivery performance data that feeds vendor scorecards and sourcing decisions. A vendor with a consistently high rate of late or partial deliveries is a candidate for closer management or replacement.
Audit Support for Commitments Disclosure External auditors and, in some cases, financial statement footnote disclosures require visibility into material purchase commitments — especially for long-term supply agreements or large capital purchases. A clean, organized open PO report supports both the GR/NI accrual testing that auditors perform and any commitment disclosure requirements in the financial statements.

Common KPIs and Change Order Log Data

Order-Level Open PO Data

Purchase Order Number and Line Item Number
Vendor Name and Vendor ID
PO Issue Date
Promised / Requested Delivery Date
Days Until Promised Delivery (positive = time remaining, negative = past due)
Days Past Due (for overdue deliveries)
Item / SKU Description
Ordered Quantity
Received Quantity to Date
Outstanding Open Quantity (ordered minus received)
Unit Price
Total PO Line Value
Received Value to Date
Outstanding Open Value (remaining commitment)
PO Status (open, partially received, fully received pending invoice, on hold, cancelled) Buyer / Requester
Department / Cost Center / Job Number
Ship-To Location / Warehouse
Freight Terms and Expected Carrier

Vendor-Level Open PO Summary

Total Open PO Value by Vendor
Number of Open POs by Vendor
Number of Past-Due Deliveries by Vendor
Value of Past-Due Deliveries by Vendor
Average Days Late (historical, by vendor)
Order Fill Rate (received quantity ÷ ordered quantity, trailing period)
On-Time Delivery Rate (trailing period)

Portfolio-Level Open PO Metrics

Total Open PO Value (all vendors combined)
Total Open PO Value by Expected Delivery Date Bucket (this week, next week, this month, beyond)
Total Past-Due PO Value and Count
Total Partially Received PO Value (outstanding balance only)
Open PO Value by Category / Commodity
Open PO Value by Department / Cost Center / Job
Open PO Value by Buyer
GR/NI Accrual Estimate (goods received, not yet invoiced)

Risk and Exception Metrics

POs Past Promised Delivery Date — count and value
POs Due in Next 7 Days — count and value (expediting priority queue)
POs With No Activity in 30+ Days (stalled orders)
POs On Hold — count and value, with hold reason
Single-Source Risk — high-value open POs with no alternate vendor available

Common Filters and Parameters

As-Of Date / Time — real-time or historical point-in-time open PO position
Vendor / Supplier — single vendor detail or all-vendor summary
Buyer / Requester — open POs by individual buyer
Department / Cost Center / Job — filter by internal budget owner
Category / Commodity — open PO value by product or service category
PO Status — all open, partially received only, fully received pending invoice, on hold
Delivery Date Range — due this week, next 30 days, or custom range
Past-Due Filter — show only POs past their promised delivery date
Minimum Value Threshold — suppress small POs below a defined dollar amount
Warehouse / Ship-To Location — single location or multi-location consolidated
Currency — single currency or multi-currency for international vendors
Hold Status — show only on-hold POs, or exclude holds from active reporting

Common Reporting Challenges

ERP Open PO Lists Lack Risk Prioritization

Most ERP systems can generate a raw list of open purchase orders, but the list typically shows every open PO with equal visual weight — there is no built-in prioritization showing which orders are at risk, which are past due, or which represent the largest dollar exposure. Procurement teams reviewing a 200-line raw export have no efficient way to identify the handful of orders that actually need attention today. Building a report that surfaces risk and prioritizes action is the difference between a data dump and an operational tool.

Partial Receipts Create Confusing Balances

When a purchase order is partially received — common for large orders fulfilled across multiple shipments — tracking the precise outstanding balance (in both quantity and dollar value) requires careful data modeling. Standard ERP reports sometimes show the original PO value without netting out what has already been received, overstating the true open commitment. A report must clearly separate original order value, received-to-date value, and remaining open value for every partially fulfilled line.

GR/NI Calculation Requires Bridging Two Systems

Calculating the goods-received-notinvoiced accrual requires comparing what has been received (from the receiving or warehouse system) against what has been invoiced (from accounts payable) — for every open PO line. When these two data sources are not systematically reconciled, finance teams either estimate the accrual roughly at period-end or miss it entirely, creating understated liabilities that surface as audit adjustments.

Multi-Location Purchasing Visibility

Organizations purchasing for multiple warehouses, plants, or project sites need open PO visibility both at the individual location level (for local operations planning) and at the consolidated company level (for total vendor exposure and negotiating leverage). Vendors who supply multiple locations may have open orders spread across several ship-to addresses that need to be aggregated to understand total vendor commitment.

Stale Delivery Date Promises

Vendors frequently update delivery promises after the original PO is issued — pushing dates back due to their own supply constraints — but these updates do not always make it back into the ERP system in a timely or systematic way. An open PO report based on stale, never-updated delivery dates produces false past-due alerts and undermines trust in the report. Building a process for capturing updated vendor delivery commitments — whether through EDI, vendor portal integration, or manual update workflows — is essential for report accuracy.

Budget vs. Commitment Confusion

Department and project budget owners often confuse "actual spend to date" with "total committed spend" (actual plus open PO value). A budget report that shows only actual spend can give a false sense of available budget capacity when significant amounts are already committed in open purchase orders. Open PO data must be integrated into budget tracking to give an accurate picture of remaining capacity.

Automation and Scheduling Options

Real-Time Open PO Tracking We build SQL Server data pipelines that extract purchase order, receiving, and vendor data from your ERP — updating the open PO reporting database in real time or on a frequent refresh schedule — so the open PO report always reflects the current state of outstanding commitments without manual data pulls.
Delivery Risk Flagging We build automated delivery risk logic that flags purchase orders approaching or past their promised delivery date, calculates days-past-due, and surfaces these at-risk orders at the top of the report — turning a raw transaction list into a prioritized expediting queue for the procurement team.
Partial Receipt Balance Calculation We build outstanding balance calculation engines that net received quantity and value against original ordered quantity and value for every PO line — clearly presenting original commitment, received-to-date, and remaining open balance for every partially fulfilled order.
GR/NI Accrual Automation We build automated GR/NI calculation engines that compare receiving transactions against AP invoice postings for every open PO — surfacing the accrual gap automatically at period-end and producing the journal entry support finance needs without manual reconciliation.
Committed Spend Dashboard We build Power BI committed spend dashboards that combine actual AP spend with open PO commitments to give budget owners and finance leadership a complete view of total committed spend by department, project, vendor, or category — updated on a defined schedule.
Scheduled Delivery Alerts Daily at-risk delivery alerts, weekly open PO summaries by buyer, and monthly committed spend reports can be scheduled for automatic generation and delivery — to procurement teams, operations managers, and finance leadership — without manual report preparation.

Delivery Methods

SSRS (SQL Server Reporting Services)

Parameterized open PO reports by vendor, buyer, department, or status — generated on demand or on schedule. Scheduled daily at-risk delivery alerts and weekly open PO summaries delivered automatically to procurement and operations teams.

Crystal Reports

Modernization of legacy ERP open PO report templates from Sage, Epicor, Infor, and other platforms — improving delivery risk visibility, adding partial receipt balance tracking, and migrating to SSRS or Power BI where appropriate.

Power BI

Interactive open PO dashboards with delivery risk heat maps by vendor and category, committed spend trending, partial receipt balance tracking, and drill-through from portfolio summary to individual PO line detail.

Excel Automation

Excel open PO workbooks driven by live SQL Server data — for budget planning sessions, supplier review meetings, and GR/NI accrual calculations — automatically populated without manual ERP exports.

Scheduled PDF Reports and Email Delivery

Daily delivery risk alerts and weekly open PO summaries automatically delivered by email to buyers, procurement managers, and finance leadership.

Related Report Pages

Purchasing & Procurement Pages

Purchasing & Procurement Reporting Hub — Overview of all purchasing and procurement reporting solutions from ReportingGuru.

Job Cost & WIP Pages

Job Cost, WIP & Project Reporting Hub — Overview of all job cost, WIP, and project reporting solutions from ReportingGuru.

Job Cost Summary — Job-level cost vs. estimate reporting — change order costs flow into the job cost summary as the contract scope evolves.

Work in Progress (WIP) Report — Approved change orders update the revised contract value that drives WIP percentage-of-completion calculations.

Financial & GL Reporting Pages

Balance Sheet — Automate point-in-time financial position reporting alongside period P&L production — both derived from the same GL data model.

Statement of Cash Flows — Reconcile net income to operating cash flow using the indirect method — the income statement is the starting point for every cash flow statement.

Trial Balance — The foundational GL data that drives every revenue and expense line on the income statement — extracted, validated, and exception-checked at every close.

Budget vs Actual — P&L actuals vs. budgeted revenue and expense with variance analysis, departmental accountability, and rolling forecast integration.

Inventory & Warehouse Pages

Inventory & Warehouse Reporting — Overview of all inventory and warehouse reporting solutions from ReportingGuru.

Inventory On Hand — The quantity foundation of every inventory valuation — on-hand units by SKU and location that the valuation cost method is applied to.

Inventory Valuation — The financial value of aged inventory — cost method valuation by lot that determines the dollar impact of the obsolescence reserve.

Investor & Fund Reporting Pages

Financial Statements & KPI Reportin g — Fund and portfolio company financial statements incorporating inventory on-hand balances and turnover metrics.

Fund Performance Reporting — Days-on-hand, stockout rates, and inventory turnover tracked as PE portfolio company operational KPIs.

Frequently Asked Questions

What information should an open purchase order report include?

A complete open purchase order report should include: PO number, vendor, issue date, promised delivery date, item description, ordered quantity, received quantity to date, outstanding open quantity, unit price, original line value, received value, and remaining outstanding value. It should also flag delivery risk — orders approaching or past their promised date — and should be sortable by buyer, department, vendor, and status to support both operational expediting and budget tracking use cases.

How is the outstanding value of a partially received purchase order calculated?

The outstanding value of a partially received PO is calculated as: (Original Ordered Quantity − Received Quantity to Date) × Unit Price. For example, a PO line for 1,000 units at $10 each, with 600 units received, has an outstanding open quantity of 400 units and an outstanding open value of $4,000. This remaining balance stays open on the PO until either the remaining quantity is received or the PO line is formally closed or cancelled by the buyer.

What is the relationship between open purchase orders and GR/NI accruals?

When a purchase order line has been received (goods or services have physically arrived and been recorded in the receiving system) but the vendor’s invoice has not yet been posted to accounts payable, that received-but-uninvoiced amount must be accrued as a liability at period-end under GAAP. The open PO report — combined with receiving transaction data — is the primary source used to calculate this goods-received-not-invoiced (GR/NI) accrual, ensuring the expense and liability are recorded in the correct accounting period even before the formal vendor invoice arrives.

How can procurement teams identify at-risk deliveries before they become production problems?

At-risk deliveries are identified by comparing each open PO’s promised delivery date to the current date and flagging orders that are approaching or have passed that date without a receipt confirmation. We build automated delivery risk reports that surface these at-risk orders daily — sorted by how overdue they are and by their dollar value or production criticality — giving procurement teams a prioritized list to call vendors, expedite shipments, or initiate contingency sourcing before a late delivery disrupts production or fulfillment.

Can open purchase order reports be consolidated across multiple warehouse or plant locations?

Yes. We build multi-location open PO consolidation pipelines that aggregate purchase order and receiving data from all warehouse, plant, or project locations — including locations on different ERP instances — into a centralized SQL Server data model. Reports can show open PO position at the individual location level for local operations planning, or as a consolidated company-wide view for total vendor exposure and negotiating leverage analysis.

How does an open purchase order report support budget management?

Many organizations track budget consumption based on total committed spend — actual expenditures plus open purchase order value not yet invoiced — rather than actual spend alone. A department or project that has spent 60% of its budget in actual invoices but has another 35% committed in open POs has effectively used 95% of its available budget. We build committed spend dashboards that combine actual AP spend with open PO data to give budget owners an accurate, real-time view of true remaining budget capacity.

Can open PO reports be automated from Sage, Epicor, or NetSuite?

Yes. ReportingGuru connects directly to Sage 100/300/X3, Epicor, NetSuite, Microsoft Dynamics, SAP, Oracle, Infor, and Coupa — extracting purchase order, receiving, and vendor data — and builds automated open PO reports that refresh in real time or on a scheduled basis without manual ERP exports, Excel reformatting, or manual delivery date tracking.