/
/
Put open Procore bids into the Business Central pipeline
For sales and bid teams who want open Procore bids created as Business Central opportunities, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.
The problem
Open bids never reach the sales pipeline
Bids live in Procore while the pipeline is kept in Business Central, so each one has to be re-keyed. The bids that are forgotten never show up when sales looks at what is coming.
Without PopdockAI
- List the open projects on the Procore bid board
- Search Business Central for each opportunity
- Re-key value, closing date and contact for the missing ones
- Miss a bid and it never shows in the pipeline
With PopdockAI
- Open bids compared with existing Business Central opportunities
- Customer contact filled in only when exactly one matches
- You see the table and choose what to create first
- Each opportunity created once, then read back
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Make sure every Procore bid board project with status {status} (default Bidding) has an opportunity in Business Central, and create the missing ones only after the user confirms the list.
**Step 1: Read the open bids (procore-preconstruction server)**
Call `procore-get-estimating-bid-board-projects` with {status} as `status` (use Bidding when it is empty) and `max-records` of 100. Keep name, customer-company-name, stats-total and due-date. If nothing returns, call it with no filter, list the distinct status values you see and stop.
**Step 2: Find existing opportunities (business-central server)**
For each project call `business-central-get-opportunity` with the project name as `description.contains` and `closed` set to false. A project that has a match is already covered; record the opportunity-number.
**Step 3: Find the contact for the customer (business-central server)**
For each uncovered project call `business-central-get-contact` with customer-company-name as `company-name.contains`. Use contact-number only when exactly one contact matches; otherwise leave it empty and note it.
**Step 4: Confirm before writing**
Show the user a table of the opportunities you would create: description (the Procore project name), estimated-value (stats-total), estimated-closing-date (the due-date as YYYY-MM-DD), contact-number or "none". Ask whether to create them all, some of them or none. Do not continue without an explicit answer.
**Step 5: Create the confirmed opportunities (business-central server)**
For each confirmed row call `business-central-create-opportunity` once with description, estimated-value, estimated-closing-date and contact-number when known. Then call `business-central-get-opportunity` with the returned number as `opportunity-number` to confirm it exists. Report each result.
**Rules & Guidelines:**
* `procore-get-estimating-bid-board-projects` is on the procore-preconstruction server. `business-central-get-opportunity`, `business-central-get-contact` and `business-central-create-opportunity` are on the business-central server.
* `business-central-create-opportunity` is the only write allowed, only in Step 5 and only after the user's confirmation. Never call it twice for the same project, and never call any update or delete tool on either server.
* If `business-central-create-opportunity` is not available because the tool is switched off, say so and stop after Step 4.
**Validation:**
* If every project already has an opportunity, report that and write nothing.
* If a create call fails, report the error and carry on with the remaining rows; do not retry blindly.
* If stats-total is empty, create the opportunity without an estimated-value and say so.Who it's for
One answer, three teams that use it
Sales managers
See every live bid in the pipeline
Get open Procore bids created as opportunities so the pipeline matches the work being estimated.
Create Business Central opportunities for our open Procore bids, once I have seen the list.
Bid coordinators
Stop re-keying bids
Move bid name, value and closing date into the pipeline without typing them in again.
Which bids on the Procore bid board are missing from Business Central, and what would you create?
Finance and forecasting
Forecast from a complete pipeline
Close the gap between estimating and the accounting pipeline so forecasts include every open bid.
Check Procore bids in status Bidding against Business Central opportunities and list the gaps.
How it works
What PopdockAI does when you ask
You give a bid status and your AI assistant compares the bid board with the pipeline. It writes only after you have seen the table and answered.
Ask
You give a bid status, or leave it at Bidding.
Compare
It reads the open Procore bids and finds those with no open opportunity in Business Central.
Confirm
You see each opportunity with its value, closing date and contact, and choose which to create.
Create
It creates each confirmed opportunity once and reads it back to confirm it exists.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics 365 Business Central 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
Every open bid visible in the pipeline
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)
