Connectors

/

Procore

/

Check Procore delay log vendors for unpaid Rillet bills
Report
Cross-Connector

See which delaying vendors are also waiting on payment

For project managers who ask their AI assistant to total delay log time per vendor and show each vendor's unpaid Rillet bills.

Try PopdockAI free
Get a live demo
Check Procore delay log vendors for unpaid Rillet bills
Which vendors in the Riverside Tower delay logs since 1 September are also waiting on unpaid bills in Rillet?
5 vendors appear in the Riverside Tower delay logs, and 2 also have past-due bills in Rillet. - Fabrikam Concrete: 26 hours over 4 logs, 3 unpaid bills, 1 past due - Contoso Steel: 11 hours over 2 logs, 1 unpaid bill, past due since 30 September - Northwind Electric: 6 hours over 1 log, no unpaid bills - No Rillet match: Adventure Works Glazing Want the exact bill status values Rillet returned?
Procore
Sample figures. Your results come from your own account.
procore-get-delay-logs
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

Delays get chased without knowing who is owed money

The delay log shows which vendors are holding up the job, and Rillet shows what you still owe them. Nobody lines the two up, so the chase starts without knowing the payment position.

Without PopdockAI

  • Total delay hours per vendor from the Procore log
  • Search Rillet for each vendor
  • Check unpaid bills and due dates by hand
  • Make the call without the payment picture

With PopdockAI

  • Delay time and log counts are totalled per vendor
  • Each vendor's unpaid and past-due bills are read from Rillet
  • Vendors with both delay and past-due bills come first
  • Fault is never assigned, and ambiguous vendors are skipped

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** List the vendors named in delay logs on project `{project-name}` since `{date-from}` (default: 90 days ago) and show each one's unpaid bills in Rillet, so the team knows who is both causing delay and waiting on payment.

**Step 1: Delay logs from Procore**

These tools are on the procore-project-management server. Call `procore-get-delay-logs` filtered by `project-name` and `date.from`. Keep rows with a `vendor-name`. For each vendor total the `duration` and count the logs, and note the latest `date`.

**Step 2: Rillet vendor and bills**

These tools are on the rillet server. Call `rillet-get-vendors` once and match each Procore vendor by name (ignore case and suffixes like LLC or Inc). For each matched vendor take `vendor-id` and call `rillet-get-bills` with it as `vendor-id`. Keep bills whose `status` shows they are not fully paid. If needed, call `rillet-get-bill-payments` with `vendor-id` and `bill-id` to see `payment-status`.

**Step 3: Report**

One row per vendor: total delay duration, delay log count, number of unpaid bills, earliest `due-date`, and any bill already past due. Put vendors with both delay and past-due bills first. List vendors with no Rillet match under their own heading.

**Rules & Guidelines:**

* procore-get tools tools belong to procore-project-management; rillet-get tools tools belong to rillet.
* Read only. Do not call `rillet-add-bill-payment`, `rillet-update-bill`, or any `procore-create-*`, `procore-update-*` or `procore-delete-*` tool.
* Do not state that a delay is the vendor's fault; report what the logs record.

**Validation:**

* If the project has no delay logs with a vendor, say so and stop.
* If a vendor matches more than one Rillet vendor, list the candidates and skip that vendor.
* Report the exact `status` values seen rather than assuming which ones mean unpaid.

Who it's for

One answer, three teams that use it

Project managers

Prepare for a vendor call

See a vendor's total delay and their unpaid bills side by side before you raise the delay.

Show delay log totals by vendor on Fabrikam Depot since 1 August with their unpaid Rillet bills.

Site superintendents

Understand why a vendor is slow

Check whether a vendor holding up the job is also waiting on money, before blaming the schedule.

Is Contoso Steel, which keeps appearing in the Contoso Warehouse delay logs, owed anything in Rillet?

Accounts payable

Prioritise payments that unblock work

Find vendors with past-due bills who are also causing delay, so payment runs can be sequenced.

On Northwind Plaza, which vendors in the delay log have past-due bills in Rillet?

How it works

What PopdockAI does when you ask

You name the project and your AI assistant reads the delay logs and the bills in Rillet. It reports what the records show and the exact status values it saw.

Ask

You name the project and the date to look from.

Your AI tool

Read

It totals delay time and counts logs for each vendor named in the delay logs.

procore-get-delay-logs
rillet-get-vendors
rillet-get-bills
rillet-get-bill-payments

Match

It finds each vendor in Rillet and reads unpaid bills, due dates and past-due items.

No items found.

Report

You get a row per vendor, with those late and past due first.

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-delay-logs

Returns delay log records from Procore daily logs: the delay type, duration and notes on a project. Filter by project and date range.
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

Delay conversations with the payment position known

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