BeyondERP.Newsletter
Menu

Setup step on the Add reporting currency amounts to bank account transactions page · Cash and bank management

Add reporting currency amounts after an upgrade

Fill reporting currency amounts on bank transactions posted before the upgrade.

Business process
Track cash position
Menu item
action:BankAccountTransReportingCurrencyAmountsWizard
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 wizard that adds reporting currency amounts to bank account transactions that were posted before an upgrade.
What you do hereUse this page to copy reporting currency amounts from the general ledger into the bank transaction records without posting again.
ExampleFor example, after BEAT's upgrade brings in dual currency with EUR as reporting currency, the wizard lists 1,540 bank transactions posted before the upgrade with a reporting currency amount of 0.00 and proposes each amount from its general ledger entry; three with no ledger amount show 0.00 and are entered by hand.
Functional consultant · Solution architect

2Where it fits

Business processManage cash › Track cash position
Menu pathCash and bank management › Setup › Add reporting currency amounts to bank account transactions
Set up firstLedger (reporting currency) Microsoft Learn
Used next byBank account balance report Microsoft Learn Bank to ledger reconciliation report Microsoft Learn
Related pagesBank accounts Microsoft Learn
In this process Review bank transactions · Use Balance control before payment runs
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.

When to run it

When to run itOnce after an upgrade that brings in dual currency, before you rely on reporting currency amounts in Cash and bank management.
How oftenOne time per company after the upgrade; run it again only to fix incorrect amounts.
What the output showsReporting currency amounts filled in on bank account transactions posted before the upgrade. Nothing is posted to the general ledger. A bank balance that doesn't reconcile in the reporting currency usually means a suggested amount was edited.

Source: Microsoft Learn

Setup steps on this page

Add reporting currency amounts after an upgrade

Fill reporting currency amounts on bank transactions posted before the upgrade.

Steps from Microsoft

  1. Go to Cash and bank management > Setup > Add reporting currency amounts to bank account transactions.
  2. Review the listed bank account transactions: the wizard shows those in the current company that were posted before the upgrade and have a reporting currency amount of zero.
  3. Keep the default amounts, which come from the matching general ledger entries. Change an amount only when it shows zero because no ledger amount was found.
  4. Select Finish to write the amounts to the bank transactions, or Cancel to keep your edits for the next run without updating the transactions.
  5. Afterwards, compare bank balances with the ledger in the reporting currency on the bank reports.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Bank account transactionA bank transaction posted before the upgrade whose reporting currency amount is 0.Microsoft Learn
Reporting currency amountProposed from the matching general ledger entries; change it only when it shows 0 because no ledger amount was found.Microsoft Learn 0.00

Common errors and fixes

MessageWhat to do
Bank balances in the reporting currency no longer agree with the ledgerThe proposed amounts were edited. Run the wizard again and keep the amounts taken from the general ledger. Microsoft Learn

Test checklist

  1. No bank transactions posted before the upgrade are left with a zero reporting currency amount.
  2. Bank balances in the reporting currency agree with the bank main accounts in the ledger.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Add reporting currency amounts after an upgradeRun it once per company after the upgrade, keep the proposed amounts and select Finish.The amounts come from the general ledger, so keeping them keeps bank balances reconciled to the ledger in the reporting currency.Should any proposed amount be changed?Editing proposed amounts. The bank balances in the reporting currency then can't be reconciled to the general ledger.Test: Reporting currency amounts are filled

Feature management and licence

Licence or add-inIn this system 1 role can open this page, among them Treasurer.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the wizard shows the bank transactions of the current company. Microsoft Learn
Can it be undoneReversible: The wizard can be run again to fix amounts; it doesn't post.
If you change it laterUpdates reporting currency amounts in the bank subledger only, without posting to the ledger. Editing the suggested amounts can stop bank account balances from reconciling to the general ledger. Microsoft Learn
Technical architect

6Technical

Menu itemaction:BankAccountTransReportingCurrencyAmountsWizard
Roles to set it up and use itTo use itTreasurer PaymTreasurerGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=action:BankAccountTransReportingCurrencyAmountsWizard
Data migrationLoad order: The reporting currency wizard has no data entity in Data management, so it can't be loaded from a file or a configuration template. It updates bank transactions already in the environment from the general ledger; run it in each company after the upgrade.Microsoft Learn
Everyone

8Sources

To cite this step: CB-JOB-120, Add reporting currency amounts after an upgrade. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-JOB-120