/
/
Find bid board customers missing from NetSuite before you invoice
For finance teams who want Procore bid board customers checked against the NetSuite customer list by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
A won bid has no customer in NetSuite until invoice day
Comparing bid board customers with the NetSuite customer list by hand is slow, and company suffixes and spelling make matches unclear. The gap shows up when the first invoice cannot be raised.
Without PopdockAI
- List bid board projects and their customers
- Search the NetSuite customer list for each name
- Judge near matches by eye
- Discover a missing customer when billing starts
With PopdockAI
- Bid board customers are read from Procore for you
- Each distinct customer is looked up in NetSuite
- Probable matches show both names and ambiguous ones are listed, not picked
- Blank customers are flagged separately and nothing is changed
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 on each Procore bid board project (optionally only those with status {status}) exists as a NetSuite customer, so a won bid can be invoiced without a customer setup delay.
**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`. If {customer-name} is not empty, pass it as `customer-company-name.contains`. Pass `max-records` of 100. Keep name, id, status, customer-company-name and due-date.
**Step 2: Look up each distinct customer (netsuite server)**
For each distinct customer-company-name, call `netsuite-get-customer` with `name.contains` set to that value and `max-records` of 5. Match when the NetSuite name equals the Procore customer name ignoring case, punctuation and suffixes such as Inc, LLC and Ltd. Treat a single partial match as a probable match and say so.
**Step 3: Report**
Give three lists: bid board projects with a matching NetSuite customer (show the NetSuite internal-id and email), projects with only a probable match (show both names), and projects whose customer has no NetSuite record. List bid board projects with a blank customer separately as missing a customer.
**Rules & Guidelines:**
* `procore-get-estimating-bid-board-projects` is on the procore-preconstruction server; `netsuite-get-customer` is on the netsuite server. Both servers must be connected.
* This prompt is read-only. Do not call any create, update or delete tool on either server, including `netsuite-add-customer` and `procore-update-bid-board-project`.
**Validation:**
* If no bid board projects come back, say so and stop.
* If `netsuite-get-customer` returns nothing for a name, record it as present in Procore and absent from NetSuite and continue with the next customer.
* If two NetSuite customers match one Procore name, list both and do not pick one.Who it's for
One answer, three teams that use it
Accounts receivable
Set up customers before billing
See which won bids need a NetSuite customer so setup is done before the invoice is due.
Which customers on our awarded Procore bid board projects are not in NetSuite yet?
Estimators
Fix bid board customer names
Find projects with a blank or differently spelled customer so the record is right when the bid is won.
Show bid board projects with no customer and any customer names that only probably match NetSuite.
Finance managers
Reduce billing delays after award
Check the whole bid board in one pass so award does not lead to a customer setup delay.
Check all Procore bid board projects with status BID_SUBMITTED against NetSuite customers.
How it works
What PopdockAI does when you ask
You can narrow by status or customer and your AI assistant checks each bid board customer in NetSuite. It only reads, and it never adds or edits a customer.
Ask
You optionally filter by bid board status or customer name.
Read
It reads the bid board projects and their customer companies from Procore.
Look up
It searches NetSuite for each distinct customer, ignoring case, punctuation and company suffixes.
Report
You get matches, probable matches, missing customers and projects with a blank customer.
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
netsuite-get-customer
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
Customers set up before the first invoice is due
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)
