/
/
Find rented equipment whose vendor has not billed
For operations teams who ask their AI assistant which Procore rental vendors with units on rent have no recent bills in Rillet.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Rented equipment runs on while the invoices go missing
The equipment register shows what is on rent and the ledger shows what has been billed, but nobody compares them. A rental that has not been invoiced for months only comes to light when the vendor calls.
Without PopdockAI
- List the rented units on the Procore register
- Find each rental vendor in Rillet
- Look for recent bills one vendor at a time
- Hear about the gap when the vendor chases
With PopdockAI
- Rented units with a vendor are listed, retired and returned ones skipped
- Each rental vendor is matched to Rillet
- Bills since your cutoff are counted with the latest date
- Vendors with units on rent but no bills are flagged as leads
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List the equipment on the Procore equipment register that has a rental vendor, optionally only in category `{category-name}`, and check that each rental vendor exists in Rillet and has been billed since `{bill-date-from}` (default: 90 days ago).
**Step 1: Read the equipment (Procore resource management)**
Call `procore-get-equipment-register` with `category-name.contains` set to `{category-name}` if given. Keep equipment where `vendor-name` is not empty. Keep `name`, `identification-number`, `status-name`, `rental-start-date` and `vendor-name`. Skip equipment whose `status-name` shows it as retired or returned, and say how many you skipped. If nothing is left, say so and stop.
**Step 2: Match the vendors (Rillet)**
Call `rillet-get-vendors` once. Match each distinct `vendor-name` to a Rillet vendor `name` (ignore case, punctuation and endings such as Inc and LLC). Keep `vendor-id`.
**Step 3: Check recent billing (Rillet)**
For each matched vendor call `rillet-get-bills` with `vendor-id` and `bill-date.from` set to `{bill-date-from}`. Count the bills and note the latest `bill-date` and any with an overdue or unpaid `status`.
**Step 4: Report**
A table with one row per rental vendor: vendor, number of rented units, earliest rental start, Rillet vendor id, bills since the cutoff, latest bill date and a verdict (billed, no bills since cutoff, not in Rillet). Flag vendors with units on rent but no bills since the cutoff, since they may be accruing unbilled rental cost. List units under each flagged vendor.
**Rules & Guidelines:**
* `procore-get-equipment-register` is 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 a rental has no `rental-start-date`, list it as undated rather than assuming a start.
* If two Rillet vendors match one `vendor-name`, list both and do not pick one.
* Absence of bills is a lead to follow up, not proof of an error; say so.Who it's for
One answer, three teams that use it
Equipment managers
Check rentals are being invoiced
See which rented units have a vendor with no bills in Rillet since your cutoff.
Check all rented equipment on Fabrikam Depot against Rillet and show vendors with no bills in 60 days.
Operations managers
Spot accruing cost
Find units that are still on rent while the vendor has not billed, so cost is accrued or queried.
Which rental vendors for Contoso Warehouse have units on rent but no recent bills in Rillet?
Accounts payable
Know which vendors to ask
Get a list of units under each flagged vendor to ask about missing invoices.
For rented cranes and lifts, show vendors with no bills in Rillet since 1 September.
How it works
What PopdockAI does when you ask
You give a category and cutoff, and your AI assistant checks the register against Rillet. It reads only, and treats a missing bill as a lead to follow up, not an error.
Ask
You give an optional equipment category and the bill date to check from.
Read
It lists rented equipment with a vendor, skipping retired and returned units.
Match
It matches each rental vendor to Rillet and counts bills since the cutoff.
Report
You get a row per vendor, with those on rent but unbilled flagged and their units listed.
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-equipment-register
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
Unbilled rentals found while there is time to act
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)
