/
/
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.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads the Procore offices and the Business Central locations.
Match
It pairs offices to locations on city, state and country and lists ambiguous ones instead of choosing.
Report
You get matched pairs with differences, unmatched offices and unmatched locations.
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-offices
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
One agreed list of offices and locations
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)
