/
/
Chase overdue Harvest invoices with the CRM picture in view
For collections teams who want overdue Harvest invoices shown next to open Dynamics 365 Sales deals and cases by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Collections calls made without the full relationship
Collectors chase overdue invoices from Harvest without seeing a client's open support case or a deal about to close in the CRM. A reminder sent at the wrong moment damages the relationship.
Without PopdockAI
- Filter Harvest for overdue invoices
- Look up each client in the CRM
- Check for open cases and deals separately
- Call a client in the middle of an escalation
With PopdockAI
- Overdue invoices are listed with days overdue
- Open deals and cases are read for each client
- Clients with no CRM match are labelled, not assumed
- No reminders are sent and rates are hidden
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 overdue by at least `{min-days-overdue}` days (default 1), and for each customer show the open Dynamics 365 Sales opportunities and cases, so the chaser knows the wider relationship. Limit to `{client-name}` if given.
**Step 1: Overdue invoices (Harvest server)**
Call `harvest-get-invoices` with `state` set to open, `due-date.to` set to today minus `{min-days-overdue}` days and `due-amount.min` just above zero. If `{client-name}` is not empty, pass `client-name.contains`. Keep `number`, `client-name`, `due-amount`, `due-date` and `currency`. Compute days overdue.
**Step 2: CRM context (Dynamics 365 Sales server)**
For each distinct client name, call `dynamics-365-sales-get-opportunities` with `potential-customer.contains` and `dynamics-365-sales-get-incidents` with `customer.contains`. Keep open opportunities (stage, estimated revenue) and open cases (priority, title).
**Step 3: Report**
One block per customer: overdue invoices with days overdue and total, then open opportunities, then open cases. Sort customers by total overdue, largest first. Add a one-line "handle with care" note where a customer has an open high-priority case or an opportunity in a late stage.
**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 no invoices are overdue, say so and stop.
* A customer with no CRM match is reported as "no CRM account found", not as having no deals.
* Do not draft or send any reminder here.Who it's for
One answer, three teams that use it
Collections agents
Know who to handle with care
See overdue clients with an open high-priority case or a late-stage deal flagged before you pick up the phone.
List Harvest invoices overdue by at least 10 days and flag clients with open cases or late stage deals in Dynamics 365 Sales.
Account managers
Warn collections about live deals
Check whether a client with an overdue invoice has an opportunity in progress, so the chase and the deal stay in step.
Does Northwind Traders have an overdue invoice in Harvest and an open opportunity in the CRM?
Finance managers
Prioritise by amount and context
Get customers sorted by total overdue with the CRM context beside each, so effort goes where it matters.
Show overdue Harvest invoices by client, largest first, with open opportunities and cases from Dynamics 365 Sales.
How it works
What PopdockAI does when you ask
You set how overdue counts and your AI assistant reads both systems. It only reports, so you decide who to contact and when.
Ask
You give a minimum days overdue and optionally a client.
Read
It lists overdue open Harvest invoices with days overdue.
Add context
It reads each client's open opportunities and cases in Dynamics 365 Sales.
Report
You get a block per customer, largest overdue first, with care notes for sensitive cases.
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-opportunities
microsoft-dynamics-365-sales-get-incidents
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
Collections calls that fit the relationship
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)
