Dynamics Community Forum Thread Details

Cash Flow Forecasting

Hi guys,

I’ve been configuring cash flow forecasting in sandbox and I can’t see any reason why isn’t working.

I’ve configured All Liquidity accounts for the forecast. Then created the Cash flow forecast automation and initialized the process for new and total.

To finalize, I’ve refreshed the LedgerCovLiquidityMeasurementV2 on the entity store and run the batch job ‘full reset’ to enable the power bi reports.

In my perspective this would be enough to show up some data on the reports but i’m still unable to see it. What am I missing?

Categories:

Dynamics 365 Finance

Hi ,

The following setup needs to be completed in order for data to display in Cash overview and Bank management Power BI visuals.

Go to System administration > Setup > System Parameters to set System currency and System Exchange Rate.
Go to General Ledger > Calendars > Fiscal calendars to validate fiscal calendar dates assigned to the active time period.
Go to General Ledger > Setup > Ledger to set Accounting Currency and Exchange Rate Type.
Define exchange rates between transaction currencies and accounting currency, accounting currency and system currency, and accounting currency and bank currencies. To do this, go General Ledger > Currencies > Currency exchange rates.
Configure and run Cash Flow Forecasting. For more information about how to set up Cash flow forecasting, see Cash flow forecasting.
Go to System administration > Setup > Entity Store to refresh the LedgerCovLiquidityMeasurement aggregate measurement.

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL