/
/
See how a project is tracking in both Harvest and Business Central
For project managers who want Harvest budget and Business Central job costing compared by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Budget and job costing live in two places
A project's budget sits in Harvest and its job costing in the ERP, so a simple status question means opening both and lining them up by hand. Hours get compared with currency amounts and mismatched jobs go unnoticed.
Without PopdockAI
- Open the Harvest project budget report
- Hunt for the matching Business Central job
- Total the job budget and usage lines
- Compare hours against amounts by eye
With PopdockAI
- The project and its job are found and matched for you
- Job budget and usage lines are totalled
- Hours are never compared with amounts
- Ambiguous projects stop the check, 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.
**Objective:** Compare the Harvest project `{project-name}` with the Business Central job it corresponds to and report where budget and spend disagree.
**Step 1: Harvest project (Harvest server)**
Call `harvest-get-project-budget-report` with `project-name.contains` = `{project-name}`. If it returns more than one project, list them and stop. Keep `project-id`, `budget`, `budget-spent`, `budget-remaining`, `budget-by`, `client-name`. Then call `harvest-get-projects` with `id` = that project-id and keep `code`.
**Step 2: Business Central job (Business Central server)**
If `{job-number}` is given call `business-central-get-job` with `job-number` = `{job-number}`; otherwise use the Harvest project `code` as `job-number`, and if that finds nothing search `description.contains` = `{project-name}`. Add `company` = `{company}` if provided. Keep `job-number`, `status`, `bill-to-customer-number`, `recognized-sales-amount`, `recognized-costs-amount`.
**Step 3: Job budget lines (Business Central server)**
Call `business-central-get-job-task` with `job-number` from step 2. Total `total-price-budget`, `total-price-usage`, `total-cost-budget` and `total-cost-usage`.
**Step 4: Report**
Side by side: Harvest budget, spent, remaining and Business Central price budget, usage, cost usage. Show the difference in spend, whether the client and bill-to customer look like the same party, and whether Business Central shows the job as complete or blocked while the Harvest project is still active.
**Rules & Guidelines:**
* `harvest-get-project-budget-report` and `harvest-get-projects` are on the harvest server; `business-central-get-job` and `business-central-get-job-task` are on the business-central server.
* Read-only. Do not call any create, update or delete tool on either server.
**Validation:**
* If `budget-by` is hours, compare hours only and say Business Central values are amounts.
* If no job matches, report the project as having no Business Central job and show the Harvest figures.Who it's for
One answer, three teams that use it
Project managers
Answer how is it tracking in one step
Get Harvest budget and Business Central job figures side by side without opening both systems and matching them yourself.
Compare the Contoso migration project in Harvest with its job in Business Central and show where spend differs.
Delivery leads
Catch jobs that closed too early
See when the ERP shows a job as complete or blocked while the Harvest project is still running and logging time.
Is the Northwind Traders rollout still active in Harvest while its Business Central job is blocked or complete?
Project accountants
Tie budget to the right customer
Check that the Harvest client and the job's bill-to customer look like the same party before you rely on the numbers.
For job J-2087, does the bill-to customer match the Harvest client on the Fabrikam project?
How it works
What PopdockAI does when you ask
You name the project and your AI assistant reads both systems. It stops if more than one project matches and reports a missing job rather than guessing.
Ask
You name the Harvest project and optionally the job number.
Read
It reads the project budget and spend, then finds the matching Business Central job.
Total
It adds up the job budget and usage lines.
Report
You see both sides, the spend difference and any status mismatch.
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-project-budget-report
harvest-get-projects
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
One honest view of project spend
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)
