Settlement overview
Important
Some or all of the functionality noted in this article is available as part of a preview release. The content and the functionality are subject to change. For more information about preview releases, see Service update availability.
This article provides general information about the settlement process. It describes which transaction types can be settled, and the timing and process for settling them. It also describes the results of the settlement process.
During settlement, the transactions on one document are applied to the transactions on another document to increase or decrease the balance of each document. For example, a payment can be applied to an invoice. Various types of transactions can be settled, at different times, through different methods. The settlement process can also generate new transactions.
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.
Identifying marked transactions during settlement
When you try to settle a transaction, you might notice a symbol that indicates that the transaction is marked in another location. In this case, you can select the transaction on the Settle transactions page and then select Inquiry > Settlement from the settlement window. The view for this inquiry shows journals, sales orders, invoices, payment proposals, and customer locations that might be blocking the transaction from settlement. To resolve the issue, you can select the link to go directly from the inquiry to the blocked location. You can then update the document with the adjustments that are required to settle it. You can also use the Marked indicator to identify other documents that are included in the same blocking location.
Additional resources
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for