Connectors

/

Microsoft Dynamics 365 Business Central

/

Dynamics 365 Business Central and Teamwork.com client account overview
Report
Cross-Connector

See what a client owes and how their projects are going

For account leads who want Business Central balances and Teamwork.com project health side by side before a client meeting, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Dynamics 365 Business Central and Teamwork.com client account overview
Before my meeting with Contoso, what do they owe in Business Central and how are their Teamwork.com projects?
Contoso owes 24,800, with 9,600 overdue, on 3 active projects. - Finance: credit limit 50,000, not blocked, oldest invoice 41 days overdue - Website rebuild: on track, 62 percent of budget used - Data migration: health at risk, 108 percent of budget used - Attention: overdue balance on a client with active work Want the open invoices?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
teamwork-com-get-companies
teamwork-com-get-projects
teamwork-com-get-project-health
teamwork-com-get-budgets

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

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

Try PopdockAI free

The problem

Walking into a client meeting with half the picture

Before a client meeting you need to know whether they owe money in Business Central and how their work is going in Teamwork.com. Getting both means pulling invoices from one and project health and budgets from the other, then judging whether the stories conflict.

Without PopdockAI

  • Look up the client's balance and open invoices
  • Open each Teamwork.com project for status and health
  • Check budget used project by project
  • Miss that an overdue balance sits on active work

With PopdockAI

  • Balance, credit limit, block status and open invoices are read, overdue first
  • Each active project's status, end date, health and budget used are shown
  • An attention list flags conflicts between money and delivery
  • Amounts and budgets are never mixed, 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:** Give a single view of client `{customer-name}`: what they owe in Business Central company `{company}` (default: the default company) and how their project work in Teamwork is going.

**Step 1: Find the customer in Business Central**

Call `business-central-get-customer` (Business Central server) with `name.contains` set to `{customer-name}`, and `company` set to `{company}` when given. If nothing matches, stop and say so. If more than one customer matches, list them (customer-number, name, city) and ask which one is meant.

Keep `customer-number`, `name`, `balance`, `balance-due`, `credit-limit`, `blocked`, `payment-terms-code` and `salesperson-code`.

**Step 2: Read their open invoices**

Call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` set to the customer-number from Step 1 and `remaining-amount.min` set to 0.01. For each invoice keep `invoice-number`, `posting-date`, `due-date`, `total-amount-including-tax` and `remaining-amount`. Mark an invoice overdue when its due-date is before today.

**Step 3: Find the client in Teamwork**

Call `teamwork-get-companies` (Teamwork server) with `name.contains` set to `{customer-name}`. Choose the company whose name matches the BC customer name, ignoring case, punctuation and legal suffixes. If none matches, report the finance half only and say the client has no Teamwork company.

**Step 4: Read their projects**

Call `teamwork-get-projects` with `company-id` set to the Teamwork company-id. For each active project, call `teamwork-get-project-health` and `teamwork-get-budgets` with its `project-id`. Keep the project name, status, end-date, health-score, and each budget's type, capacity and capacity-used.

**Step 5: Report**

* **Finance (Business Central):** balance, balance-due against credit-limit, blocked, then a table of open invoices with the overdue ones first and the days overdue.
* **Delivery (Teamwork):** a table of projects with status, end-date, health-score and budget used as a percentage of capacity.
* **Attention:** one line per issue, for example an overdue balance on a client whose projects are still active, a project over budget, or a blocked customer with active projects.

**Rules & Guidelines:**

* `business-central-get-customer` and `business-central-get-posted-sales-invoice` are on the Business Central server. `teamwork-get-companies`, `teamwork-get-projects`, `teamwork-get-project-health` and `teamwork-get-budgets` are on the Teamwork server.
* This prompt is read-only. Do NOT call any `business-central-create-*`, `business-central-update-*`, `teamwork-create-*` or `teamwork-update-*` tool.

**Validation:**

* If there are no open invoices, say the customer is paid up rather than leaving the section empty.
* Amounts come from Business Central in the customer's currency. Budgets come from Teamwork in the site currency. Do not add them together.

Who it's for

One answer, three teams that use it

Account managers

Prepare for client meetings in one ask

Know what the client owes and how their projects are going before you walk in.

What does Fabrikam owe in Business Central, and how are their Teamwork.com projects doing?

Project directors

Spot projects over budget for clients who owe

The attention list puts budget overruns next to overdue balances, so you can raise both in one conversation.

Give me a client overview for Northwind Traders across Business Central and Teamwork.com.

Finance business partners

Raise overdue balances with context

See whether active work is still going on for a client with an overdue balance before you chase it.

Is Contoso overdue in Business Central while we still have active projects for them in Teamwork.com?

How it works

What PopdockAI does when you ask

You name the client and your AI assistant reads their account from Business Central and their projects from Teamwork.com. You get both sides with an attention list, and nothing is changed.

01

Ask

You name the client.

Your AI tool

02

Read

It finds them in Business Central and reads balance, credit and open invoices.

No items found.

03

Add

It finds the client in Teamwork.com and reads each active project's health and budget.

teamwork-com-get-companies
teamwork-com-get-projects
teamwork-com-get-project-health
teamwork-com-get-budgets

04

Report

You get finance, delivery and an attention list, with nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

teamwork-com-get-companies

Returns client and owner companies from Teamwork.com with contact details and project counts. Filter by country code, industry, company ID, status, city, name and state.
get-data

teamwork-com-get-projects

Returns Teamwork.com projects with status, company, owner, category and dates. Filter by name, member user ID, project ID, start date, category name, end date, company ID, status and company name.
get-data

teamwork-com-get-project-health

Returns the health score of Teamwork.com projects. Filter by health score and project ID.
get-data

teamwork-com-get-budgets

Returns project time and financial budgets from Teamwork.com with their capacity and usage. Filter by capacity, end date, type, project ID, status and start date.
Read only.Nothing in Microsoft Dynamics 365 Business Central 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

Money owed and delivery health in one view

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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