BeyondERP.Subscribe

Setup page · Cash and bank management

Transaction code mapping

A setup page where you map your bank's statement transaction codes to bank transaction types, for each bank account.

Used by
Chief financial officer, Accountant, Accounting manager and 3 more roles
Business process
Establish matching rules for bank reconciliation in Dynamics 365 Finance
Menu item
BankStatementTransactionTypeMapping
Main table
BankStatementTransactionTypeHeader
Data entity
BankStatementTransactionTypeEntity
Setup steps
1 on this page
Show what matters for

Everyone

1What it is and why

What it isA setup page where you map your bank's statement transaction codes to bank transaction types, for each bank account.
What you do hereUsed so reconciliation matching rules match only the same kinds of transactions between Finance and the bank statement.
Example—
Transaction code mapping page in Dynamics 365
The page in a working Dynamics 365 system. page title tab to open what to set or check

Functional consultant · Solution architect

2Where it fits

Business processDefine accounting policies › Define banking policies › Establish matching rules for bank reconciliation in Dynamics 365 Finance
Menu pathCash and bank management › Setup › Advanced bank reconciliation setup › Transaction code mapping
Set up firstBank transaction types Microsoft Learn ↗
Used next byReconciliation matching rules Microsoft Learn ↗
Related pagesCash and bank management parameters Microsoft Learn ↗

End user · Functional consultant

3How to do it

Step by step, with screenshots

Set up Transaction code mapping1 screen

Used so reconciliation matching rules match only the same kinds of transactions between Finance and the bank statement.

  1. Screen 1

    Map the statement transaction code

    Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Transaction code mapping

    1. Select New and select the Bank account
    2. In the Mappings section, select Add
    3. Enter the Statement transaction code and select the Bank transaction type
    4. Select Save
    1Bank accountBEAT-OPS
    2Statement transaction codeBEAT-FEE
    2Bank transaction typeBEAT-FEE
    Map the statement transaction code (zoomed on the outlined fields)
    Show the full screenMap the statement transaction code
    page title tab to open what to set or check

Microsoft's steps

  1. Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Transaction code mapping.
  2. Select New.
  3. In the Bank account field, select the bank account.
  4. In the Mappings area, select Add, and map a statement code to a bank transaction type.
  5. Repeat the mapping for each bank account.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
Bank accountThe bank account the mapping applies to; each account is mapped separately.Microsoft Learn ↗BEAT-OPS—
MappingsThe pairs of statement codes and bank transaction types.Microsoft Learn ↗——
Statement transaction code—BEAT-FEE—
Bank transaction type—BEAT-FEE—

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision · common mistake · test
Set up Transaction code mapping——

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model ↗
Can it be undone—
Feature or country—
If you change it later—

Technical architect

6Technical

Menu itemBankStatementTransactionTypeMapping Checked in Dynamics 365
FormBankStatementTransactionTypeMapping Checked in Dynamics 365
TableBankStatementTransactionTypeHeaderShown as “Transaction code mapping” in Record infoKey field: BankAccountTableChecked in Dynamics 365
Data entitiesBankStatementTransactionTypeEntityTransaction code mapping Microsoft data model ↗
Who can open itPrivilegesMaintain bank statement transaction type mapping BankStmtTransactionTypeMapMaintainView bank statement transaction type mapping BankStmtTransactionTypeMapViewDutiesInquire into bank account reconciliation status BankBankAcctReconStatusInquireEnable bank management process BankBankManagementProcessEnable
6 security rolesChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerTreasurer PaymTreasurer
Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=BankStatementTransactionTypeMapping
Integrate withBankStatementTransactionTypeEntity data entity Microsoft data model ↗
Table definitionBankStatementTransactionTypeHeader columns and relations Microsoft data model ↗

Everyone

8Sources and checks