Connectors

/

Procore

/

Review Procore open purchase orders
Report

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.

Try PopdockAI free
Get a live demo
Review Procore open purchase orders
Which open purchase orders on Riverside Tower are late as of today, and which vendors slip most?
Riverside Tower has 14 open purchase orders, and 6 have late lines. - PO-1180, Northwind Supply: 21 days late, 4 lines, 640 units outstanding - PO-1164, Fabrikam Steel: 12 days late, 2 lines, 90 units outstanding - Most late lines: Northwind Supply with 7 - No delivery date: 3 lines, listed separately Want the three purchase orders to chase first?
Procore
Sample figures. Your results come from your own account.
procore-get-materials-mgmt-purchase-orders
procore-get-materials-mgmt-purchase-orders-line-items
procore-get-materials-mgmt-purchase-orders-vendors

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Procore

Procore
Run it on your own Procore data.

Connect Procore, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Read

It reads the open purchase orders, skipping closed and cancelled ones.

procore-get-materials-mgmt-purchase-orders
procore-get-materials-mgmt-purchase-orders-line-items
procore-get-materials-mgmt-purchase-orders-vendors

Measure

It reads the lines and quantities outstanding and groups late lines by vendor.

No items found.

Report

It ranks by days late, names the worst vendors and the three purchase orders to chase.

Your AI tool

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.

get-data

procore-get-materials-mgmt-purchase-orders

Returns Procore Resource Management materials purchase orders with vendor, status, project and contract delivery date. Filter by status and project name.
get-data

procore-get-materials-mgmt-purchase-orders-line-items

Returns the line items of Procore materials purchase orders, with quantities and item details. Filter by purchase order.
get-data

procore-get-materials-mgmt-purchase-orders-vendors

Returns the project vendors on Procore materials purchase orders, from Procore Resource Management.
Read only.Nothing in Procore Changes

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.

How Popdock AI secures your data

The outcome

The right purchase orders chased first

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation