/
/
Explain why Harvest and Business Central disagree on a client balance
For collections and finance teams who want a client receivable compared across Harvest and Business Central by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Two systems, two different client totals
Collections teams open Harvest and the ERP side by side to see what a client owes. The totals rarely match, and the reason is buried in invoices open in one place and paid in the other.
Without PopdockAI
- Filter open invoices for the client in Harvest
- Find the same customer in the ERP
- Compare invoice lists and ledger entries
- Miss a block or credit limit on the account
With PopdockAI
- Open Harvest invoices and the customer balance are read
- Invoices open on one side only are listed
- Blocked and over-limit customers are flagged
- Currencies are never converted 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:** For the client `{client-name}`, compare outstanding invoices in Harvest with the receivable balance in Business Central and explain any gap.
**Step 1: Open invoices in Harvest (Harvest server)**
Call `harvest-get-invoices` with `client-name` = `{client-name}` and `due-amount.min` = 0.01. If it returns nothing, retry with `client-name.contains`. Keep `number`, `due-date`, `due-amount`, `state`, `currency`.
**Step 2: Find the customer in Business Central (Business Central server)**
Call `business-central-get-customer` with `name` = `{client-name}`, or `name.contains` if the exact name returns nothing, plus `company` = `{company}` if provided. If more than one customer matches, list them and stop. Keep `customer-number`, `balance`, `balance-due`, `blocked`, `credit-limit`.
**Step 3: Open items in Business Central (Business Central server)**
Call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` from step 2 and `remaining-amount.min` = 0.01. Keep `invoice-number`, `external-document-number`, `due-date`, `remaining-amount`. If the totals still do not explain the gap, call `business-central-get-detailed-customer-ledger` with `customer-number` and look for unapplied entries or credits.
**Step 4: Report**
Show total due in Harvest, total `balance-due` in Business Central, the difference, and a list of invoices that explain it (open in one system and not the other, matched through `external-document-number` against the Harvest `number`). Mention if the customer is `blocked` or over `credit-limit`.
**Rules & Guidelines:**
* `harvest-get-invoices` is on the harvest server; customer, posted invoice and ledger tools are on the business-central server.
* Read-only. Do not call any create, update or delete tool on either server, including `business-central-update-customer`.
**Validation:**
* If the two currencies differ, show both amounts and do not convert.
* If the client has no matching customer, report that and finish with the Harvest figures alone.Who it's for
One answer, three teams that use it
Collections agents
Know what a client really owes
Get both systems totals and the invoices that explain the difference before you call, so the conversation starts from facts.
What does Contoso owe according to Harvest and Business Central, and which invoices explain any difference?
Credit controllers
See holds and limits with the balance
The comparison flags a blocked customer or one over its credit limit alongside the open invoices.
Compare Fabrikam open invoices in Harvest with their Business Central balance and tell me if they are blocked or over limit.
Finance analysts
Trace the gap to specific invoices
See which invoices are open in one system and not the other, matched by invoice number, instead of hunting through ledgers.
Why does Northwind Traders show 3,250.00 more outstanding in Harvest than in Business Central?
How it works
What PopdockAI does when you ask
You name a client and your AI assistant compares the open items in both systems. It stops on an ambiguous customer match and shows both amounts when currencies differ.
Ask
You name the client.
Match
It reads open Harvest invoices and finds the single matching Business Central customer.
Compare
It reads open posted invoices and, if needed, ledger entries to explain the gap.
Report
You see both totals, the difference, the invoices behind it and any block or credit limit flag.
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-invoices
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
A receivable gap you can explain
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)
