Connectors

/

Harvest

/

Compare overdue Harvest invoices with Dynamics 365 Sales pipeline
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Compare overdue Harvest invoices with Dynamics 365 Sales pipeline
Which Harvest invoices are more than 15 days overdue, and what open deals or support cases do those clients have in Dynamics 365 Sales?
3 clients have invoices more than 15 days overdue, 18,900.00 in total. - Contoso Ltd, 9,400.00: INV-1042 is 32 days overdue; open case, high priority. Handle with care - Northwind Traders, 6,200.00: INV-1047 is 21 days overdue; opportunity at proposal stage - Tailspin Toys, 3,300.00: no CRM account found Want a different threshold?
Harvest
Sample figures. Your results come from your own account.
harvest-get-invoices
microsoft-dynamics-365-sales-get-opportunities
microsoft-dynamics-365-sales-get-incidents

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

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.

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

Your AI tool

Read

It lists overdue open Harvest invoices with days overdue.

harvest-get-invoices
microsoft-dynamics-365-sales-get-opportunities
microsoft-dynamics-365-sales-get-incidents

Add context

It reads each client's open opportunities and cases in Dynamics 365 Sales.

No items found.

Report

You get a block per customer, largest overdue first, with care notes for sensitive cases.

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.
get-data

microsoft-dynamics-365-sales-get-opportunities

Returns Dynamics 365 Sales opportunities. Filter by owner, status, sales stage, probability, estimated close date, topic, potential customer and estimated revenue, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-incidents

Returns Dynamics 365 Sales cases. Filter by case title, status, customer, priority, owner, case type, created date and case number, and cap how many records come back.
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

Collections calls that fit the relationship

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