Connectors

/

Microsoft Dynamics 365 Business Central

/

Create Dynamics 365 Business Central opportunities for open Procore bids
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Create Dynamics 365 Business Central opportunities for open Procore bids
Which of our open Procore bids are not yet opportunities in Business Central? Show me what you would create.
3 open Procore bids have no opportunity in Business Central, and 5 are already covered. - Riverside Tower fit-out: Contoso Developments, $1,200,000, closing 28 November - Northwind Plaza lobby: Northwind Properties, $640,000, closing 5 December - Contact: none found for Fabrikam Holdings, so it would be left empty - Existing: 5 bids already have an open opportunity Should I create all three, some of them or none?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
procore-get-estimating-bid-board-projects

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Compare

It reads the open Procore bids and finds those with no open opportunity in Business Central.

procore-get-estimating-bid-board-projects

Confirm

You see each opportunity with its value, closing date and contact, and choose which to create.

No items found.

Create

It creates each confirmed opportunity once and reads it back to confirm it exists.

Your AI tool

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.

get-data

procore-get-estimating-bid-board-projects

Returns Procore Preconstruction bid board projects, with status and the assigned estimator.
Read only.Nothing in Microsoft Dynamics 365 Business Central 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

Every open bid visible in the pipeline

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