BeyondERP.Newsletter
Menu

Setup step on the Bank transactions page · Cash and bank management

Review bank transactions

Find posted bank transactions, their vouchers and summarized payments.

Business process
Track cash position
Menu item
BankTrans
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 isAn inquiry page that shows all posted transactions for the selected bank accounts.
What you do hereUse this page to review bank account transactions, including summarized payments, and open their vouchers.
ExampleFor example, BEAT pays three vendors 100.00 EUR each by electronic payment with a journal name that summarizes amounts in the bank account: the inquiry shows one bank transaction of 300.00 with an asterisk in Voucher number and a Bank transaction summarization ID that matches the bank's single debit.
Bank transactions 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

Review bank transactions

Find posted bank transactions, their vouchers and summarized payments.

Steps from Microsoft

  1. Go to Cash and bank management > Inquiries and reports > Bank transactions.
  2. In the query, enter the bank accounts and the date range, then select OK.
  3. Select a transaction and Voucher to see its ledger vouchers, Transaction origin to see where it came from, or Accounting source explorer for the detail.
  4. For a summarized payment (Voucher number shows an asterisk), select View summarized bank transactions to see the payments it includes.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Voucher numberThe voucher of the bank transaction; an asterisk marks a summarized payment that covers several vouchers.Microsoft Learn *
Bank transaction summarization IDThe number that links a summarized bank transaction to the detail payments it includes; from the Bank transaction summarization ID number sequence.Microsoft Learn
Bank accountThe bank account the transaction posted to.Microsoft Learn OPERATING

Common errors and fixes

MessageWhat to do
Payments aren't summarized into one bank transactionCheck the journal name: Summarize amounts in bank account = Yes and New voucher not Manual or One voucher number only; checks and deposit slip payments are never summarized; a number sequence for Bank transaction summarization ID is needed. Microsoft Learn

Test checklist

  1. Post a vendor payment journal with three payments through a journal name with Summarize amounts in bank account = Yes and Default criteria.
  2. Run the inquiry for that bank account and date.
  3. Check one transaction shows an asterisk in Voucher number and a summarization ID.
  4. Select View summarized bank transactions and check the three payments.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review bank transactionsFilter on the bank account and the statement period first, then open Voucher or View summarized bank transactions.Without a bank account and date filter the inquiry lists every bank transaction of the company; summarized payments only make sense against the bank's single line.Should electronic vendor and customer payments be summarized into one bank transaction?Reading an asterisk in Voucher number as a missing voucher. It marks a summarized payment; open View summarized bank transactions.Test: Summarized payment shows as one bank transaction

Number sequences

ReferenceShared or per companyNote
Bank transaction summarization IDNeeded for summarized bank transactions; set on Cash and bank management parameters > Number sequences. Microsoft Learn

Feature management and licence

Feature to turn onAbility to post detailed vendor and customer payments, but summarize amounts to bank account (On by default from 10.0.36)
Licence or add-inIn this system 10 roles can open this page, among them Treasurer, Chief financial officer, Accounting manager and Financial controller.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the inquiry shows the bank transactions of the current legal entity. Microsoft Learn
Can it be undoneReversible: The inquiry changes no data.
If you change it laterThe inquiry reads posted bank transactions. How payments show here depends on the journal name's summarization setting, which also decides whether advanced bank reconciliation can match one bank line to one transaction. Microsoft Learn
Technical architect

6Technical

Menu itemBankTrans Checked in Dynamics 365
FormSysQueryForm Checked in Dynamics 365
Roles to set it up and use itTo use itTreasurer PaymTreasurerChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive people one of these roles. On this system, 10 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=BankTrans
Data migrationLoad order: The Bank transactions inquiry has no data entity in Data management, so it can't be loaded from a file or a configuration template. Bank transactions are created by posting journals; at go-live, post the opening bank balance through a journal to the bank account.Checked in Dynamics 365
Everyone

8Sources