BeyondERP.Newsletter
Menu

Setup step on the Bank account transfers page · Cash and bank management

Transfer funds between own bank accounts

Record and post transfers between the company's own bank accounts.

Used by
Treasurer
Business process
Track cash position
Menu item
BankAccountTransfer
Main table
LedgerJournalTable
Data entity
None for this page's own settings
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 journal list page for transfers between the company's own bank accounts, where you create transfer journals and review the ones already posted.
What you do hereUse this journal to record bank transfers through the general journal and review the transfer journals that are already posted.
ExampleFor example, BEAT moves 200,000.00 from its operating account to its payroll account each month: the transfer journal is posted from this page and then shows under Posted, where its lines show both bank accounts.
Bank account transfers 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

Transfer funds between own bank accounts

Record and post transfers between the company's own bank accounts.

Steps from Microsoft

  1. Go to Cash and bank management > Bank accounts > Bank account transfers.
  2. In the Show field, select Posted to see posted transfer journals, or Not posted to see the open ones.
  3. Select New to create a transfer journal with a journal name, then select Lines.
  4. Enter the transfer on the journal lines between the two bank accounts, with the date and the amount.
  5. Validate and post the journal, then select the posted journal and Lines to review it.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
ShowFilters the list, for example to show only posted transfer journals.Microsoft Learn Posted
Journal batch numberThe number of the transfer journal.Checked in Dynamics 365
NameThe journal name that sets the journal's voucher series and defaults.Microsoft Learn
LinesOpens the lines of the selected journal: the bank accounts, date and amount of each transfer.Microsoft Learn

Common errors and fixes

MessageWhat to do
The journal can't be posted to one of the bank accountsA bank account with status Inactive for new transactions or Inactive for all transactions, or past its Active to date, can't take new transactions. Use an active account. Microsoft Learn

Test checklist

  1. Create a transfer journal for 1,000.00 from one bank account to another and post it.
  2. Set Show to Posted and open Lines of the journal.
  3. On Bank transactions, check one transaction of -1,000.00 on the first account and +1,000.00 on the second.
  4. Reconcile both transactions with the next bank statements.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Transfer funds between own bank accountsUse a dedicated journal name for bank transfers, and one line per transfer with the from and to bank accounts, so each side creates its own bank transaction.Each side of the transfer must later match a line on its own bank statement; a dedicated journal name keeps transfers easy to find with Show = Posted.Which journal name should bank transfers use?Posting the transfer to a main account instead of the bank account. No bank transaction is created, so the transfer can't be matched on the bank statement.Test: Transfer creates two bank transactions

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: each legal entity has its own records. Microsoft data model
Can it be undoneOne-way: A posted journal is corrected with a new journal.
If you change it laterPosting creates bank transactions on both accounts and the ledger entries on their main accounts; each transaction must later be matched to the bank statements of both accounts. Microsoft Learn
Technical architect

6Technical

Menu itemBankAccountTransfer Checked in Dynamics 365
FormLedgerJournalTable Checked in Dynamics 365
TableLedgerJournalTableShown as “Ledger journal table” in Record infoKey field: JournalNumChecked in Dynamics 365
Data entitiesBankJournalHeaderEntityBank journal header (Journal headers (LedgerJournalTable) of the bank journals.) Microsoft data model BankJournalLineEntityBank journal line (Journal lines (LedgerJournalTrans) of the bank journals.) Microsoft data model
Who can open itPrivilegesMaintain bank account transfers BankAccountTransferProcessDutiesMaintain bank transactions BankBankTransactionsMaintain
1 security roleTreasurer PaymTreasurer
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itTreasurer PaymTreasurerGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=BankAccountTransfer
Data migrationBankJournalHeaderEntity (Bank journal header): the journal header, loaded first.BankJournalLineEntity (Bank journal line): the lines, after the header.Load order: Open transfers at go-live are usually entered and posted as new journals. When journals are loaded, load the header before the lines.Load first: Bank accounts, Journal namesChecked in Dynamics 365
Table definitionLedgerJournalTable columns and relations Microsoft data model
Everyone

8Sources