/
/
Chase overdue Harvest invoices with the deal in view
For finance teams who ask their AI assistant to add OnePageCRM contacts, next actions and open deals to a list of overdue Harvest invoices.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Collections call a customer who is about to buy
Overdue invoices are in Harvest while contacts and deals are in OnePageCRM. Chasing without that context can disrupt a deal and surprise the account owner.
Without PopdockAI
- List overdue invoices in Harvest
- Look up each client in OnePageCRM
- Read contacts, next actions and deals
- Chase before knowing what is in play
With PopdockAI
- Overdue invoices are grouped by client
- Each client is matched to a OnePageCRM company by name
- Contacts, next actions and open deals are added
- Large open deals are flagged as handle with care
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find Harvest invoices overdue by at least `{days-overdue}` days (default 30) and show, for each client, who owns the relationship in OnePageCRM and what else is open, so the right person chases and sensitive deals are handled carefully.
**Step 1: Read overdue invoices (Harvest server)**
Call `harvest-get-invoices` with `state` set to open and `due-date.to` set to today minus `{days-overdue}` days. Keep `number`, `client-name`, `due-date`, `due-amount` and `currency`. Group by `client-name`.
**Step 2: Look up each client in OnePageCRM (OnePageCRM server)**
For each client call `onepagecrm-get-company` with `name.contains` set to the client name. If there is no match, mark the client "not in OnePageCRM". Otherwise keep `id`, then call `onepagecrm-get-contact` with `company-id` set to it to list contacts with `owner-id`, `next-action` and `next-action-date`, and call `onepagecrm-get-deal` with `company-id` set to it to list open deals with `name`, `amount` and `expected-close-date`.
**Step 3: Report**
Give one row per client: total overdue, oldest invoice and days overdue, contacts and their owners, next action and date, number and value of open deals. Sort by total overdue, largest first. Flag clients with open deals over the overdue total as "handle with care".
**Rules & Guidelines:**
* Harvest tools (names starting harvest-) come from the harvest server and OnePageCRM tools (names starting onepagecrm-) come from the onepagecrm server. Both servers must be connected.
* OnePageCRM calls customers companies (and the people at them contacts) and Harvest calls them clients. There is no shared id, so match on name: exact (ignoring case, punctuation and suffixes such as Inc, LLC, Ltd) first, then one name containing the other, and always show which kind of match was used.
* This is read-only. Do NOT call any Harvest create, update, delete, stop or restart tool (for example `harvest-clients-create`, `harvest-contacts-create`, `harvest-invoices-create`, `harvest-estimates-create`, `harvest-time-entries-update`) and do NOT call `onepagecrm-add-contact`, `onepagecrm-add-deal`, `onepagecrm-add-note`, `onepagecrm-add-call`, `onepagecrm-add-meeting`, `onepagecrm-add-action`, `onepagecrm-update-contact`, `onepagecrm-update-deal`, `onepagecrm-update-action`, `onepagecrm-delete-contact` or `onepagecrm-delete-deal`.
* Hourly rates, cost rates and invoice amounts are sensitive: show them only because the user asked for billing context.
**Validation:**
* If there are no overdue invoices, say so and stop.
* If a client name matches more than one company, list the candidates and leave that row unresolved.
* Compute days overdue from today's date and say which date you used.Who it's for
One answer, three teams that use it
Accounts receivable
Chase with the next action in view
You see the contacts and their next actions for each overdue client, so your follow up fits what the sales team is already doing.
Which clients are 45 days or more overdue in Harvest and who is the contact at each in OnePageCRM?
Sales reps
Find out early when your customer owes money
Your companies with overdue invoices are listed with open deals, so you can step in before collections call.
Show overdue Harvest invoices for companies where I have an open OnePageCRM deal.
Finance directors
Decide which overdue accounts to escalate
Overdue totals beside deal value help you tell which accounts need care and which can be chased directly.
Rank overdue Harvest clients by amount and flag any with open OnePageCRM deals bigger than the overdue total.
How it works
What PopdockAI does when you ask
You set how overdue counts and your AI assistant reads Harvest and OnePageCRM. It does not send messages or record payments.
Ask
You say how many days overdue to look for.
Read
It lists open Harvest invoices past that date, grouped by client.
Match
It finds each client in OnePageCRM by name and reads contacts, next actions and open deals.
Report
You get one row per client, largest overdue first, with handle with care flags.
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
onepagecrm-get-company
onepagecrm-get-contact
onepagecrm-get-deal
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 that respect live deals
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)
