/
/
Reconcile Harvest invoices to Business Central postings
For accounting teams who want a month end check of Harvest invoices against Business Central by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Invoice reconciliation is found late and by hand
Ticking Harvest invoices off against ERP postings is a month end chore. An invoice that never posted, or posted with a different amount, only shows up once the close is under way.
Without PopdockAI
- List the month Harvest invoices
- Search the ERP for each number
- Check unposted documents separately
- Compare amounts and paid status line by line
With PopdockAI
- Harvest invoices are read and drafts skipped
- Posted and unposted documents are searched by number
- Each invoice gets a clear status
- Ambiguous matches are reported, 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 Harvest invoices issued between `{issue-date-from}` and `{issue-date-to}` (default: the last 30 days), find the matching posted sales invoice in Business Central and report missing invoices and amount or payment mismatches.
**Step 1: Read Harvest invoices (Harvest server)**
Call `harvest-get-invoices` with `issue-date.from` = `{issue-date-from}` and `issue-date.to` = `{issue-date-to}`, and `client-name.contains` = `{client-name}` if provided. Skip invoices whose `state` is draft. Keep `number`, `client-name`, `amount`, `due-amount`, `state`, `issue-date`.
**Step 2: Find each invoice in Business Central (Business Central server)**
The Harvest invoice `number` is the join key. Pass `company` = `{company}` on every Business Central call if provided. For each invoice call `business-central-get-posted-sales-invoice` with `external-document-number` = that number. If nothing is found, retry once with `invoice-number` = that number. If still nothing, call `business-central-get-sales-transaction` with `external-document-number` = that number to see whether it exists as an unposted document. Keep `invoice-number`, `total-amount-including-tax`, `remaining-amount`, `sell-to-customer-name`.
**Step 3: Compare and report**
One table with Harvest number, client, Harvest amount, Business Central invoice number and amount, and a status: Matched, Amount differs, Paid in one system only (Harvest `due-amount` is 0 versus Business Central `remaining-amount` above 0, or the reverse), Unposted in Business Central, Missing from Business Central. End with counts per status and the total difference.
**Rules & Guidelines:**
* `harvest-get-invoices` is on the harvest server; the posted invoice and sales transaction tools are on the business-central server.
* This prompt is read-only. Do not call `business-central-create-sales-invoice`, `business-central-update-sales-invoice` or any other create, update or delete tool on either server.
**Validation:**
* If amounts differ only by a rounding gap under 0.01, treat them as matched.
* If Harvest returns no invoices, say so and stop.
* If one invoice number matches more than one Business Central document, report it as ambiguous.Who it's for
One answer, three teams that use it
General ledger accountants
Close the month with matched invoices
Run the whole range in one go and get missing, unposted and mismatched invoices with counts and the total difference.
Reconcile Harvest invoices from 1 October to 31 October with posted invoices in Business Central.
Accounts receivable
Catch a wrong amount early
See invoices posted with a different amount, or paid in one system and open in the other, before a client notices.
Which Northwind Traders invoices in Harvest were posted in Business Central with a different amount?
Finance directors
Trust the revenue numbers
Get a status count and a total difference across the period so you know how far the two systems are apart.
How many Harvest invoices in the last 30 days are missing or unposted in Business Central, and what is the total difference?
How it works
What PopdockAI does when you ask
You choose the date range and your AI assistant checks every invoice. It treats sub-cent rounding as a match and never decides ambiguous cases for you.
Ask
You give a date range and optionally a client.
Read
It reads the Harvest invoices in the range and skips drafts.
Match
It finds each one in Business Central by invoice number, posted first, then unposted.
Report
You get a status per invoice, counts per status and the total difference.
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 clean invoice match before close
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)
