Connectors

/

Harvest

/

Find Harvest invoices not booked in Business Central
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Find Harvest invoices not booked in Business Central
Which Harvest invoices issued since 1 October have no matching document in Business Central? Group them by client and tell me if the customer exists there.
3 Harvest invoices from 1 October are not in Business Central, worth 18,450.00 in total. - Northwind Traders: INV-1042 (6,200.00), INV-1047 (4,250.00), customer exists - Contoso Ltd: INV-1051 (8,000.00), no customer found, create it first - Checked: 41 sent or paid invoices, drafts and voids excluded Want the same check for September?
Harvest
Sample figures. Your results come from your own account.
harvest-get-invoices

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Harvest

Harvest
Run it on your own Harvest data.

Connect Harvest, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Read

It lists the sent or paid Harvest invoices and leaves out drafts and voids.

harvest-get-invoices

Match

It looks for each number among posted and unposted Dynamics 365 Business Central documents and checks the customer.

No items found.

Report

You get missing invoices per client, subtotals and the total not yet booked.

Your AI tool

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.

get-data

harvest-get-invoices

Returns invoices from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
Read only.Nothing in Harvest Changes

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.

How Popdock AI secures your data

The outcome

A clear list of what still needs booking

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation