Connectors

/

Microsoft Dynamics 365 Sales

/

Find won Dynamics 365 Sales deals without Harvest projects
Report
Cross-Connector

Catch won deals that still have no Harvest project

For project managers who want won Dynamics 365 Sales deals checked against Harvest by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find won Dynamics 365 Sales deals without Harvest projects
Which deals did we win in Dynamics 365 Sales since 1 October that do not have a project in Harvest yet?
5 deals won since 1 October, 2 have no Harvest project yet. - No Harvest client: Wingtip Traders, Website rebuild, 28,000.00, closed 14 Oct, owner Sam Patel - Client but no project: Fabrikam, Annual support, 12,500.00, closed 21 Oct, owner Dana Whitfield - Already set up: Contoso, Northwind Traders, Tailspin Toys Matches are by customer name only. Want the setup deals listed with their projects?
Microsoft Dynamics 365 Sales
Sample figures. Your results come from your own account.
microsoft-dynamics-365-sales-get-opportunities
harvest-get-projects
harvest-get-clients

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Sales

Microsoft Dynamics 365 Sales
Run it on your own Microsoft Dynamics 365 Sales data.

Connect Microsoft Dynamics 365 Sales, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Won deals reach delivery by accident

Nobody checks the CRM against Harvest for new projects, so a won deal is noticed only when the client asks about kickoff. Matching deals to clients and projects by hand is slow and easy to skip.

Without PopdockAI

  • Filter the CRM for deals won recently
  • Search Harvest for each customer name
  • Check clients and projects separately
  • Hear about the deal when the client calls

With PopdockAI

  • Won opportunities are listed for the period
  • Harvest clients and projects are checked per customer
  • Deals are grouped by what is missing
  • Matches are labelled name-based, and nothing is created

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 opportunities won in Dynamics 365 Sales since `{won-since}` (YYYY-MM-DD) that have no Harvest project for the same customer, optionally only for `{client-name}`.

**Step 1: Won opportunities (Dynamics 365 Sales server)**

Call `dynamics-365-sales-get-opportunities` with `status` set to Won and `est-close-date.from` set to `{won-since}`. If `{client-name}` is not empty, pass it as `potential-customer.contains`. Keep `topic`, `potential-customer`, `actual-revenue`, `actual-close-date` and `owner`.

**Step 2: Harvest projects (Harvest server)**

For each distinct `potential-customer`, call `harvest-get-projects` with `client-name.contains` set to that name. Keep project `name`, `code`, `active`, `starts-on` and `budget`. Also call `harvest-get-clients` with `name.contains` to tell "no client" apart from "client with no project".

**Step 3: Report**

Three groups: won deals whose customer has no Harvest client, won deals with a client but no project, and won deals with at least one project (list it). For the first two, include topic, customer, revenue, close date and owner. Add counts.

**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 the Won status value is rejected, call without the status filter and keep only rows whose status reads Won.
* A match is by customer name only; say that a project may exist under a different client name.
* If no won opportunities come back, say so and stop.

Who it's for

One answer, three teams that use it

Project managers

Know about new work first

See every recently won deal that has no Harvest client or project, so kickoff planning starts before the client asks.

Which deals won in Dynamics 365 Sales this quarter have no project in Harvest?

Resource planners

Plan capacity for incoming work

Get topic, revenue and close date for won deals still waiting on a project, to plan staffing ahead.

List won deals since 1 September with their revenue and close date that are not yet set up in Harvest.

Sales operations

Close the loop on handoffs

Check that each won deal for a given customer reached delivery, and see the owner when it did not.

Did the Fabrikam deal we closed last month get a client and project in Harvest?

How it works

What PopdockAI does when you ask

You choose the date and your AI assistant compares won deals with Harvest. It tells you a project may exist under a different client name and stops if no deals were won.

Ask

You give a since date and optionally a customer name.

Your AI tool

Read

It lists the opportunities won in Dynamics 365 Sales.

microsoft-dynamics-365-sales-get-opportunities
harvest-get-projects
harvest-get-clients

Check

It looks for a Harvest client and projects under each customer name.

No items found.

Report

You get deals with no client, deals with no project and deals already set up, with counts.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics 365 Sales and one secure connection to your AI tool. No code, no exports.

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

harvest-get-projects

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

harvest-get-clients

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

No won deal waits for a project

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