Connectors

/

Procore

/

Review overdue Procore observation vendors against Rillet balances
Report
Cross-Connector

Chase overdue observations with the vendor's billing in view

For project teams who want overdue Procore observations alongside each vendor's Rillet bills and payments by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review overdue Procore observation vendors against Rillet balances
On Riverside Tower, which vendors have overdue observations, and what have we billed and paid them in Rillet over the last 180 days?
3 vendors have overdue observations on Riverside Tower, and 1 has no Rillet record. - Fabrikam Concrete: 6 overdue, oldest due 2 February, 4 bills, 1 unpaid, 61,200 paid - Contoso Steel: 3 overdue, oldest due 15 February, 2 bills, none unpaid, 40,000 paid - Northwind Fit-out: 2 overdue, no Rillet record Want the unpaid bills for Fabrikam Concrete listed?
Procore
Sample figures. Your results come from your own account.
procore-get-observations-items
rillet-get-vendors
rillet-get-bills
rillet-get-bill-payments

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

Observation follow-up starts without the financial picture

Overdue observations are chased from Procore, while what the vendor has been billed and paid sits in Rillet. Calling a vendor without that picture makes the conversation blind.

Without PopdockAI

  • List overdue observations in Procore
  • Group them by assigned vendor
  • Look each vendor up in Rillet
  • Add up bills and payments for the period

With PopdockAI

  • Overdue open observations are grouped by vendor for you
  • Each vendor's Rillet bills and payments are read
  • Unpaid bills and vendors with no record are shown
  • Nothing is sent or paid and no hold is recommended

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 vendors assigned observations that are past due, and show how much Rillet has billed and paid them, so follow-up conversations start with the financial picture.

**Step 1: Overdue observations in Procore**

These tools are on the procore-project-management server. Call `procore-get-observations-items` filtered by `project-name` and `due-date.to` set to today. Keep rows with an `assignee-vendor-name` whose `status` is not closed. Group by `assignee-vendor-name`: count items and note the oldest `due-date`.

**Step 2: Rillet record for each vendor**

These tools are on the rillet server. Call `rillet-get-vendors` and match each `assignee-vendor-name` by name (ignore case and suffixes). Take `vendor-id`, then call `rillet-get-bills` and `rillet-get-bill-payments` with it as `vendor-id`. Limit to the last `{lookback-days}` days (default 180) using `bill-date.from` and `payment-date.from`.

**Step 3: Report**

Per vendor: overdue observation count, oldest due date, bills in the period, unpaid bills, total paid. Sort by overdue count, highest first. Add a closing line naming vendors with overdue observations and no Rillet record.

**Rules & Guidelines:**

* procore-get tools tools are procore-project-management; rillet-get tools tools are rillet.
* Read only. Do not call `procore-update-observation-item`, `procore-send-observation-item-email`, `rillet-add-bill-payment`, or any other create, update, send or delete tool.

**Validation:**

* If no overdue observation has a vendor assignee, say so and stop.
* If a vendor has no bills in the period, report zero rather than treating it as missing.
* Do not recommend withholding payment; present the figures only.

Who it's for

One answer, three teams that use it

Project managers

Go into a vendor call informed

See how much a vendor has billed and been paid before you press them on overdue observations.

Which vendors have overdue observations on Northwind Plaza, and what is their billing position in Rillet?

Quality managers

Prioritise by vendor

Rank vendors by overdue observation count with their unpaid bills alongside.

Show overdue observations by vendor on Harbour Depot, with unpaid Rillet bills for each.

Commercial managers

Prepare for a commercial discussion

Get the facts on billing and payment for vendors with overdue site issues, without a payment hold being suggested.

For Contoso Warehouse, list vendors with overdue observations and their Rillet payments in the last 90 days.

How it works

What PopdockAI does when you ask

You name the project and your AI assistant joins the observations in Procore to the bills and payments in Rillet. It presents figures only, never a recommendation to withhold payment.

Ask

You name the project and, optionally, how many days of billing to look back.

Your AI tool

Group

It finds overdue open observations in Procore and groups them by assigned vendor.

procore-get-observations-items
rillet-get-vendors
rillet-get-bills
rillet-get-bill-payments

Look up

It finds each vendor in Rillet and reads its bills and payments for the period.

No items found.

Report

You get a line per vendor, sorted by overdue count, with vendors that have no Rillet record named.

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-observations-items

Returns Procore observation items for a project, with status, assignee and due date.
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.
get-data

rillet-get-bill-payments

Returns payments made against vendor bills 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

Every vendor follow-up starts with the full picture

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