Connectors

/

Procore

/

Reconcile Procore offices with Dynamics 365 Business Central locations
Report
Cross-Connector

Line up Procore offices with accounting locations

For operations teams who want Procore offices matched to Business Central locations, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Procore offices with Dynamics 365 Business Central locations
Reconcile our Procore offices with the Business Central locations for company Northwind Construction, US only.
Of 8 US offices, 6 match a Business Central location, 2 have no location, and 1 location has no office. - Matched: Denver office to location DEN-01, postal code differs (80202 and 80203) - No location: Austin office and Tampa office - No office: location PHX-02 in Phoenix - In transit: 1 transit location was kept out of the unmatched count Want the full list of matched pairs?
Procore
Sample figures. Your results come from your own account.
procore-get-offices

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Procore

Procore
Run it on your own Procore data.

Connect Procore, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Office lists drift between Procore and accounting

Procore offices and Business Central locations are kept separately and typed differently. Comparing them by hand means a missing office, an orphan location or a mismatched address goes unnoticed.

Without PopdockAI

  • Open the office list in Procore
  • Open the location list in Business Central
  • Match them by city and address by eye
  • Miss an office typed with a different spelling

With PopdockAI

  • Both lists are read for you
  • Pairs are matched on city, state and country, never on name alone
  • Ambiguous matches are listed instead of picked
  • In-transit locations stay out of the unmatched count

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Reconcile the Procore offices with the Business Central locations for the company {company}, optionally limited to country code {country-code} (default: all countries).

**Step 1: Read the offices from Procore**

Call `procore-get-offices` (Procore server). If {country-code} is given, pass it as `country-code`. Keep `name`, `city`, `state-code`, `country-code`, `zip` and `phone` from each result.

**Step 2: Read the locations from Business Central**

Call `business-central-get-location` (Business Central server) with `company` set to {company}. If {country-code} is given, pass it as `country-code`. Keep `location-code`, `name`, `city`, `state`, `country-code`, `postal-code` and `phone-number`.

**Step 3: Match across the two systems**

Match each office to a location on city plus state (Procore `state-code` against Business Central `state`) and country. Use name similarity only to break a tie. Treat "NY" and "New York" as the same state. If one office matches several locations, list them all and do not pick one.

**Step 4: Report**

Give three lists: matched pairs (office name, location code, any differing field among city, postal code and phone), offices with no Business Central location, and locations with no Procore office. Locations flagged `use-as-in-transit` are not offices, so list them separately and do not count them as unmatched.

**Rules & Guidelines:**

* `procore-get-offices` is on the Procore server. `business-central-get-location` is on the Business Central server.
* This prompt is read-only. Do not call any create, update or delete tool on either server, including `business-central-create-location` and `procore-create-office`.

**Validation:**

* If `procore-get-offices` returns nothing, report that Procore has no offices for the filter and stop.
* If `business-central-get-location` returns nothing, report every office as unmatched and stop.
* If the two systems disagree on a value (for example a zip against a postal code), report both values and do not decide which is right.

Who it's for

One answer, three teams that use it

Operations managers

Keep sites consistent across systems

See which offices have no matching location so you know where master data is incomplete.

Which Procore offices have no matching location in Business Central for company Fabrikam Construction?

Finance administrators

Find locations with no office

List Business Central locations that no Procore office points to, so stale locations can be reviewed.

List Business Central locations for Contoso Builders that do not match any Procore office.

Master data owners

Compare addresses between systems

Get postal code and phone differences for matched pairs, shown side by side, without deciding for you.

For matched Procore offices and Business Central locations in Canada, show any city, postal code or phone differences.

How it works

What PopdockAI does when you ask

You name the company in plain words and your AI assistant reads Procore offices and Business Central locations and pairs them. It only reads, and shows both values when they differ.

Ask

You name the Business Central company and optionally a country code.

Your AI tool

Read

It reads the Procore offices and the Business Central locations.

procore-get-offices

Match

It pairs offices to locations on city, state and country and lists ambiguous ones instead of choosing.

No items found.

Report

You get matched pairs with differences, unmatched offices and unmatched locations.

Your AI tool

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.

get-data

procore-get-offices

Returns the offices set up in Procore, with address, city, state, country and phone. Used to compare company offices with other systems.
Read only.Nothing in Procore 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

One agreed list of offices and locations

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