Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Trial Balance vs Ledger Settlements

(0) ShareShare
ReportReport
Posted on by 205

Dear all

I hope everything is well. 

I have a client that is reporting an issue with the Trial Balance and the Ledger Settlements. The issue is: 

  • They have generated a TB for a specific time period and filtered it by a specific Ledger Main Account;

  • They have set that Ledger Main Account as a Ledger Settlement Account and generated a Ledger Settlements Report trough GL > Periodic Tasks > Ledger Settlements for the same time period as the TB. The status was set as = all. 

They have the expectation that the number of transactions shown on the TB should be the same of the transactions shown on the Ledger Settlements and the total value between the TB and Ledger Settlements should also be the same. I have tested this and can confirm that this is not happening - the transactions on the TB are much more that the ones on the Ledger Settlements and the total value is completely different. 

My questions are: 

  • Is their assumption that the number of transactions and respective values should be the same between the TB and Ledger Settlements? 
  • What is the criteria for the transactions to be shown on the Ledger Settlements report? 

I appreciate all the help in advance. 

  • Afonso Rodrigues Profile Picture
    205 on at
    RE: Trial Balance vs Ledger Settlements

    Hi everyone.

    Thank you a lot for your replies.

    From your answers I can understand that the assumption that the Ledger Settlements for one account and the TB for that same account, for the same time period, need to be the same in terms of values and number of transactions is not correct.

    This means that some transactions for that account should not appear on the Ledger Settlements. Hence, I still could not understand what is the criteria that makes a transaction to appear on the Ledger Settlements or not.

    Can someone help me with that?

    Thank you.

  • Sheela Ningappa Profile Picture
    on at
    RE: Trial Balance vs Ledger Settlements

    Hi Afonso,

    Please find the below link which explains more:

    Difference between 'ledger settlement' balance and 'trial balance' amount of a ledger balance - Microsoft Dynamics AX Forum Community Forum

    Thanks,

    Sheela

  • BillurSamdancioglu Profile Picture
    13,216 Moderator on at
    RE: Trial Balance vs Ledger Settlements

    Hi,

    Legder settlement is used for reporting purposes. You can settle reversals or accruals etc.

    So if there are any unsettled transactions in the transactions, that will have a difference.

  • Morgan Bazin Profile Picture
    1,027 on at
    RE: Trial Balance vs Ledger Settlements

    Hi Afonso,

    Based on my understanding, the expectation that the TB and Ledger Settlements report being the same is not valid.

    You can learn more about the Ledger Settlement functionality here: Ledger settlements - Finance | Dynamics 365 | Microsoft Learn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Jahanvi Profile Picture

Jahanvi 34

#2
PJ JohnPaul Profile Picture

PJ JohnPaul 5

#3
SudhanshuMSID Profile Picture

SudhanshuMSID 1

Overall leaderboard

Product updates

Dynamics 365 release plans