Connectors

/

Microsoft Dynamics 365 Business Central

/

Dynamics 365 Business Central collections worklist
Report

Start each day knowing which overdue customers to chase first

For collections teams who want overdue Business Central customers ranked by risk with a next action, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Dynamics 365 Business Central collections worklist
Build me a collections worklist from Business Central for invoices more than 30 days overdue.
38 customers have invoices over 30 days overdue, 214,000 USD in total. - 1. Fabrikam: 42,000, oldest 96 days, no payment in 90 days, call - 2. Contoso: 28,500, reminder level 2, send the next reminder - 3. Northwind Traders: 19,000, unapplied credit of 15,000, apply it Want the full ranked worklist with contact details?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
No items found.

On this page

The problem

The problem

The prompt

Who it's for

How it works

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

Collections calls start with whoever is easiest, not who matters

Chasing overdue customers works best when you start with the oldest, largest debts, but Business Central shows invoices one at a time. Deciding who to call means aging every invoice, checking reminders and payments and spotting credits that offset the debt.

Without PopdockAI

  • Age open invoices by hand per customer
  • Check reminders and last payments one by one
  • Miss credits that already cover the debt
  • Call whoever comes to mind first

With PopdockAI

  • Open invoices are aged into four buckets per customer
  • The top 15 get reminders, finance charges, last payment and credits
  • Customers are ranked by oldest debt and payment history
  • The top five get a next action, 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:** Build a collections worklist of overdue customer invoices, ranked by who to chase first, counting only invoices at least `{min-days-overdue}` days overdue (default 1).

Pass `{company}` as the company argument on every call. If `{company}` is empty, leave the company argument out so the connector's default company is used.

**Step 1: Pull open invoices**

Call `business-central-get-posted-sales-invoice` with remaining-amount.min set to 0.01 and due-date.to set to today minus `{min-days-overdue}` days (default 1). Raise max-records to 1000. If the result hits the limit, say the list may be incomplete.

**Step 2: Age them**

Group by sell-to-customer-number. For each customer total remaining-amount into buckets by days past due-date: 1-30, 31-60, 61-90, over 90.

**Step 3: Add context for the top customers**

For the 15 customers with the largest overdue total:

* Call `business-central-get-customer` with customer-number to get credit-limit, blocked, phone-number, email and salesperson-code.
* Call `business-central-get-reminder` and `business-central-get-issued-finance-charge-memo` with customer-number to see the highest reminder-level and any finance charges.
* Call `business-central-get-detailed-customer-ledger` with customer-number, document-type Payment and posting-date.from 90 days ago to find the last payment date.
* Call `business-central-get-posted-sales-credit-memo` with sell-to-customer-number and paid false; an unapplied credit may offset the debt.

**Step 4: Rank**

Rank by amount over 90 days first, then 61-90, then total overdue. Move a customer up if they have made no payment in 90 days, and down if an unapplied credit covers most of the debt.

**Step 5: Report**

* Aging summary: total per bucket across all customers
* Worklist table: rank, customer, total overdue, the four buckets, last payment date, highest reminder level, unapplied credit, contact email and phone
* For the top five, one line each saying the suggested next action (call, send next reminder, apply credit, consider credit hold)

**Rules & Guidelines:**

* This prompt is read-only. Do not call any tool named business-central-create-* or business-central-update-*. Do not block customers with `business-central-update-customer`; recommend it instead.
* Do not mix currencies in a total; show a separate total per currency-code if more than one appears.

**Validation:**

* If nothing is overdue, say so and stop.

Who it's for

One answer, three teams that use it

Collections specialists

Know who to call first today

Start the day with a ranked list and a suggested next action for the top five, instead of building it yourself.

Build a Business Central collections worklist for invoices more than 15 days overdue.

Credit managers

Focus on debts most likely to go bad

Customers with no payment in 90 days move up the list, and those covered by credits move down.

Who should we chase first in Business Central for debts over 60 days?

Finance managers

See the aging picture at a glance

An aging summary by bucket shows how overdue receivables are trending.

Give me the overdue aging summary and top collections priorities from Business Central.

How it works

What PopdockAI does when you ask

You set a minimum days overdue and your AI assistant ages and ranks your Business Central customers. Currencies are never mixed, and no customer is blocked or changed.

01

Ask

You set a minimum days overdue, one by default.

Your AI tool

02

Age

It reads open invoices and ages them into four buckets per customer.

No items found.

03

Rank

It adds reminders, last payments and credits for the top 15 and ranks them.

No items found.

04

Report

You get an aging summary, the worklist and next actions for the top five.

Your AI tool

The outcome

A ranked worklist to start every collections day

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