BeyondERP.Newsletter
Menu

Setup step on the Cash overview - all companies page · Cash and bank management

Use the Cash overview - all companies workspace

Review forecast inflows, outflows and bank balances for all companies in the system currency.

Used by
Chief executive officer, Chief financial officer, Financial controller
Business process
Analyze cash position in Dynamics 365 Finance
Menu item
LedgerCovEnterpriseWorkspaceEmbeddedReport
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA workspace that shows cash flow forecasts and bank account balances for all companies, in the system currency.
What you do hereUse this workspace to review future cash inflows and outflows and forecasted currency balances across the whole organization.
ExampleFor example, after the forecast calculation and the entity store refresh, BEAT's chief financial officer sees inflows of 2,400,000.00 and outflows of 1,900,000.00 for the next 30 days across all companies in the system currency, and today's actual balance against the forecast for each bank account.
Cash overview - all companies page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Use the Cash overview - all companies workspace

Review forecast inflows, outflows and bank balances for all companies in the system currency.

Steps from Microsoft

  1. Set System currency and System exchange rate on System parameters, and Accounting currency and Exchange rate type on the Ledger page.
  2. Define exchange rates between the transaction, accounting, system and bank currencies on Currency exchange rates.
  3. Run Calculate cash flow forecasts for each company included in the forecast, or schedule it with Cash flow forecast automation.
  4. Go to System administration > Setup > Entity store and refresh the LedgerCovLiquidityMeasurementV2 aggregate measurement.
  5. Go to Cash and bank management > Workspaces > Cash overview - all companies and review inflows and outflows, forecasted currency balances and bank balances.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Inflows and outflowsForecast cash coming in and going out, in the system currency.Microsoft Learn 2,400,000.00 in / 1,900,000.00 out
Forecasted currency balancesThe forecast balance of each currency.Microsoft Learn
Total bank balanceThe total of the bank balances in the system currency.Microsoft Learn
Today's actual vs forecasted balanceEach bank account's actual balance today against the last forecast, in the bank account currency.Microsoft Learn
Balance by legal entityBank balances split by legal entity.Microsoft Learn

Common errors and fixes

MessageWhat to do
The workspace opens but shows no forecast dataRun the cash flow forecast calculation for each company first, then refresh the LedgerCovLiquidityMeasurementV2 aggregate measurement on the Entity store page. Microsoft Learn
Amounts are converted with the wrong currency or rateThe all-companies view uses the System currency and System exchange rate on System parameters; check both and the exchange rates from the accounting currency to the system currency. Microsoft Learn

Test checklist

  1. Run Calculate cash flow forecasts with method Total for the company.
  2. Refresh LedgerCovLiquidityMeasurementV2 on the Entity store page.
  3. Open the workspace and check that inflows and outflows appear for the next periods.
  4. Compare today's actual bank balance with the balance on the Bank management workspace.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Use the Cash overview - all companies workspaceSchedule the forecast calculation with Cash flow forecast automation and refresh LedgerCovLiquidityMeasurementV2 after it, so the workspace is current each morning.The workspace reads the aggregate measurement only; without a fresh calculation and refresh it shows old or no figures.How often should the cash flow forecast and the Cash overview data be refreshed?Expecting new orders and invoices to appear at once. They show only after the next calculation and entity store refresh.Test: Cash overview shows forecast data

Feature management and licence

Licence or add-inIn this system 3 roles can open this page, among them Chief executive officer, Chief financial officer and Financial controller.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyAcross companies: the workspace shows cash flow forecasts and bank balances for all companies in the system currency, set with System currency and System exchange rate on System parameters. Microsoft Learn
Can it be undoneReversible: The workspace changes no data.
If you change it laterThe figures only change after the forecast calculation runs again and the entity store measurement is refreshed. Access is given through the View cash flow all companies workspace duty, by default to the Chief executive officer, Chief financial officer and Financial controller roles. Microsoft Learn
Technical architect

6Technical

Menu itemLedgerCovEnterpriseWorkspaceEmbeddedReport Checked in Dynamics 365
FormPowerBIReportForm Checked in Dynamics 365
Who can open itPrivilegesView cash flow all companies workspace LedgerCovEnterpriseWorkspaceViewDutiesView cash flow all companies workspace LedgerCovEnterpriseWorkspaceView
3 security rolesChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialController
Checked in Dynamics 365
Roles to set it up and use itTo use itChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Page options, Share, Power BIChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=LedgerCovEnterpriseWorkspaceEmbeddedReport
Data migrationLoad order: The Cash overview workspace has no data entity in Data management, so it can't be loaded from a file or a configuration template. It reads the LedgerCovLiquidityMeasurement aggregate measurement, which is rebuilt from the cash flow forecast calculation in each environment.Microsoft Learn
Everyone

8Sources

To cite this step: CB-WS-020, Use the Cash overview - all companies workspace. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-WS-020