Connectors

/

Microsoft Dynamics 365 Business Central

/

Dynamics 365 Business Central customer brief with Asana work
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Dynamics 365 Business Central customer brief with Asana work
Brief me on Business Central customer C10420 and any Asana work for them.
Contoso owes 22,000, with 6,500 overdue on 2 invoices. - Jobs: 1 open job, J-1042, linked to the Contoso Rollout Asana project - Tasks: 9 open Asana tasks, 2 overdue, owner Jordan Lee - Gap: INV-1042 is 35 days overdue with no follow-up task Want the overdue invoices and open tasks?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
asana-get-tasks
asana-get-project

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

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.

Prompt
**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.

Your AI tool

02

Read

It reads balance, credit limit, overdue invoices, open jobs and comments.

No items found.

03

Match

It finds Asana tasks and projects that mention the customer.

asana-get-tasks
asana-get-project

04

Report

You get money and work side by side, with untracked items flagged.

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

asana-get-tasks

Returns Asana tasks with their assignee, projects, sections, tags, due dates and completion. Filter by assignee, project or due date to find open and overdue work.
get-data

asana-get-project

Returns Asana projects with their owner, team, dates, completion and current status.
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

Fully informed account conversations

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