D365 Finance and operation

Note : Taken help from Microsoft to understand this functionality

This function is released from version 10.0.36 in order to optimize users’ tasks and process relating to cash and bank management.

In general, with this new feature enabled, users can generate payment journal for vendor/customer from one or multiple bank statement lines in either importing and validating bank statements step or reconciliation step.

In other words, users now have several ways to create payment journal for vendor/customer:

• As previously, go to AP/ AR module > Payment > Vend/Cust payment journal and manually create the journal.

Following this, input for payment journal is inherited from Invoice or manually filled in.

• New experience, go to Cash and bank mgt > Bank statement.

Following this, input for payment journal is inherited from actual bank payment from bank statement.

• New experience, go to Cash and bank mgt > Bank reconciliation.

Following this, input for payment journal is inherited from actual bank payment from bank statement.

Enable feature in Feature Management

In Cash and Bank mgt > Bank accounts > Reconciliation FastTab

• Enable Advanced Bank reconciliation function.
• Fill in journal names used for Customer payment and Vendor payment

• Go to Cash and Bank mgt > Bank  statement Reconciliation > Bank statement and Create a new one.
• Import/fill in bank statement information and Validate.

• Click on Generate payment journal.
• In Generate payment journal form:
  • Payment type: Verify if it is Customer Payment/ Vendor payment.
  • Customer/Vendor account: Choose from the list.
  • Method of payment: Choose from the list.
  • Posting: this button is enabled by default.

The payment journal is forced to post when generating payment to avoid inconsistency issue.

• Date: choose one of the option
  • Booking date: use booking date to post the payment journal.
  • Specific date: apply a date specified by user to all chosen statement lines to post the payment journal.
  • Bank transaction type: Choose from the list.

Click on Journals to open the newly created payment journal

• Go to Cash and Bank mgt > Bank  statement Reconciliation > Bank statement and Create a new one.
• Import bank statement information and Validate.

Go to Cash and Bank mgt > Bank statement Reconciliation > Bank reconciliation and Create a new one.

• If a payment journal is posted from bank statement line, it will be matched automatically in bank reconciliation worksheet
• If a bank statement transaction is found not matched to any payment journal in reconciliation worksheet, payment journal can be generated directly from reconciliation worksheet:
  • Choose the bank statement transaction which is not matched

Click Generate payment journal, fill in Generate payment journal form as in Part 3:

• Infolog message show message that Vendor payment journal has been posted.

In the worksheet > Matched transaction FastTab, the newly created payment journal is matched to bank transaction automatically in reconciliation worksheet after that.

Vendor payment journal:

As the payment journal is posted directly from the action, the transaction has to be settled to invoice after that in Vendor/Customer master page.

• Go to All vendors/Customers > Choose one from the list.
• On Action Panes > Invoice tab > Settle > Settle transactions

In Settle transactions form, mark on transactions to settle and Post.