/
/
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.
On this page
Connector
Connect Microsoft Dynamics 365 Sales, pick your AI tool and paste the prompt.
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.
**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.
Read
It lists the opportunities won in Dynamics 365 Sales.
Check
It looks for a Harvest client and projects under each customer name.
Report
You get deals with no client, deals with no project and deals already set up, with counts.
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.
microsoft-dynamics-365-sales-get-opportunities
harvest-get-projects
harvest-get-clients
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
No won deal waits for a project
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)
