/
/
Find clients missing between Harvest and Business Central
For finance and operations teams who want Harvest clients matched to Business Central customers by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Client lists drift apart between systems
Exporting two lists and comparing them by eye is slow, and names rarely match exactly. A client billed in Harvest with no ERP customer, or the reverse, goes unnoticed until it causes trouble.
Without PopdockAI
- Export Harvest clients and ERP customers
- Compare names by eye in a sheet
- Guess whether Contoso and Contoso Ltd are the same
- Miss clients that exist on only one side
With PopdockAI
- Both lists are read and matched for you
- Case, punctuation and suffixes are ignored
- Ambiguous matches are listed, never picked
- Truncated lists are flagged 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:** Compare active Harvest clients with Business Central customers and report which clients have no customer, which customers have no active client, and where matched pairs disagree. Only clients whose name contains `{client-name}` are checked when it is given; otherwise all active clients are checked (default).
**Step 1: List Harvest clients (Harvest server)**
Call `harvest-get-clients` with `active` = true, and `name.contains` = `{client-name}` if provided. Keep `id`, `name` and `currency` for each.
**Step 2: List Business Central customers (Business Central server)**
Call `business-central-get-customer` with `company` = `{company}` if provided, and `name.contains` = `{client-name}` if provided. Keep `customer-number`, `name`, `blocked`, `email` and `balance`.
**Step 3: Match across systems**
Match each Harvest client `name` to a Business Central customer `name`, ignoring case, punctuation and suffixes such as Inc, LLC, Ltd. Never match on a partial word. If one client matches two or more customers, list them as ambiguous and do not pick one.
**Step 4: Report**
Three tables: (a) Harvest clients with no matching customer, (b) customers with no matching active Harvest client, (c) matched pairs showing client id, customer-number, whether the customer is `blocked`, and the customer's balance. End with counts for each table.
**Rules & Guidelines:**
* `harvest-get-clients` is on the harvest server; `business-central-get-customer` is on the business-central server.
* This prompt is read-only. Do not call `business-central-create-customer`, `business-central-update-customer`, or any other create, update or delete tool on either server.
**Validation:**
* If either list returns nothing, say which system returned nothing and stop; do not report every record as unmatched.
* If a result hits the record limit, say the comparison is partial and suggest narrowing with `{client-name}`.Who it's for
One answer, three teams that use it
Finance controllers
Keep customer master data in step
See clients with no customer record and customers with no active client, so billing never lands on a missing account.
List active Harvest clients that have no customer in Business Central.
Operations managers
Check a client before onboarding work
Narrow the match to a name and see whether the client exists on both sides and whether the customer is blocked.
Does Fabrikam exist as both a Harvest client and a Business Central customer, and is it blocked?
Data stewards
Surface duplicates and near matches
Ambiguous matches are listed side by side so you can decide which record is right instead of trusting a guess.
Which Harvest clients match more than one Business Central customer?
How it works
What PopdockAI does when you ask
You ask for the comparison and your AI assistant reads both lists and matches by name. If either side returns nothing it stops instead of calling every record unmatched.
Ask
You can name a client to narrow the check, or compare all active clients.
Read
It lists active Harvest clients and Business Central customers.
Match
It pairs names ignoring case, punctuation and suffixes and flags ambiguous ones.
Report
You get clients without a customer, customers without a client and matched pairs with counts.
What PopdockAI provides
The tools behind the answer
Ready made tools for Harvest and one secure connection to your AI tool. No code, no exports.
harvest-get-clients
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 client accounted for in both systems
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)
