[How to] Setup Auto Bank Account in Vendor/Customer Payment Journal

Dear Dynamics 365 Lovers,

In this blog, I shall articulate about auto setup of Offset account type and Offset account Bank in Payment journal.

Business Scenario

Accountant wants to automate the offset account as Bank and Bank name for Payment journal.

By this process, manual selection of Bank can be avoided.

Solution Approach

1. This is possible by the setup of Bank type and Bank account selection in Method of Payment, by this process, system will auto select the Bank account as per the Method of Payment setup
2. Other possible way is to setup Bank Account in Payment journal itself, it means whenever the Journal is used for payment, Bank will be auto populated.

Let’s explore

Configurations (Solution Approach 1)

This approach is about Method of Payment setup will determine which bank account will be used for the payment automatically.

I have two Bank Accounts (Bank EUR & Bank INR) these will be auto selected upon selection of Vendor/customers in payment journal

I have two Method of Payment selected for the above two bank accounts (MoP EURO for 'BANK EUR' & MoP INR for  'Bank INR')

Now I shall configure the Method of Payment with the bank accounts

Make sure the Journal is set as Default Offset as ‘Bank’

The configurations are done

Operations

Select Payment journal and choose Vendor

DEVEND000000001, this Vendor is expected to auto select “Bank INR” as per the setup

DEVEND000000002- this Vendor is expected to auto select “Bank EUR” as per the setup

See below DEVEND000000002 is auto populated as per the expectation

See below DEVEND000000001 is auto populated as per the expectation

Configurations (Solution Approach 2)

This approach is very simple, the bank account will be auto selected upon creating payment journal

See below setup

Operations

Create the payment journal which one has the setup for auto selection of Bank, see below

And now, we can see, the Bank Account is already auto populated, this was the solution.

 this is it, for more blog stay tuned