/
/
Find delivered materials that no vendor has billed
For finance teams who want Procore materials receipts checked against Rillet bills by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Deliveries are posted but the bills are not chased
Receipts are posted in Procore and bills arrive in Rillet, and nothing connects the two. Accruals for delivered goods are missed and vendors wait longer to be paid.
Without PopdockAI
- List the receipts posted in Procore
- Look up the vendor on each purchase order
- Search Rillet for a bill from that vendor
- Track which deliveries still have no bill
With PopdockAI
- Posted receipts and their vendors are read for you
- Rillet is checked for a bill dated since delivery
- Unresolved orders are listed, not guessed
- A missing bill is called a lead, never proof
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}`, find materials receipts posted on or after `{date-posted-from}` (default: the last 30 days) and check whether the supplying vendor has a bill in Rillet dated on or after the receipt.
**Step 1: Read the receipts (Procore resource management)**
Call `procore-get-materials-mgmt-receipts` with `project-name.contains` set to `{project-name}` and `date-posted.from` set to `{date-posted-from}`. Keep receipts with a posted state; keep `name`, `purchase-order-name`, `date-posted` and `status`. If none come back, say so and stop.
**Step 2: Find each vendor (Procore)**
For each distinct `purchase-order-name` call `procore-get-materials-mgmt-purchase-orders` with `name.contains` set to it and keep `vendor`. If a purchase order name is blank or matches more than one order, list the receipt as unresolved.
**Step 3: Look for bills (Rillet)**
Call `rillet-get-vendors` once and match each `vendor` to a Rillet vendor `name` (ignore case, punctuation and endings such as Inc and LLC). For each match call `rillet-get-bills` with `vendor-id` and `bill-date.from` set to the earliest `date-posted` for that vendor. A receipt counts as billed if the vendor has a bill dated on or after its `date-posted`.
**Step 4: Report**
A table with one row per receipt: receipt, purchase order, vendor, date posted, Rillet vendor id and a verdict (vendor billed since, no bill since, vendor not in Rillet, unresolved). Group the no-bill rows by vendor with the number of receipts and the oldest posting date, since these may need a goods-received accrual. Bills are tied by vendor and date only, so say that a bill may cover other deliveries.
**Rules & Guidelines:**
* `procore-get-materials-mgmt-receipts` and `procore-get-materials-mgmt-purchase-orders` are on the Procore resource management server. `rillet-get-vendors` and `rillet-get-bills` are 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 the vendor is not in Rillet, report it as present in Procore and absent from Rillet and continue with the others.
* If two Rillet vendors match one Procore vendor, list both and do not pick one.
* Do not claim a receipt is unbilled when the only evidence is the absence of a bill; call it a lead.Who it's for
One answer, three teams that use it
Accounts payable
Chase bills for delivered goods
See which vendors have delivered but not billed, with the number of receipts and the oldest delivery date.
On Northwind Plaza, which materials deliveries from the last 30 days have no Rillet bill yet?
Finance controllers
Support goods received accruals
Get a vendor by vendor list of receipts without bills to review before period end.
List unbilled Procore materials receipts for Riverside Tower since 1 March, grouped by vendor.
Procurement managers
Spot vendors missing from the ledger
Find suppliers receiving deliveries who have no vendor record in Rillet yet.
For Contoso Warehouse, which vendors with receipts do not exist in Rillet?
How it works
What PopdockAI does when you ask
You name the project and your AI assistant reads Procore and Rillet. Unresolved purchase orders are listed instead of guessed and nothing is changed.
Ask
You name the project and, optionally, the date to look from.
Read
It reads the posted receipts in Procore and finds the vendor on each purchase order.
Check
It finds each vendor in Rillet and looks for a bill dated on or after the receipt.
Report
You get a verdict per receipt and the unbilled ones grouped by vendor.
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-receipts
procore-get-materials-mgmt-purchase-orders
rillet-get-vendors
rillet-get-bills
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
No delivery left without a bill or an accrual
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)
