Enhancements to D365FO Ledger Settlements

January 23, 2019 Jeff Katz

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

 

Screenshot of Dynamics 365 for Finance & Operations Ledger Settlements

 

  1. 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

 

Screenshot of Dynamics 365 for Finance & Operations ledger settlements display transaction

 

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

Screenshot of Dynamics 365 for Finance & Operations ledger settlements marked transaction

 

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

Screenshot of Dynamics 365 for Finance & Operations ledger settlements mark selected

 

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

 

Screenshot of Dynamics 365 for Finance & Operations ledger settlements Settled status

 

  1. 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

Screenshot of Dynamics 365 for Finance & Operations reversing ledger settlements

 

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

Screenshot of Dynamics 365 for Finance & Operations ledger settlements reverse marked transactions tab

 

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

About the Author

Jeff Katz

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.

Previous Video
Q&A Series: Can 365ParcelShip help you find the best shipping rates?
Q&A Series: Can 365ParcelShip help you find the best shipping rates?

This week's question: Can 365ParcelShip for D365FO help you find the best shipping rates? Answered by Will ...

Next Video
Dynamics 365 Business Central for Project-Based Companies
Dynamics 365 Business Central for Project-Based Companies

Learn about Dynamics 365 Business Central for Project-Based Companies. Explore Dynamics 365 with us in this...