/
/
Spot Harvest invoices that never reached Business Central
For accounts teams who want a list of unbooked Harvest invoices, grouped by client, just by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Unbooked invoices hide until the month closes
Checking Harvest against Business Central means searching one invoice number at a time and then looking up the customer. Drafts and voids add noise, and an invoice that was never booked is found late.
Without PopdockAI
- Scroll the Harvest invoice list
- Search Business Central for each number
- Look up each client as a customer
- Find the gaps only at close
With PopdockAI
- Sent and paid Harvest invoices are read for you
- Posted and unposted documents are checked in Business Central
- Customer status is shown for each client
- Nothing is created or changed in either system
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List Harvest invoices issued from `{issue-date-from}` (default: the first day of this month) that are open or paid and have no document in Business Central, grouped by client, so the user can see what still needs booking.
**Step 1: Harvest invoices (Harvest server)**
Call `harvest-get-invoices` with `issue-date.from` = `{issue-date-from}` and `client-name.contains` = `{client-name}` if provided. Exclude draft and void invoices by `state`. Keep `number`, `client-name`, `amount`, `issue-date`.
**Step 2: Business Central lookup (Business Central server)**
Call `business-central-get-posted-sales-invoice` with `posting-date.from` = `{issue-date-from}` and `max-records` high enough to cover the range; build a set of `external-document-number` values. For Harvest invoices not in that set, call `business-central-get-sales-transaction` with `external-document-number` = the Harvest `number` to find unposted documents.
**Step 3: Customer check (Business Central server)**
For each client with a missing invoice call `business-central-get-customer` with `name` = the client name to say whether the customer exists, so the user knows if the customer must be created first.
**Step 4: Report**
Per client: missing invoice numbers, amounts, subtotal, and whether a customer exists. Finish with the total value not yet booked.
**Rules & Guidelines:**
* `harvest-get-invoices` is on the harvest server; documents and customers come from the business-central server.
* Read-only. Do not call `business-central-create-sales-invoice`, `business-central-create-customer` or any other create, update or delete tool on either server.
**Validation:**
* If Business Central returns no posted invoices at all for the range, warn that the join key may not be filled in before listing everything as missing.
* If no Harvest invoices are found, say so and stop.Who it's for
One answer, three teams that use it
Accounts receivable
Find invoices that were never booked
See every Harvest invoice with no document in the ERP, by client and with a subtotal, instead of searching numbers one by one.
List Harvest invoices from the start of this month that are not in Business Central, grouped by client.
Finance managers
Know the unbooked value before close
Get the total value not yet booked, so open items are cleared before the period ends rather than discovered after it.
What is the total of Harvest invoices since 1 October that are missing from Business Central?
Billing coordinators
Check whether the customer exists first
Each missing invoice shows whether the client already has a customer record, so you know what to create before booking.
Check Fabrikam invoices in Harvest against Business Central and tell me if Fabrikam is set up as a customer.
How it works
What PopdockAI does when you ask
You give a start date and your AI assistant compares the two systems. It warns when the matching number looks unpopulated rather than reporting everything as missing.
Ask
You give a start date and optionally a client name.
Read
It lists the sent or paid Harvest invoices and leaves out drafts and voids.
Match
It looks for each number among posted and unposted Dynamics 365 Business Central documents and checks the customer.
Report
You get missing invoices per client, subtotals and the total not yet booked.
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 clear list of what still needs booking
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)
