Connectors

/

Procore

/

Find Procore material receipts not billed in Rillet
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Find Procore material receipts not billed in Rillet
For Riverside Tower, which materials receipts from the last 30 days have no bill from the vendor in Rillet yet?
14 receipts were posted on Riverside Tower, and 5 have no bill since delivery. - Northwind Steel: 3 receipts, oldest posted 4 March, no bill since - Contoso Aggregates: 2 receipts, oldest posted 9 March, no bill since - Fabrikam Timber: vendor not in Rillet, 1 receipt Bills are tied by vendor and date only, so treat these as leads. Want the full table?
Procore
Sample figures. Your results come from your own account.
procore-get-materials-mgmt-receipts
procore-get-materials-mgmt-purchase-orders
rillet-get-vendors
rillet-get-bills

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

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.

Prompt
**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.

Your AI tool

Read

It reads the posted receipts in Procore and finds the vendor on each purchase order.

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

Check

It finds each vendor in Rillet and looks for a bill dated on or after the receipt.

No items found.

Report

You get a verdict per receipt and the unbilled ones grouped by vendor.

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

Returns paginated receipt details for Procore materials purchase orders, with vendor, date and status.
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

rillet-get-vendors

Returns vendors (name, contact, address, payment terms, 1099 status) from Rillet.
get-data

rillet-get-bills

Returns vendor bills (expense number, vendor, dates, status) from Rillet.
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

No delivery left without a bill or an accrual

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