Business value

Standard Microsoft Dynamics 365 for Finance and Operations enables users to import bank statements, like CAMT053, BAI2 and MT940 files. But Microsoft Dynamics 365 for Finance and Operations does not help the user to allocate payments to outstanding invoices or assign ledger accounts to statement lines. As a result, after importing a bank statement, allocation is still a time-consuming manual activity.

The main feature of Banking allows the user to let Microsoft Dynamics 365 for Finance and Operations  find and settle payments to invoices and help analyze the user why certain payments can't be settled yet.

Additionally, it enables users to exclude certain vendor transaction form payment proposals and it offers the possibility to send an email showing which invoices are going to be paid when a vendor receives one payment for multiple invoices.  

Features

Banking Overview

Direct Debit Cancellations

Exclude Vendor Transactions

Search Invoices

Split remainder

Validate offset bank account

Generate Payment Specification

Import payment specification

Automatic settlement based on Payment service provider specifications

Search invoices

The field ‘Invoice’ has been added to the grid of the General Journal lines. If a user enters a customer invoice number in this field, Microsoft Dynamics 365 for Finance and Operations will search through all open invoices, using the entered value. If an open invoice is found, the customer and open amount are returned to the grid. This way, the user does not have to try and find the customer themselves. The entered invoice number is put into field ‘Payment note’ allowing for easy reconciliation.

Prerequisite: the journal needs a fixed off-set account of the type Bank

Setup

Activate the ALF license

This will enable the Banking functionalities

Data entities

New entities

In order to be able to export and import data related to this module the following data entities have been added/modified.

Modified entities