/
/
Warn estimators about overdue customers on the bid board
For project and finance teams who want a customer's overdue Rillet invoices noted on their Procore bid board projects by asking their AI assistant.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Estimators bid blind to overdue balances
The overdue balance for a customer sits in the ledger while estimators work on the bid board. Without a warning on the project, bids go out for customers who are already behind on payment.
Without PopdockAI
- Check the customer's invoices in Rillet
- Add up what is overdue
- Open each bid board project for that customer
- Type a note on every one and hope nobody repeats it
With PopdockAI
- Overdue invoices and the total come from Rillet
- You see the exact note before anything is written
- Only a bid board note is added, never a status change
- Projects with the same note from today are skipped
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the customer `{customer-name}`, find overdue invoices in Rillet and, after confirmation, add a note about them to each of the customer's bid board projects with status `{status}` (default: every status) so the estimator sees it before bidding.
**Step 1: Find the overdue balance (Rillet server)**
Call `rillet-get-customers` and match `name` or `invoicing-name` to `{customer-name}`. If no match, say so and stop. Call `rillet-get-invoices`, which has no filters, keep rows with that `customer-id` where `overdue` is true, and total `amount-due`. If nothing is overdue, report that and stop.
**Step 2: Find the projects (Procore Preconstruction server)**
Call `procore-get-estimating-bid-board-projects` with `customer-company-name.contains` set to `{customer-name}`, and `status` set to `{status}` when it is not empty. Keep `id` and `name`. If none, report the overdue balance and stop.
**Step 3: Confirm**
Show the user the overdue invoices, the total, the projects, and the exact note text: the customer, overdue invoice count, total amount due and today's date. Do not call a write tool until the user explicitly confirms.
**Step 4: Write the notes (Procore Preconstruction server)**
For each project call `procore-create-estimating-bid-board-projects-notes` with `bid-board-project-id` set to the project `id` and `value` set to the confirmed note text. Report each result.
**Rules & Guidelines:**
* `rillet-get-customers` and `rillet-get-invoices` are on the Rillet server; `procore-get-estimating-bid-board-projects` and `procore-create-estimating-bid-board-projects-notes` are on the Procore Preconstruction server.
* `procore-create-estimating-bid-board-projects-notes` is the only tool that may write, and only after Step 3 confirmation. Never change project status, and never call any Rillet add or update tool.
* Tell the user the Procore write tools may be Inactive; if the call is refused, report that and stop.
**Validation:**
* If a project already has a note with the same text from today, tell the user and skip it.
* If the matches cover more than one customer name, list them and stop.Who it's for
One answer, three teams that use it
Estimators
See credit risk before you bid
Find overdue balances noted on the project, so you know before you price work for the customer.
Add a note about Contoso Holdings' overdue Rillet invoices to their bid board projects.
Finance controllers
Pass on credit warnings
Get overdue invoice warnings onto the bid board without messaging every estimator.
Note Fabrikam Developments' overdue invoices on their bid board projects with status Bidding.
Business development managers
Prepare for a customer conversation
Make sure a customer's overdue position is on record before a new proposal goes out.
Northwind Traders owes us overdue invoices in Rillet. Put the total on their open bid board projects.
How it works
What PopdockAI does when you ask
You name the customer and your AI assistant finds the overdue balance and the bid board projects. Nothing is written until you have seen the note and said yes.
Ask
You name the customer and, optionally, a bid board status.
Check
It totals the customer's overdue invoices in Rillet and finds their bid board projects in Procore.
Confirm
You see the invoices, the projects and the exact note, then say yes.
Note
It adds the note to each project, skips any with the same note today and reports each result.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
rillet-get-customers
rillet-get-invoices
procore-get-estimating-bid-board-projects
procore-create-estimating-bid-board-projects-notes
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
Overdue balances visible before the next bid
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)
