In this article
Bank Account
Use this page to set up bank accounts. For more information, see the Microsoft Dynamics 365 Business Central documentation.
Concepts
When journal transactions are posted, the entities used in the transactions are based on the following information:
- The entity for the transaction is specified in the Entity Code of the Journal page.
The following table indicates to which entity the accounts belong for different combinations of the Account Type and Balance Account. This information applies to the following journal transactions: general, purchase, sales, cash receipts, fixed asset G/L, and payment.
Balance Account | ||||||||
G/L Account | Bank Account Posting Group | Customer (No Apply Entries ) | Customer (Apply Entries ) | Vendor (No Apply Entries ) | Vendor (Apply Entries ) | Bank Account | ||
A
T
|
G/L Account | Both - Line | Both - Line |
AR - Header GL - Line |
AR - Invoice Header GL - Line |
AP - Header GL - Line |
AP - Invoice Header GL - Line |
Bank - Setup GL - Line>/span> |
Bank Account Posting Group | Both - Line | Both - Line |
AR - Line BAPG - Header |
AR - Invoice Header BAPG - Header |
AP - Line BAPG - Header |
AP - Invoice Header BAPG - Header |
Bank - Setup BAPG - Line |
|
Customer (No Apply) |
AR - Header GL - Line |
AR - Line BAPG - Header |
N/A | N/A | N/A | N/A |
AR - Line Bank - Setup |
|
Customer (Apply) |
AR - Invoice Header GL - Line |
AR - Invoice Header BAPG - Header |
N/A | N/A | N/A | N/A |
AR - Invoice Header Bank - Setup |
|
Vendor (No Apply) |
AP - Header GL - Line |
AP - Line BAPG - Header |
N/A | N/A | N/A | N/A |
AP - Line Bank - Setup |
|
Vendor (Apply) |
AP - Invoice Header GL - Line |
AP - Invoice Header BAPG - Header |
N/A | N/A | N/A | N/A |
AP - Invoice Header Bank - Setup |
|
Bank Account |
Bank - Setup or Header GL - Line |
Bank - Setup or Header BAPG - Line |
AR - Line Bank - Setup |
AR - Invoice Header Bank - Setup |
AP - Line Bank - Setup |
AP - Invoice Header Bank - Setup |
Both - Setup |
|
|
When discounts are applied to payment or cash receipt journal transactions, the following table indicates to which entity the accounts belong for different options for applying the discount:
Payment Journal | Cash Receipt Journal | ||||||
Accounts Payable | Bank | Discount | Accounts Receivable | Bank | Discount | ||
Entity | Discount to Invoice Entity | Belongs to the entity specified for the line. | Belongs to the entity specified on the Bank Account page, or if no account is specified on the setup, then the bank account belongs to the entity specified in the header. | Belongs to the entity of the line. | Belongs to the entity of the line. | Belongs to the entity specified on the Bank Account page, or if no account is specified on the setup, then the bank account belongs to the entity specified in the header. | Belongs to the entity of the line. |
Discount not to Invoice Entity | Belongs to the entity of the line. | Belongs to the entity specified on the Bank Account page, or if no account is specified on the setup, then the bank account belongs to the entity specified in the header. | Belongs to the entity of the header. | Belongs to the entity of the line. | Belongs to the entity specified on the Bank Account page, or if no account is specified on the setup, then the bank account belongs to the entity specified in the header. | Belongs to the entity specified on the Bank Account page, or if no account is specified on the setup, then the bank account belongs to the entity specified in the header. |
Bank Account Reports
The MEM versions of the various bank reports are copies of the Microsoft Dynamics 365 Business Central reports.
The following reports are available from the Report menu:
- Bank Accounts - Detail Trial Balance
- Trial Balance by Periods
- Bank Account - List
These other bank reports are available by selecting More options > Reports:
- Check Details
- Receivable – payable
- Trial Balance
- Projected Cash Receipts
- Projected Cash Payment
- Cash Requirement. By date
- Bank Account – reconcile
- Bank Account State
With the Entity Filter, you can select a range of entities or specific entities to appear on the report.
Based on the security settings on the Multi-Entity Management Setup page, the generated report(s) shows only the records that belong to entities to which you have access and match the other criteria that you specified. MEM security settings can restrict the visibility and access to the following types of records based on the entities to which you have access: bank account, customer, fixed asset, item, location, and vendor.
- When the Entity Filter contains specific entities, the report shows only the records for the specified entities.
- When the Entity Filter contains a range of entities, the report shows only the records within the specified entity range.
- When the Entity Filter is empty, the report shows all records that belong to entities to which you have access.
Assign the Owner Entity to a Bank Account
To assign the owner entity to a bank account, follow the steps in the Microsoft Dynamics 365 Business Central documentation to create or edit a bank account and incorporate the following step:
- Select the Entity Code for the record.
-
After the entity is assigned, MEM security is applied to the record. Access to the record is based on user-entity permission. When you assign the entity to the record, the change is reflected on the MEM Master Security page.
Tip: If you have several records that are not assigned to entities, use the MEM Master Security page.
Note: If you change the owner entity for a record, the new entity has access to the record. However, the previous entity access is remains on the MEM Master Security page.
Assign Entity Security to a Bank Account
To assign entity security to a bank account record, follow the steps in the Microsoft Dynamics 365 Business Central documentation for creating or editing a bank account record, and incorporate the following steps:
- Select Actions > MEM Assign Entity Security.
- On the MEM Master Security page, check that the Direction, Master Records, and corresponding record field are updated with the values you want.
- In the Destination Lines, select one or more entities for the relationship.
- Close the MEM Master Security page to return to the card page for the record.
These fields are automatically updated based on the selected record and cannot be changed.
For new records, your default entity or the first entity (if no default entity is selected) in the list is automatically assigned to the record.
Bank Account List Fields
This list contains the following MEM columns:
Field | Description |
Entity Code |
Displays the owner entity assigned to the record. |
Bank Account Card Fields
This page contains the following fields:
Field | Description |
Entity Code |
Select the owner entity for the record. You can select any entity, even the entities to which you do not have access. The default value is your default entity that you selected in My Settings. If you did not set up the default entity, this field is blank. |
Actions
This page contains the following buttons:
Button | Description |
MEM Assign Entity Security |
Opens the MEM Master Security page where you assign entities to the record. When you select this action, the following header fields on the MEM Master Security are automatically updated as follows and cannot be changed:
|
Related > Bank Acc. |
Open one of the following pages to assign bank accounts. |
Actions > IC Suite > Synchronize | Select this action to perform the synchronization for included partners and bank accounts. |