/
/
Rank open Procore purchase orders by lateness
For buyers who want a project's open purchase orders ranked by days late and quantity outstanding, by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Buyers read the purchase order log line by line
Finding what has not arrived means reading every purchase order line against its delivery date. The vendors who keep slipping stay hidden in the detail.
Without PopdockAI
- Open each purchase order and read its lines
- Compare delivery dates with today
- Work out the quantity still outstanding
- Guess which vendor to call first
With PopdockAI
- Open purchase orders are read with all their lines
- Late lines are ranked by days late and quantity outstanding
- Vendors with the most late lines are listed
- Lines with no delivery date go in their own list
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Review the open purchase orders in {project-name}, measuring delivery against {as-of-date} (default today), and rank them by lateness and outstanding quantity.
**Step 1: Read the purchase orders**
Call `procore-get-materials-mgmt-purchase-orders` with the project filter. Use the `project-name` filter (or `project-name.contains` if the user gave a partial name) on the main read to scope it to {project-name}. If the first records show more than one distinct project name, list the project names and ask which one is meant before going further. If the user named a Procore company, pass it in the `company` parameter on every call. Skip any with a closed or cancelled `status`.
**Step 2: Read the outstanding lines**
Call `procore-get-materials-mgmt-purchase-orders-line-items` with the same project filter and `contract-delivery-at.to` set to {as-of-date} (today if blank). Note `quantity-outstanding`, `quantity-shipped` and `quantity-received` per line.
**Step 3: Check vendors**
Call `procore-get-materials-mgmt-purchase-orders-vendors` with the project filter so you can group late lines by vendor.
**Step 4: Report**
Output a table: purchase order, vendor, status, contract delivery date, days late, lines outstanding, quantity outstanding. Rank by days late. Then list the vendors with the most late lines and the three purchase orders to chase first.
**Rules & Guidelines:**
* This prompt is read-only. Never call any create, update, delete, bulk, sync, restore, associate or comment tool (for example `procore-update-equipment-register`, `procore-delete-equipment-register`, `procore-create-shipment` or `procore-update-transfer`).
* Report only what the tools return. Do not guess missing dates, quantities or names; mark them as missing.
* `max-records` caps each call, so say when a call returned its cap and the picture may be partial.
* Late means a delivery date earlier than {as-of-date} with quantity still outstanding. Lines with no delivery date go in a separate list.
**Validation:**
* If the project name matches no records, say so and stop. Do not read records from a guessed project.
* If the main read returns nothing, say there are none and stop. Do not fill the gap with assumptions.
Who it's for
One answer, three teams that use it
Buyers
Chase the right order first
Get the three purchase orders to chase first, based on days late and quantity outstanding.
Rank open purchase orders on Contoso Warehouse by days late and tell me which three to chase.
Procurement managers
See which vendors slip
Find the vendors with the most late lines on a project, ready for a supplier review.
Which vendors have the most late purchase order lines on Fabrikam Depot?
Project managers
Know what is still outstanding
Check the quantity still outstanding on open purchase orders against a date, such as the next install.
What is outstanding on open purchase orders for Northwind Plaza as of 1 December?
How it works
What PopdockAI does when you ask
You name the project and your AI assistant measures lateness against the date you give. It only reads, notes when a read hit its record cap and never guesses a date.
Ask
You name the project and optionally an as-of date.
Read
It reads the open purchase orders, skipping closed and cancelled ones.
Measure
It reads the lines and quantities outstanding and groups late lines by vendor.
Report
It ranks by days late, names the worst vendors and the three purchase orders to chase.
What PopdockAI provides
The tools behind the answer
Ready made tools for Procore and one secure connection to your AI tool. No code, no exports.
procore-get-materials-mgmt-purchase-orders
procore-get-materials-mgmt-purchase-orders-line-items
procore-get-materials-mgmt-purchase-orders-vendors
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
The right purchase orders chased first
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
