Enhancements to D365FO Ledger Settlements

With the latest update (version 8.1.1)  for Dynamics 365 for Finance & Operations, Microsoft released enhancements to the existing Ledger Settlements functionality. Ledger settlements allows you to match debit & credit transactions within the GL and mark them as settled, these settlements may also be reversed should they have been made in error. Ledger account settlements are useful when trying to reconcile clearing, prepaid, accrual and/or temporary accounts but may be used with any account in the GL.

To enable and use advanced ledger settlements, follow these steps:

1. Enable advanced ledger settlements
   1. Path: General Ledger < Ledger Setup < General Ledger Parameters
   2. Click on the Ledger Settlements tab and set the advanced ledger settlement option to yes
   3. Select the GL accounts where you would like to use the settlement feature, this list is used to filter the transactions for easier reconciliation
   4. Click save or close the GL parameters window

2. Settle transactions using the new ledger settlements page
   1. Path: General Ledger > Periodic Task > Ledger Settlements
   2. Set the following filters
      1. From/To data range or interval code
      2. Financial dimension set
   3. Click on display transactions, this will filter the transactions based on the GL accounts you assigned in Step 1

4. Select the transactions you would like to settle, mark as many as you would like as long as your marked transaction net to zero

5. Once completed marking the transactions you would like to settle, click Mark selected, this will now put a checkmark next to those transactions

6. Click on Settle marked transactions, select a date & click settle, this will update the status to Settled

3. Reversing a settlement
   1. Follow steps 2a through 2c above
   2. In the status filter, select Settled
   3. Select settled transactions you would like to reverse & click Mark selected

4. Once marked, click on Reverse marked transactions and select yes. 

Feel free to contact us if you have any questions or need additional help with ledger settlements. 

About the Author

Jeff is a Senior Solution Architect with experience in all aspects of implementing ERP. He has an excellent record on projects, successfully analyzing, designing, and implementing software solutions to drive the customers’ business needs. In his role as a Solution Architect, Jeff analyses customers’ requirements, designs solutions, and leads implementations.