/
/
Tell project teams when a client's Business Central balance is overdue
For finance and delivery leads who want an overdue Dynamics 365 Business Central balance posted to the client's Teamwork.com projects by their AI assistant.
On this page
Connector
Connect Teamwork.com, pick your AI tool and paste the prompt.
The problem
Project teams keep working while the client stops paying
When a client falls behind in Dynamics 365 Business Central, the Teamwork.com project team usually keeps working without knowing. Telling them means checking overdue invoices, finding active projects and posting a careful note on each.
Without PopdockAI
- Check overdue invoices in Business Central
- Find the client's active projects in Teamwork.com
- Write a careful message for each project
- Post it, and risk messaging the wrong client
With PopdockAI
- Overdue invoices are found, and nothing is posted if there are none
- The Teamwork.com company is matched, stopping rather than guessing
- You see the invoices, projects and exact message first
- At most one message per project is posted, with failures reported
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Check whether client `{customer-name}` has invoices in Business Central company `{company}` (default: the default company) that are more than `{days-overdue}` days overdue (default 30). If they do, and the user confirms, post one message about it on each of the client's active Teamwork projects.
**Step 1: Find the overdue invoices**
Call `business-central-get-customer` (Business Central server) with `name.contains` set to `{customer-name}`, and `company` set to `{company}` when given. If more than one customer matches, list them and ask which one is meant.
Call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` set to the customer-number, `remaining-amount.min` set to 0.01, and `due-date.to` set to today minus `{days-overdue}` days (30 when blank), as YYYY-MM-DD. If nothing comes back, report that the client has nothing that overdue and stop. Do not post anything.
**Step 2: Find the active projects**
Call `teamwork-get-companies` (Teamwork server) with `name.contains` set to `{customer-name}`, and choose the company whose name matches the customer. Then call `teamwork-get-projects` with its `company-id`, and keep the projects whose status is active. If there are none, report the overdue invoices and stop.
**Step 3: Confirm**
Show the user the overdue invoices (invoice-number, due-date, remaining-amount, days overdue), the projects that would get a message, and the exact message text. The message should have the title "Client account overdue" and a body that states the number of overdue invoices, the total remaining amount and the oldest due date. It must not include internal credit terms. Ask the user to confirm. If they do not clearly say yes, stop without posting.
**Step 4: Post and confirm**
After the user confirms, call `teamwork-create-message` once per project, with `project-id`, `title` and `body`. Leave `notify` blank unless the user named people to notify. Report each project with the message id returned, and any project where the call failed.
**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` and `teamwork-create-message` are on the Teamwork server.
* `teamwork-create-message` is the only tool that may write, and only after the user confirms in Step 3. Do NOT call `teamwork-update-project`, `teamwork-create-comment`, `teamwork-create-task`, or any `business-central-create-*` or `business-central-update-*` tool.
* Post at most one message per project per run.
**Validation:**
* If the Teamwork company cannot be matched with confidence, list the candidates and stop rather than messaging the wrong client's projects.
* If `teamwork-create-message` fails for a project, report the error and carry on with the rest. Do not retry the same project.Who it's for
One answer, three teams that use it
Credit controllers
Let delivery know a client is overdue
Tell the people doing the work that payment is late, in the tool they use, with the wording approved by you.
Tell Fabrikam's Teamwork.com project teams if they have Business Central invoices over 60 days overdue.
Finance managers
Keep the message consistent and careful
One approved message goes to each project, leaving out credit terms, so every team hears the same thing.
Post a note on Northwind Traders' active Teamwork.com projects about invoices past 45 days in Business Central.
Account managers
Raise overdue accounts with the team
Warn the project team before they commit more work, so the next client conversation covers payment as well as delivery.
Let the Contoso project teams know if anything in Business Central is more than 30 days late, but show me the message first.
How it works
What PopdockAI does when you ask
You name the client and how many days overdue counts, and your AI assistant prepares a message for each active project. Nothing is posted until you approve it.
01
Ask
You name the client and how many days overdue counts.
02
Check
It finds overdue invoices in Business Central, stopping if there are none.
03
Match
It matches the Teamwork.com company and finds active projects.
04
Confirm
You approve the message, then it posts once per project.
What PopdockAI provides
The tools behind the answer
Ready made tools for Teamwork.com and one secure connection to your AI tool. No code, no exports.
teamwork-com-get-companies
teamwork-com-get-projects
teamwork-com-create-message
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 approved message per project, while it still matters
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)
