A Comprehensive Overview of the Financial Transaction Settlement Process in Microsoft Dynamics 365 Finance

Posted on: June 28, 2023 | By: Guy Logan | Microsoft Dynamics AX/365, Microsoft Dynamics Manufacturing

Settlement is a crucial aspect of financial transactions that impacts both Accounts Payable and Accounts Receivable processes. Whether it’s reconciling payments with invoices, resolving outstanding balances, or generating new transactions, understanding the settlement process is essential for maintaining accurate financial records and ensuring smooth business operations. In this blog, we will delve into the fundamentals of settlement, including the types of transactions that can be settled, when and how settlements take place, and finally the results of the settlement process.

What transactions can be settled

In Accounts payable and Accounts receivable, settlement can occur between any transaction types that affect the vendor balance or customer balance. These transaction types can include invoices, payments, credit memos, and fees. Any transaction type can be settled against any other transaction type. For example, you can settle a payment against an invoice, a credit memo against an invoice, an invoice against another invoice, and a payment against another payment.

You can settle payments against a transaction in the same legal entity or in a different legal entity. In organizations that use a centralized payment model, centralized payments can help streamline the payment process.

When to settle transactions

Transactions can be settled when payments are entered. For example, when you make a payment to a vendor, you typically select which invoices to pay. By selecting invoices, you mark them for settlement against the payment. When Accounts receivable payment clerks record customer payments, they can mark the appropriate invoices for settlement, based on the information that is included with each customer’s payment. You use the Settle transactions page to mark transactions for settlement. You can open this page from any unposted invoice or payment. When the transaction is posted, the settlement is also posted.

Transactions can also be settled after they are posted. You can enter and post a customer payment without settling it against any invoices. However, you might want to make sure that the payment is settled against the correct invoice before you post the settlement. The Settle transactions page can be opened from the All customers or All vendors page, or from the Transactions page for any customer or vendor.

You can also reserve posted prepayments for an invoice by marking the payment for settlement against a purchase order or sales order. In this case, the payment will still have an open balance, but it can’t be settled against another invoice. The payment will be automatically settled against the invoice that is created from the purchase order or sales order.

How to settle transactions

Transactions can be settled manually, automatically, or by using a combination of the two methods. The choice of a settlement method depends on your business processes. On the Accounts payable parameters and Accounts receivable parameters pages, you can configure the settlement process so that it’s aligned with those business processes.

You can create vendor payments and customer direct debit payments by using a payment proposal. A payment proposal is used to select invoices to pay. The payment proposal is started manually, and then the system automatically marks the selected invoices for settlement when the payments are created.

If payments are created manually, you can use the Settle transactions page to select invoices for settlement. You can manually select the invoices, or you can use the Mark by priority option to have invoices automatically marked for settlement. The Mark by priority option is available only for Accounts receivable. You can turn on this option on the Settlement priority tab of the Accounts receivable parameters page.

If a payment clerk enters a payment but doesn’t settle that payment before it’s posted, the payment can be automatically settled. You can turn on automatic settlement on the Accounts receivable parameters and Accounts payable parameters pages. Automatic settlement settles transactions only in the same legal entity. It doesn’t settle transactions across multiple legal entities.

When you use automatic settlement, you can use the predefined settlement priority, or you can define your own settlement priority on the Accounts receivable parameters page. This functionality is available only for Accounts receivable.

Results of settlement

As transactions are settled, the outstanding balance of each transaction is increased or decreased, as appropriate. Usually, when an invoice and a payment are settled, the status and balance of each transaction is updated according to the following rules:

  • If the payment amount is more than the invoice amount, the invoice balance is reduced to $0.00, and the invoice is closed. The payment remains open, and the balance is the difference between the payment amount and the invoice amount.
  • If the payment amount is less than the invoice amount, the payment balance is reduced to $0.00, and the payment is closed. The invoice remains open, and the balance is the difference between the invoice amount and the payment amount.
  • If the payment amount equals the invoice amount, both the payment and the invoice are closed, and the balance of both is reduced to $0.00.

If the payment amount is less than the invoice amount because of a cash discount, write-off, or underpayment, the invoice and payment might still be closed, depending on how settlements are configured on the Accounts payable parameters and Accounts receivable parameters pages.

Settlements can also generate transactions. For example, the settlement of an invoice and a payment might produce a cash discount, realized gain or loss, sales tax adjustments, write-offs, or penny differences.

Next Steps

If you are interested in learning more about the financial transaction settlement process in Microsoft Dynamics 365 Finance, contact us here to find out how we can help you grow your business. You can also email us at info@loganconsulting.com or call (312) 345-8817.