Connectors

/

Harvest

/

Chase overdue Harvest invoices with OnePageCRM context
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Chase overdue Harvest invoices with OnePageCRM context
List Harvest invoices overdue by more than 30 days and show me what is going on with each client in OnePageCRM before I call anyone.
Four clients are more than 30 days overdue, and two have open deals in OnePageCRM. - Contoso: 7,400.00 overdue, oldest INV-1042 at 47 days, next action Call Dana on Nov 8 - Fabrikam: 3,900.00 overdue, 1 open deal worth 15,000.00, handle with care - Northwind Traders: not in OnePageCRM - Date used: today, Nov 4 Want the open deal details for Fabrikam?
Harvest
Sample figures. Your results come from your own account.
harvest-get-invoices
onepagecrm-get-company
onepagecrm-get-contact
onepagecrm-get-deal

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

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

Your AI tool

Read

It lists open Harvest invoices past that date, grouped by client.

harvest-get-invoices
onepagecrm-get-company
onepagecrm-get-contact
onepagecrm-get-deal

Match

It finds each client in OnePageCRM by name and reads contacts, next actions and open deals.

No items found.

Report

You get one row per client, largest overdue first, with handle with care flags.

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

onepagecrm-get-company

Returns companies from OnePageCRM, with their details and linked contacts.
get-data

onepagecrm-get-contact

Returns contacts from OnePageCRM, with name, company, email, phone, owner and next action. Filter to find one contact or a group.
get-data

onepagecrm-get-deal

Returns deals from OnePageCRM, with their stage, status, amount, expected close date, owner and linked contact or company. Filter by stage, status or date.
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 that respect live deals

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