Dynamics Community Forum Thread Details

Cash Flow forecast

Hi! Guys,
I have been trying to work with Cash Flow Forecast for quite a few days. Basically, Forecast is like to predict the future based on the historical data.

I have Created a forecast. Linked the GL Budget with the forecast. Registered the Worksheet lines.

	Mar-26	Mar-26	April-26	April-26	May-26	Jun-26	Jul-26
	Forecast	Actual	Forecast	Actual	Forecast	Forecast	Forecast

Recieveables	$ 370,370	$ 566,696	$ 374,519	$ 476,824	$ 361,380	$ 422,849	$ 903,365

This excel report makes some sense. But in the CF by Period, BC displays amount based on the Due date of the transaction.

Along with that Azure AI is Enabled for the forecast but the Azure AI Values are not getting displayed in the Role center chart.

If there is a better way for cash flow forecast or if I have missed something, do tell me.
I would really appreciate your opinions.

Thanks.

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

Hello,

BC cash flow is not really “Excel-style forecast from actuals”; it is more of a cash timing forecast, so yes, Receivables/Payables are shown mainly by Due Date, because BC is trying to predict when cash is expected to move, not when revenue/expense was posted. Your GL Budget link is good for planned/budgeted cash items, but open invoices, orders, manual revenues/expenses, taxes, etc. also feed the forecast, then worksheet lines must be suggested/registered and the Role Center chart must be Recalculate Forecast. For Azure AI, it does not simply show a separate “AI value” everywhere; it uses historical receivables, payables, and tax data, grouped by the Period Type, and if there is not enough history or the values vary too much, Microsoft says it may not generate a prediction. So I’d check Cash Flow Setup → Azure AI enabled, Historical Periods, Period Type, then recalculate; if you need a management forecast like your Excel layout, keep using budgets/manual cash flow lines for planned values and treat BC’s CF by Period as due-date cash movement, not P&L forecasting.

Regards,
Oussama Sabbouh

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS