Connectors

/

Procore

/

Reconcile Procore purchase order
Report

Check a Procore purchase order against what arrived

For finance and materials teams who want ordered, shipped, received and defective quantities checked line by line, just by asking.

Try PopdockAI free
Get a live demo
Reconcile Procore purchase order
Reconcile purchase order PO-1187 on Riverside Tower and tell me where the quantities do not add up.
PO-1187 has 12 lines, and 3 of them need follow-up. - Rebar 16mm: ordered 400, shipped 380, received 380, outstanding 20, consistent - Anchor bolts: ordered 600, shipped 600, received 540, 60 short on receipt - Conduit 2 inch: ordered 250, received 250, 18 defective - Gypsum board: received quantity missing, line not flagged Want the totals for the whole order?
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-shipments
procore-get-materials-mgmt-receipts
procore-get-materials-mgmt-receipts-line-items
procore-get-materials-mgmt-defects-line-items

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

Short and damaged deliveries get paid anyway

Matching a purchase order to what actually shipped and arrived means opening the order, shipments, receipts and defect lines separately and doing the sums yourself. Short or damaged deliveries slip through and get paid in full.

Without PopdockAI

  • Open the purchase order and its line items
  • Open shipments and receipts for the same order
  • Check defect lines against what was received
  • Work out ordered less shipped less received on a calculator

With PopdockAI

  • The order, lines, shipments, receipts and defects are read together
  • Ordered, shipped, received, defective and outstanding sit on one row per line
  • Lines where the quantities disagree are flagged
  • Arithmetic uses returned numbers only, and missing quantities are shown as missing

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Reconcile purchase order {purchase-order-name} in {project-name}: what was ordered, shipped and received, and where the quantities disagree.

**Step 1: Read the purchase order**

Call `procore-get-materials-mgmt-purchase-orders` with `name` equal to {purchase-order-name} and 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. If more than one purchase order matches, list them and ask which one.

**Step 2: Read its lines**

Call `procore-get-materials-mgmt-purchase-orders-line-items` with `purchase-order-name` and the project filter for `quantity-ordered`, `quantity-shipped`, `quantity-received` and `quantity-outstanding`.

**Step 3: Read the shipments and receipts**

Call `procore-get-materials-mgmt-shipments` with `purchase-order-name`, then `procore-get-materials-mgmt-receipts` and `procore-get-materials-mgmt-receipts-line-items` with `purchase-order-name` to see what was actually received and its `line-status`.

**Step 4: Check for defects**

Call `procore-get-materials-mgmt-defects-line-items` with `purchase-order-name` to see damaged or rejected quantities.

**Step 5: Report**

Output one row per purchase order line: item, ordered, shipped, received, defective, outstanding, and a flag where shipped plus outstanding does not equal ordered or received exceeds shipped. Then summarise totals and list the lines that need follow-up.

**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.
* Do the arithmetic from the returned numbers only; if a quantity is missing, show it as missing and do not flag that line.

**Validation:**

* If the purchase order name matches nothing, say so and stop.
* If it has no lines, say so and stop.

Who it's for

One answer, three teams that use it

Accounts payable

Hold payment on short deliveries

See which lines were received short or damaged before you approve the supplier invoice.

Reconcile PO-2044 on Fabrikam Plaza and show lines where received is less than shipped.

Materials coordinators

Chase outstanding quantities

Find lines with outstanding quantities and defects so you can follow up with the supplier.

Which lines on purchase order PO-0912 for Contoso Medical Centre are still outstanding or have defects?

Project managers

Check an order before closing it

Confirm that quantities add up across order, shipment and receipt before the purchase order is closed out.

Check PO-3301 on Northwind Warehouse and tell me whether ordered, shipped and received agree.

How it works

What PopdockAI does when you ask

You name the purchase order and your AI assistant reads everything attached to it. It only reads, stops if the order or project is ambiguous and says when a read reached its cap.

Ask

You name the purchase order and the project.

Your AI tool

Read

It reads the order, its lines, shipments, receipts and defect lines.

procore-get-materials-mgmt-purchase-orders
procore-get-materials-mgmt-purchase-orders-line-items
procore-get-materials-mgmt-shipments
procore-get-materials-mgmt-receipts
procore-get-materials-mgmt-receipts-line-items
procore-get-materials-mgmt-defects-line-items

Compare

It checks ordered, shipped, received and outstanding quantities line by line.

No items found.

Report

You get a row per line, totals and the lines that need follow-up.

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-shipments

Returns Procore materials mgmt shipments records from the Resource Management area. Filter by the record's own fields; reads only, nothing is changed.
get-data

procore-get-materials-mgmt-receipts

Returns paginated receipt details for Procore materials purchase orders, with vendor, date and status.
get-data

procore-get-materials-mgmt-receipts-line-items

Returns Procore materials mgmt receipts line items records from the Resource Management area. Filter by the record's own fields; reads only, nothing is changed.
get-data

procore-get-materials-mgmt-defects-line-items

Returns Procore materials mgmt defects line items records from the Resource Management area. Filter by the record's own fields; reads only, nothing is changed.
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

Pay for what arrived, not what was ordered

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