Connectors

/

Harvest

/

Harvest and Dynamics 365 Sales client brief
Report
Cross-Connector

Walk into client calls with billing, pipeline and support in one brief

For account managers who want a client brief from Harvest and Dynamics 365 Sales by asking their AI assistant.

Try PopdockAI free
Get a live demo
Harvest and Dynamics 365 Sales client brief
I have a call with Contoso tomorrow. Give me a brief from Harvest and Dynamics 365 Sales covering the last 90 days.
Contoso is a healthy account with one thing to raise: unpaid billing alongside an open case. - Billing (Harvest): 3 invoices, INV-1042 overdue at 6,200.00 - Work in progress (Harvest): 42.5 hours uninvoiced, 1,850.00 - Pipeline (Dynamics 365 Sales): 1 open opportunity, 40,000.00 est. revenue - Support (Dynamics 365 Sales): 1 open high priority case Want the points to watch in more detail?
Harvest
Sample figures. Your results come from your own account.
harvest-get-clients
harvest-get-invoices
harvest-get-uninvoiced-report
harvest-get-time-reports
harvest-get-project-budget-report
microsoft-dynamics-365-sales-get-accounts
microsoft-dynamics-365-sales-get-opportunities
microsoft-dynamics-365-sales-get-incidents
microsoft-dynamics-365-sales-get-invoices

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

Client calls start with four tabs and missed signals

Preparing for a client call means opening the CRM account, Harvest and the invoices in each. An unpaid bill or open case can still slip through, and the conversation starts on the wrong foot.

Without PopdockAI

  • Open the CRM account and its opportunities
  • Open the client in Harvest and its invoices
  • Check uninvoiced work and hours separately
  • Miss an unpaid bill or open case

With PopdockAI

  • Both systems are read for the same client
  • Every figure is labelled with its source system
  • Ambiguous clients and accounts stop the brief
  • Rates are hidden and nothing is changed

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Build a single account brief for `{client-name}`, covering Harvest billing and time over the last `{lookback-days}` days (default 90) and the Dynamics 365 Sales relationship.

**Step 1: Find the client in Harvest (Harvest server)**

Call `harvest-get-clients` with `name.contains` set to `{client-name}`. If more than one client matches, list them and stop. If none, report the client as absent from Harvest and continue with Step 3 only.

**Step 2: Harvest billing and work**

Using the client `id` as `client-id` where the tool has it, otherwise the exact client name as `client-name`:

* `harvest-get-invoices` for invoices issued in the window; note amount, due-amount and state.
* `harvest-get-uninvoiced-report` for the same window; note uninvoiced hours and amount.
* `harvest-get-time-reports` for the window; note total and billable hours.
* `harvest-get-project-budget-report` for active projects; note budget remaining.

**Step 3: Find the account (Dynamics 365 Sales server)**

Call `dynamics-365-sales-get-accounts` with `account-name.contains` set to `{client-name}`. If more than one matches, list them and stop. If none, report the client as absent from the CRM and skip to Step 5.

**Step 4: CRM side**

Using the exact account name as `potential-customer` or `customer`:

* `dynamics-365-sales-get-opportunities`: open ones with stage and estimated revenue.
* `dynamics-365-sales-get-incidents`: open cases with priority.
* `dynamics-365-sales-get-invoices`: any with `amount-due` above zero.

**Step 5: Report**

Sections: Billing (Harvest), Work in progress (Harvest), Pipeline (CRM), Support (CRM), then "Things to watch" with at most five points that connect the two sides, for example large uninvoiced work while a CRM invoice is also unpaid, or an open high-priority case on a client with little recent billable time.

**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:**

* Do not guess when the names differ between systems: stop at an ambiguous match and ask which record to use.
* Say which system each figure came from, and show amounts with their currency.
* If a tool returns no rows, write "none found" for that section.

Who it's for

One answer, three teams that use it

Account managers

Prepare for the call in one request

Get billing, work in progress, pipeline and support for the client in a single brief instead of checking four places.

Brief me on Northwind Traders before my call, using Harvest and Dynamics 365 Sales for the last 90 days.

Sales executives

See billing risk behind a deal

Spot an overdue invoice or open case on a client with a deal in progress before you push for the close.

Does Fabrikam have unpaid invoices or open cases that I should know about before the renewal meeting?

Delivery leads

Know how much work is unbilled

See uninvoiced hours and remaining project budget next to the client relationship, with rates kept out of view.

For Contoso, how much uninvoiced work and remaining budget does Harvest show, and what is open in the CRM?

How it works

What PopdockAI does when you ask

You name the client and your AI assistant gathers the picture from both systems. It will not guess when names differ between Harvest and the CRM.

Ask

You name the client and optionally a look-back period.

Your AI tool

Find

It matches the client in Harvest and the account in Dynamics 365 Sales and stops if either is ambiguous.

harvest-get-clients
harvest-get-invoices
harvest-get-uninvoiced-report
harvest-get-time-reports
harvest-get-project-budget-report
microsoft-dynamics-365-sales-get-accounts
microsoft-dynamics-365-sales-get-opportunities
microsoft-dynamics-365-sales-get-incidents
microsoft-dynamics-365-sales-get-invoices

Gather

It reads billing and hours from Harvest, then opportunities, cases and invoices from the CRM.

No items found.

Brief

You get sections for billing, work, pipeline and support plus points to watch.

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

Returns clients from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
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

harvest-get-uninvoiced-report

Returns uninvoiced report from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
get-data

harvest-get-time-reports

Returns time reports by client from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
get-data

harvest-get-project-budget-report

Returns project budget report from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
get-data

microsoft-dynamics-365-sales-get-accounts

Returns Dynamics 365 Sales accounts. Filter by city, annual revenue, status, industry, account number, email, account name and state, and cap how many records come back.
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.
get-data

microsoft-dynamics-365-sales-get-invoices

Returns Dynamics 365 Sales invoices. Filter by name, customer, invoice ID, created date, total amount, status reason and due date, 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

Better prepared client conversations

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