/
/
Know every won bid customer can be invoiced
For finance teams who want Procore bid board customers checked against Business Central before the first invoice, just by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
A won bid is only billable if the customer exists
Procore holds the customer on a bid as free text, while Business Central holds the real customer record. Nobody compares them until an invoice stalls on a missing, blocked or over-limit customer.
Without PopdockAI
- List the customer on every bid board project
- Search Business Central for each name by hand
- Guess between near matches and similar names
- Find blocked or over-limit customers when billing starts
With PopdockAI
- Every distinct customer is looked up in Business Central for you
- Missing, contact-only and blocked customers are listed
- Credit limit risk is checked against the bid value
- Nothing is created or changed in either system
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Check that the customer company on each Procore bid board project (only those with status {status}, all if empty) exists as a Business Central customer, is not blocked and is not already in trouble on its balance, so a won bid can be invoiced without a surprise.
**Step 1: Read the bid board projects (procore-preconstruction server)**
Call `procore-get-estimating-bid-board-projects`. If {status} is not empty pass it as `status`. Pass `max-records` of 200. Keep name, status, customer-company-name, due-date and stats-total. Build the list of distinct customer-company-name values and remember which projects use each one. Skip projects with no customer-company-name and list them separately.
**Step 2: Find each customer in Business Central (business-central server)**
For each distinct customer name, call `business-central-get-customer` with the name as `name.contains`. If that finds nothing, shorten the name to its first two words and try once more, then call `business-central-get-contact` with the name as `company-name.contains` to see whether it exists only as a contact. If one customer matches, keep customer-number, blocked, balance, balance-due, credit-limit and outstanding-orders. If more than one matches, list the candidates and do not guess which is right.
**Step 3: Report**
Give one table with a row per distinct customer: Procore customer name, number of projects and their combined stats-total, the Business Central customer-number and name (or "no match" or "contact only"), blocked, balance-due, and credit-limit. Then three short lists: customers with no Business Central customer, customers that are blocked, and customers whose balance plus the combined stats-total of their projects would exceed credit-limit (only when credit-limit is above zero).
**Rules & Guidelines:**
* `procore-get-estimating-bid-board-projects` is on the procore-preconstruction server. `business-central-get-customer` and `business-central-get-contact` are on the business-central server.
* Do not call any create or update tool on either server. Never create the missing customers; only report them.
* Match on names only as a lead. Procore holds the customer as free text, so say which matches are exact and which are approximate.
**Validation:**
* If Step 1 returns no projects, say so and stop.
* If Business Central returns nothing for every customer, say the company may be wrong or the connection empty rather than reporting every customer as missing.
* Procore amounts and Business Central amounts may be in different currencies. Show currency where it is returned and do not add figures in different currencies together.Who it's for
One answer, three teams that use it
Accounts receivable
Spot customers you cannot bill yet
See which won bids have a customer that is missing or blocked in Business Central before you raise the first invoice.
Which customers on our Won Procore bid board projects are missing or blocked in Business Central?
Credit controllers
See credit limit risk on new work
Check whether a customer's balance plus the value of their won bids would pass the credit limit, without totalling it by hand.
Would any customer's balance plus their Won Procore bids go over their Business Central credit limit?
Finance managers
Set up customers while bids are live
Get the list of bid customers that only exist as contacts so they can be set up as customers before work starts.
Check the Procore bid board projects due this quarter and list customers that only exist as contacts in Business Central.
How it works
What PopdockAI does when you ask
You ask about the bid board in plain words and your AI assistant reads Procore, then looks each customer up in Business Central. It only reads, and it shows which matches are exact.
Ask
You name a bid board status, or leave it blank to check every project.
Read
It collects the distinct customer on each Procore bid board project and the bid value.
Look up
It finds each customer in Business Central and notes blocked status, balance and credit limit.
Report
You get one table plus lists of missing, blocked and over-limit customers.
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-estimating-bid-board-projects
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
Clear every won bid for invoicing before it matters
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)
