Connectors

/

Procore

/

Check Procore materials PO vendors in Rillet
Report
Cross-Connector

Check materials order vendors exist in Rillet before billing

For finance teams who ask their AI assistant whether every vendor on a project's Procore materials orders is in the Rillet vendor list.

Try PopdockAI free
Get a live demo
Check Procore materials PO vendors in Rillet
Check that every vendor on the Riverside Tower materials purchase orders is in Rillet.
8 vendors are on the Riverside Tower materials orders, and 5 match a Rillet vendor. - Close match: Contoso Aggregates in Procore, Contoso Aggregate Inc in Rillet - Not in Rillet: Fabrikam Lumber, 3 open orders - Not in Rillet: Adventure Works Fasteners, 1 open order - Matched: 5 vendors, with Rillet ids and payment terms Want the full table for all 8 vendors?
Procore
Sample figures. Your results come from your own account.
procore-get-materials-mgmt-purchase-orders-vendors
rillet-get-vendors
procore-get-materials-mgmt-purchase-orders

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

Order vendors and ledger vendors rarely line up

The vendor on a Procore materials order has to match a vendor in Rillet before a bill can be booked. Comparing the names by eye misses spelling differences, and the miss shows up when a bill is rejected.

Without PopdockAI

  • List the vendors on the project's materials orders
  • Search the Rillet vendor list for each
  • Judge spelling differences by eye
  • Find the gaps when a bill is rejected

With PopdockAI

  • Order vendors are matched to Rillet, ignoring case and endings
  • Close matches show both spellings
  • Open order counts show which gaps matter first
  • Nothing is 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 project `{project-name}`, check that every vendor on its Procore materials purchase orders exists in the Rillet vendor list, so bills for those orders can be booked.

**Step 1: Read the PO vendors (Procore resource management)**

Call `procore-get-materials-mgmt-purchase-orders-vendors` with `project-name.contains` set to `{project-name}`. Keep `vendor` and `project-name`. De-duplicate the vendors. If more than one project name comes back, list the project names and stop so the user can pick one. If nothing comes back, say so and stop.

**Step 2: Read the Rillet vendors**

Call `rillet-get-vendors` once. Match each Procore `vendor` to a Rillet vendor `name` (ignore case, punctuation, and endings such as Inc, LLC, Ltd and Co). Keep `vendor-id`, `name`, `account-code`, `payment-terms` and `email` for each match.

**Step 3: Count the open orders per vendor (Procore)**

For each vendor, call `procore-get-materials-mgmt-purchase-orders` with `project-name.contains` set to `{project-name}` and count the orders whose `vendor` equals it and whose `status` is not closed or cancelled.

**Step 4: Report**

A table with one row per vendor: Procore vendor, open PO count, Rillet vendor id, Rillet name, and a verdict (matched, close match, not in Rillet). For a close match show both spellings. End with the counts per verdict and the vendors that have open POs but no Rillet record.

**Rules & Guidelines:**

* `procore-get-materials-mgmt-purchase-orders-vendors` and `procore-get-materials-mgmt-purchase-orders` are on the Procore resource management server. `rillet-get-vendors` is on the Rillet server.
* Read-only. Do not call any Rillet `rillet-add-*`, `rillet-update-*`, `rillet-apply-*`, `rillet-unapply-*`, `rillet-record-*`, `rillet-set-*` or `rillet-setup-*` tool, and do not call any Procore create, update, delete, sync or bulk tool.

**Validation:**

* If two Rillet vendors match one Procore vendor, list both and do not pick one.
* If the Procore `vendor` value is empty on an order, list the order as having no vendor.
* If `rillet-get-vendors` returns nothing, say the Rillet vendor list is empty and stop.

Who it's for

One answer, three teams that use it

Accounts payable

Prepare before bills arrive

See which order vendors Rillet cannot match, so they are fixed before the first bill is rejected.

Which vendors on Fabrikam Depot materials purchase orders are not in Rillet?

Procurement coordinators

Judge which gaps matter

Check open order counts next to each missing vendor, so the busiest gaps are fixed first.

Show Contoso Warehouse materials order vendors with their open order counts and Rillet match.

Finance systems owners

Catch spelling differences

Close matches show both spellings, so a rename is a decision and not a surprise.

For Northwind Plaza, list close matches between materials order vendors and Rillet vendors.

How it works

What PopdockAI does when you ask

You name the project and your AI assistant reads the order vendors and checks each against Rillet. It reads only, and it never picks between two possible matches.

Ask

You name the project whose materials orders you want to check.

Your AI tool

Read

It reads the order vendors and removes duplicates.

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

Match

It matches each to a Rillet vendor and counts the vendor's open orders in Procore.

No items found.

Report

You get a row per vendor with a verdict, and the vendors with open orders but no Rillet record.

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

Returns the project vendors on Procore materials purchase orders, from Procore Resource Management.
get-data

rillet-get-vendors

Returns vendors (name, contact, address, payment terms, 1099 status) from Rillet.
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.
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 vendor accounted for in the ledger

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