/
/
See what a customer owes and the work in flight for them
For account teams who want Business Central money and Asana work side by side before a customer call, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.
The problem
What a customer owes and what you are doing for them never meet
Before a customer call you want what they owe and how late from Business Central, and the work in flight for them in Asana. Gathering that means visiting several screens in two systems.
Without PopdockAI
- Look up balance, limit and overdue invoices
- Check open jobs and comments
- Search Asana for tasks that mention the customer
- Miss an overdue invoice nobody is following up
With PopdockAI
- Balance, credit limit, overdue invoices and open jobs are read
- Asana tasks and projects that mention the customer are found
- Overdue invoices with no task and jobs with no project are flagged
- Short or common names are narrowed, 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:** Give an account brief for Business Central customer `{customer-number}`: money and commercial status from Business Central, and the related work in Asana. Read only.
**Step 1: Read the customer in Business Central**
Call `business-central-get-customer` with `customer-number` set to `{customer-number}` and `company` set to `{company}` if given. If nothing comes back, say so and stop. Keep `name`, `balance`, `balance-due`, `credit-limit`, `salesperson-code`, `payment-terms-code` and `blocked`.
**Step 2: Read the customer's open items**
* `business-central-get-posted-sales-invoice` with `sell-to-customer-number` set to `{customer-number}` and `remaining-amount.min` set to 0.01. Mark each invoice overdue if its `due-date` is before today, with days overdue.
* `business-central-get-job` with `bill-to-customer-number` set to `{customer-number}`. Keep open jobs.
* `business-central-get-customer-comment` with `customer-number` set to `{customer-number}`. Keep the five most recent.
**Step 3: Find related work in Asana**
Call `asana-get-tasks` with `name.contains` set to the customer name and `completed` false. Then, for each open job from Step 2, call `asana-get-project` with `name.contains` set to the job number. If the customer name is shorter than 4 characters or is a common word, say the task search may be noisy and show only tasks whose name also contains the customer number or an invoice or job number.
**Step 4: Report**
* Header: customer name and number, salesperson, payment terms, blocked status.
* Money: balance, balance due, credit limit and headroom, and the overdue invoices (number, due date, days overdue, remaining amount).
* Work: open jobs with their Asana project and status if found, and open Asana tasks that mention the customer, with assignee and due date.
* Notes: the recent comments.
* Attention: overdue invoices with no Asana task mentioning their invoice number, and open jobs with no Asana project.
**Rules & Guidelines:**
* `business-central-get-customer`, `business-central-get-posted-sales-invoice`, `business-central-get-job` and `business-central-get-customer-comment` are on the business-central server; `asana-get-tasks` and `asana-get-project` are on the asana server.
* Read only. Do not call `asana-create-task`, `asana-create-comment` or any other asana create or update tool, and do not call `business-central-update-customer` or any other business-central create or update tool.
**Validation:**
* If Asana returns nothing, report the Business Central half and say no Asana work mentions this customer.
* Show amounts in the customer's currency as Business Central returns them; do not convert.Who it's for
One answer, three teams that use it
Account managers
See money and work side by side
One brief shows what the customer owes and what is in flight for them, before you pick up the phone.
Brief me on Business Central customer C20115 and their Asana work.
Collections leads
Find overdue invoices nobody is chasing
Overdue invoices with no follow up task are flagged first, so each one gets an owner.
Which overdue invoices for Fabrikam in Business Central have no follow up task in Asana?
Project managers
Spot jobs with no project plan
Open Business Central jobs with no Asana project are highlighted so delivery work is set up.
Does Northwind Traders have open jobs in Business Central with no Asana project?
How it works
What PopdockAI does when you ask
You give a customer number and your AI assistant reads the account from Business Central and related work from Asana. It only reads both systems.
01
Ask
You give a Business Central customer number.
02
Read
It reads balance, credit limit, overdue invoices, open jobs and comments.
03
Match
It finds Asana tasks and projects that mention the customer.
04
Report
You get money and work side by side, with untracked items flagged.
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.
asana-get-tasks
asana-get-project
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
Fully informed account conversations
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)
