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 Accounts Table
    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
c
c
o
u
n
t

T
y
p
e

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

  • Items with the red text indicate the originating entity is from the transaction header
  • Items with the green text indicate the originating entity from the first bank account
  • Items with the orange text indicate the originating entity is from the bank account (single line) or transaction header (multiple lines)

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: 

  1. Select the Entity Code for the record.
  2. 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 icon. 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: 

  1. Select Actions > MEM Assign Entity Security.
  2. On the MEM Master Security page, check that the Direction, Master Records, and corresponding record field are updated with the values you want.
  3. These fields are automatically updated based on the selected record and cannot be changed.

  4. In the Destination Lines, select one or more entities for the relationship.
  5. 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.

  6. Close the MEM Master Security page to return to the card page for 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: 

  • Direction is set to Master
  • Master Records is set to Bank Account
  • Bank Account is set to the record on this page
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.