Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Trial Balance Report Display

(0) ShareShare
ReportReport
Posted on by 10

pastedimage1673965225870v1.png

If I select two main accounts and click on all transactions, why it shows me the detail of the second one only? Why can't it display transactions for both accounts?

  • Suggested answer
    Lopa Pattnaik Profile Picture
    Lopa Pattnaik 10 on at
    RE: Trial Balance Report Display

    This solved the issue.

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,723 on at
    RE: Trial Balance Report Display

    Hi Lopa Pattnaik,

    Appreciate if you kindly mark this thread if your query is solved.

    Regards,
    Sourav

  • Lopa Pattnaik Profile Picture
    Lopa Pattnaik 10 on at
    RE: Trial Balance Report Display

    Thank you all. This clarifies.

  • Verified answer
    SouravDam Profile Picture
    SouravDam 11,723 on at
    RE: Trial Balance Report Display

    Hi Lopa Pattnaik,

    One tricky observation I must say 

    As mentioned, you will see that your second selection is actually displaying the transactions and not the other one.

    Let's say, I have selected two accounts here in the TB. "100100000" and "112700000". Out of these two accounts, the second one 112700000 is my last selection which I have marked.

    pastedimage1673983365142v3.png

    Now if I click on 'All transactions', system validates only the last account selection which is 112700000 and not the other one which is 100100000.

    pastedimage1673983476525v4.png

    Now let's try in reverse way where I select the account "112700000" first and then "100100000". So this time account 100100000 is my last account selection.

    pastedimage1673983699766v5.png

    This time if I click on 'All transactions', system picks transactions for the last selection account "100100000".

    pastedimage1673983796960v6.png

    Conclusion:-

    1. System validates the last account selection in TB and only shows all transactions for that account irrespective of multiple account selection at the same time.

    2. As per the standard logic, all transactions generation in TB is account basis. One account at a time. And this is how it is built and giving the result.

    Alternatively; you can go for what Frank Hamelly suggested. If you are using version 10.0.30 then you will see 'Advanced filtering' tab.

    pastedimage1673984665334v7.png

    Here you can set the main account range and click OK.

    pastedimage1673984753908v8.png

    Accounting source explorer report will display all transactions for those selected accounts only.

    pastedimage1673984876231v9.png

    Point to be noted: This "Advanced filtering" option will be added in this report once you enable this feature in Feature management.

    pastedimage1673985004804v10.png

    Hope it clarifies!

    Regards,
    Sourav

     

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,278 Super User 2025 Season 1 on at
    RE: Trial Balance Report Display

    How are you accessing the transactions?  By clicking into one of the amount fields in the trial balance?  If so, you're only going to get the details for a single account.  It's standard behavior regardless of the number of rows in the trial balance you select.  Accounting source explorer may be a better option for you.

    pastedimage1673980764224v1.png

  • Lopa Pattnaik Profile Picture
    Lopa Pattnaik 10 on at
    RE: Trial Balance Report Display

    Hi Ramit,

    If that is the case, how to display transaction details for multiple accounts ?

    Thanks.

    Lopa

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,313 Most Valuable Professional on at
    RE: Trial Balance Report Display

    Are those transactions offering to total amount zero? 

  • Lopa Pattnaik Profile Picture
    Lopa Pattnaik 10 on at
    RE: Trial Balance Report Display

    Thank you Ramit. So I picked two other main accounts that both have transactions during that period if I click separately. But it displays only one.

    pastedimage1673972059037v1.png

    pastedimage1673972194560v2.png

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,313 Most Valuable Professional on at
    RE: Trial Balance Report Display

    Hi,

    TB report only shows if there is any transactions on that period, in your case if there is no transactions in the period you selected in the parameter, it wont show you

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,234 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans