/
/
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.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads the order vendors and removes duplicates.
Match
It matches each to a Rillet vendor and counts the vendor's open orders in Procore.
Report
You get a row per vendor with a verdict, and the vendors with open orders but no Rillet record.
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-vendors
rillet-get-vendors
procore-get-materials-mgmt-purchase-orders
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
Every order vendor accounted for in the ledger
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)
