Connectors

/

Microsoft Dynamics 365 Business Central

/

Dynamics 365 Business Central cash position forecast
Report

See cash shortfalls weeks before they happen

For finance teams who want a week by week cash forecast from Business Central balances, receivables and payables, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Dynamics 365 Business Central cash position forecast
What does our cash position look like over the next 4 weeks in Business Central?
Cash stays positive for 4 weeks, but drops under the minimum in week 3. - Opening cash: 412,000 USD - Week 3: closing cash 88,000 against a 100,000 minimum - Overdue receivables: 64,000 shown apart, not counted - Open orders: 120,000 as indicative pipeline This is a due-date forecast. Want the week by week table?
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

Overdue receivables make the cash picture look better than it is

Knowing whether you will have enough cash means adding bank balances to customer invoices due and subtracting vendor invoices due, week by week. From Business Central screens it is slow, and overdue receivables make it look rosier than it is.

Without PopdockAI

  • Pull bank balances, receivables and payables
  • Bucket each invoice into weeks in a spreadsheet
  • Count overdue receivables as cash this week
  • Find the shortfall when it arrives

With PopdockAI

  • Bank balances and invoices due are read per currency
  • Overdue receivables are shown apart, not counted as cash
  • Overdue payables count as due now
  • The first week under minimum balances is called out, 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:** Project the cash position for the next `{weeks}` weeks (default 4), week by week, from bank balances, receivables due and payables due.

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: Opening cash**

Call `business-central-get-bank-account` with blocked false. Sum balance per currency-code. Note any account below minimum-balance.

**Step 2: Expected receipts**

Call `business-central-get-posted-sales-invoice` with remaining-amount.min 0.01 and due-date.to set to the end of the window. Raise max-records to 1000. Put already overdue invoices in a separate "overdue, timing uncertain" line rather than week 1.

**Step 3: Expected payments**

Call `business-central-get-posted-purchase-invoice` with closed false and due-date.to set to the end of the window. Treat overdue payables as due in week 1.

**Step 4: Open orders (indicative)**

Call `business-central-get-purchase-transaction` with document-type Order and read total-outstanding-amount and expected-receipt-date; call `business-central-get-sales-transaction` with document-type Order and read total-outstanding-amount and requested-delivery-date. Show these as indicative only, since they are not invoiced yet.

**Step 5: Report**

* A table per currency: week start, opening cash, receipts due, payments due, closing cash
* Overdue receivables shown separately, not counted in the weeks
* The indicative order pipeline under the table
* The first week in which closing cash drops below the total minimum-balance, if any

**Rules & Guidelines:**

* This prompt is read-only. Do not call any tool named business-central-create-* or business-central-update-*.
* This is a due-date forecast, not a prediction of customer behaviour. Say so in one line.

**Validation:**

* If there are no bank accounts, report receipts and payments only and say opening cash is unknown.

Who it's for

One answer, three teams that use it

Treasury and cash managers

Plan around a realistic cash view

See cash week by week per currency, with overdue receivables kept separate, so you plan on money you can count on.

Forecast our cash position in Business Central for the next 6 weeks.

CFOs

Know the first week cash runs short

The first week cash falls under minimum balances is called out, giving you time to act.

When does cash first drop below our minimum balances in Business Central over the next 8 weeks?

Accounts payable managers

Time payments against cash in

Payables and receivables due by week help you decide what to pay when.

Show me payables and receivables due by week in Business Central for the next month.

How it works

What PopdockAI does when you ask

You choose how far to look ahead and your AI assistant builds a due date cash forecast from Business Central. It keeps overdue receivables out of the numbers you rely on and changes nothing.

01

Ask

You choose how many weeks to look ahead, four by default.

Your AI tool

02

Read

It reads bank balances, customer invoices due and vendor invoices due.

No items found.

03

Project

It builds weeks per currency, showing overdue receivables apart.

No items found.

04

Report

You get the forecast table and the first week cash drops under minimums.

Your AI tool

The outcome

Cash shortfalls seen weeks ahead

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