Insight AX
Back to Featured Insights

Troubleshooting LedgerCovLiquidityMeasurement Cube in Power BI Embedded on Dynamics 365 Finance and Operations

4 November 20241 min read
Dynamics 365 Finance & OperationsD365Power BICash Flow ForecastingEntity StoreBank Management

If transactions exist in the days without data, the following setup needs to be completed in order for data to display in Cash overview and Bank management Power BI visuals.

  1. Go to System administration > Setup > System Parameters to set System currency and System Exchange Rate.

  2. Go to General Ledger > Calendars > Fiscal calendars to validate fiscal calendar dates assigned to the active time period.

  3. Go to General Ledger > Setup > Ledger to set Accounting Currency and Exchange Rate Type.

  4. Define exchange rates between transaction currencies and accounting currency, accounting currency and system currency, and accounting currency and bank currencies. To do this, go to General Ledger > Currencies > Currency exchange rates.

  5. Configure and run Cash Flow Forecasting. For more information about how to set up Cash flow forecasting, see Cash flow forecasting.

  6. Go to System administration > Setup > Entity Store to refresh the LedgerCovLiquidityMeasurement aggregate measurement.