/
/
Compare Harvest and Dynamics 365 Sales invoices without a spreadsheet
For finance teams who want a client's invoices matched across Harvest and the CRM by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Invoice totals copied between systems drift apart
Finance pastes invoice totals from Harvest and the CRM into a sheet to compare. Paid-versus-unpaid differences and invoices on one side only are easy to overlook in a long list.
Without PopdockAI
- Export invoices from Harvest
- Export invoices from the CRM
- Line them up in a sheet by hand
- Miss paid versus unpaid differences
With PopdockAI
- Both sets of invoices are read for the client
- Pairs are matched by number, or by amount and date
- Currency mismatches are listed, not compared
- It reports differences only, and nothing is edited
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For `{client-name}`, compare invoices in Harvest with invoices in Dynamics 365 Sales, issued on or after `{issued-from}` (YYYY-MM-DD, default the first day of this year), and list amounts, status or existence that disagree.
**Step 1: Harvest invoices (Harvest server)**
Call `harvest-get-invoices` with `client-name.contains` set to `{client-name}` and `issue-date.from` set to `{issued-from}`. Keep `number`, `amount`, `due-amount`, `state`, `issue-date`, `purchase-order` and `currency`. If more than one distinct client name appears, list them and stop.
**Step 2: CRM invoices (Dynamics 365 Sales server)**
Call `dynamics-365-sales-get-invoices` with `customer.contains` set to `{client-name}` and `created-on.from` set to `{issued-from}`. Keep `name`, `invoice-id`, `total-amount`, `amount-due`, `status` and `created-on`.
**Step 3: Match**
Match on the invoice number appearing in the CRM invoice `name`, else on the same amount with an issue date within 7 days. Mark each pair as exact, amount differs, or paid in one and unpaid in the other (Harvest `due-amount` of zero against CRM `amount-due` above zero, or the reverse).
**Step 4: Report**
Table of matched pairs with the difference, then Harvest invoices not in the CRM, then CRM invoices not in Harvest, then totals billed and outstanding in each system.
**Rules & Guidelines:**
* `harvest-*` tools belong to the Harvest server and `dynamics-365-sales-*` tools belong to the Dynamics 365 Sales server. Both servers must be connected.
* This is read-only. Never call any Harvest tool that creates, updates, deletes, stops or restarts anything, and never call `dynamics-365-sales-create-account`, `dynamics-365-sales-create-contact`, `dynamics-365-sales-create-lead`, `dynamics-365-sales-create-opportunity`, `dynamics-365-sales-create-case`, `dynamics-365-sales-create-task`, `dynamics-365-sales-create-note`, `dynamics-365-sales-create-phone-call` or any `dynamics-365-sales-update-*` tool.
* Harvest rates, cost rates and Dynamics 365 credit limits are sensitive: do not show them unless asked.
**Validation:**
* If the currencies differ, do not compare amounts; list the pair as currency mismatch.
* If one side returns nothing, say so; do not list the other side as all unmatched without that note.
* Do not state which system is right; report the difference only.Who it's for
One answer, three teams that use it
Accounts receivable
Spot paid versus unpaid differences
See invoices that Harvest shows as paid but the CRM still shows as due, or the reverse, before you chase the wrong client.
Which Contoso invoices are paid in Harvest but still show an amount due in Dynamics 365 Sales?
Finance analysts
Replace the comparison spreadsheet
Get matched pairs, amount differences and unmatched invoices for a client in one answer, with totals for each system.
Compare Fabrikam invoices in Harvest and Dynamics 365 Sales since the start of the year and total billed and outstanding in each.
Sales operations
Keep CRM invoice records trustworthy
Find Harvest invoices that never made it into the CRM, and CRM invoices with no Harvest match, for a given client.
Are there Northwind Traders invoices in Harvest that do not appear in Dynamics 365 Sales?
How it works
What PopdockAI does when you ask
You name the client and your AI assistant matches the two sets of invoices. It does not say which system is correct, it only reports where they disagree.
Ask
You name the client and a start date.
Read
It reads the client's invoices in Harvest and in Dynamics 365 Sales.
Match
It pairs them by invoice number or by amount and date and marks each pair.
Report
You get the differences, the unmatched invoices on each side and totals for billed and outstanding.
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
microsoft-dynamics-365-sales-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
Every invoice difference in one list
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)
