Connectors

/

Procore

/

Reconcile Procore materials purchase orders to Ramp vendors
Report
Cross-Connector

Check materials purchase orders against Ramp vendors and orders

For operations and procurement teams who ask their AI assistant whether each Procore materials order has an active supplier and a purchase order in Ramp.

Try PopdockAI free
Get a live demo
Reconcile Procore materials purchase orders to Ramp vendors
For the Riverside Tower project, check the open materials purchase orders against Ramp and tell me which suppliers are missing.
Riverside Tower has 12 open materials purchase orders from 7 suppliers, and 2 suppliers are not in Ramp. - Supplier missing from Ramp: Fabrikam Lumber (2 orders) - Supplier inactive in Ramp: Contoso Aggregates (1 order) - No Ramp purchase order: PO-5521 and PO-5534 - Billed so far: PO-5502 at 60 percent of 24,000.00 Want the full row for each of the 12 orders?
Procore
Sample figures. Your results come from your own account.
procore-get-materials-mgmt-purchase-orders
ramp-get-vendor
ramp-get-purchase-order

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

Field purchase orders never get checked against Ramp

Orders are raised on site, but nobody confirms the supplier is set up in Ramp or that the purchase order is being billed. The gap shows up when a bill arrives for a supplier Ramp does not know.

Without PopdockAI

  • List the project's materials purchase orders in Procore
  • Search Ramp for each supplier
  • Search Ramp purchase orders for each order name
  • Note billing progress in a spreadsheet

With PopdockAI

  • Every supplier is checked as missing, inactive or active in Ramp
  • Each order is matched to a Ramp purchase order with billing status
  • Several matches are listed and never chosen between
  • Nothing is created or changed in either system

The prompt

Use this prompt

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

Prompt
**Objective:** For the materials purchase orders on project `{project-name}` with status `{po-status}` (leave empty for all), check that each supplier is an active Ramp vendor and show whether a matching Ramp purchase order exists and how far it is billed.

**Step 1: Read the purchase orders (Procore Resource Management server)**

Call `procore-get-materials-mgmt-purchase-orders` with `project-name.contains` set to `{project-name}` and, if given, `status` set to `{po-status}`. If more than one project name matches, list the projects and stop. Keep each PO's `name`, `vendor`, `status`, `original-contract-delivery-date` and `line-items-count`.

**Step 2: Check the supplier (Ramp server)**

For each distinct `vendor`, call `ramp-get-vendor` with `name.contains` set to the vendor name. Note `active` and `total-spend-last-365-days`.

**Step 3: Check the purchase order (Ramp server)**

For each PO, call `ramp-get-purchase-order` with `name.contains` set to the Procore PO `name`. Note `billing-status`, `receipt-status`, `amount` and `spend-total-amount`.

**Step 4: Report**

One row per PO: name, supplier, Procore status and delivery date, then supplier status in Ramp (missing, inactive, active), and the Ramp PO result (none, or its billing and receipt status and amounts). Close with the suppliers missing from Ramp.

**Rules & Guidelines:**

* Procore Resource Management tools (names starting procore-get) and Ramp tools (names starting ramp-get) live on two different MCP servers; both must be connected. If either set of tools is missing, say which server is not connected and stop.
* This is a read-only review. Never call any write tool on either server, including `ramp-user-add`, `ramp-user-deactivate`, `ramp-user-update`, `ramp-vendor-add`, `ramp-vendor-update`, `ramp-location-add`, or any Procore tool whose name starts procore-create, procore-update or procore-delete.
* If the Procore tools ask for a `company` and more than one is available, ask which company to use before reading.
* Report only data the tools return; never guess a match.

**Validation:**

* If a Procore call returns nothing, report that and stop.
* If a Ramp call returns nothing for a record, report it as present in Procore and absent from Ramp, and continue with the next record.
* If a name or number matches more than one Ramp record, list the candidates and do not pick one.

Who it's for

One answer, three teams that use it

Procurement managers

Confirm suppliers before bills arrive

See which suppliers on a project's orders are missing or inactive in Ramp so they can be set up first.

Which suppliers on the Contoso Warehouse materials orders are missing from Ramp?

Project engineers

Track order billing

Check whether each materials order has a Ramp purchase order and how far it has been billed.

Show the billing and receipt status in Ramp for Fabrikam Depot materials orders in Issued status.

Operations managers

Spot unmatched spend early

Find orders raised in the field that have no matching purchase order in the finance system.

Check Northwind Plaza materials orders against Ramp and list the ones with no purchase order.

How it works

What PopdockAI does when you ask

You name the project and your AI assistant checks each supplier and order in Ramp. It reads only, stops on an unclear project name, and never guesses a match.

Ask

You name the project and, if you want, the order status.

Your AI tool

Read

It reads the project's materials purchase orders with supplier, status and delivery date.

procore-get-materials-mgmt-purchase-orders
ramp-get-vendor
ramp-get-purchase-order

Check

It looks up each supplier and each purchase order in Ramp for status, billing and amounts.

No items found.

Report

You get a row per order and the suppliers that are missing from Ramp.

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

ramp-get-vendor

Returns Ramp vendors as read from the Ramp connector. Filters include: name contains, created at to, legal name contains, vendor owner id, maximum records.
get-data

ramp-get-purchase-order

Returns Ramp purchase orders as read from the Ramp connector. Filters include: name, maximum records, currency code, created at from, name contains.
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

Every order has a supplier Ramp knows about

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