web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Difference between the...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Difference between the summary Trial Balance and detailed trial balance report

(1) ShareShare
ReportReport
Posted on by SS-24061500-0 2
We have a reversing AR entry not appearing on the detailed trial balance report but is included in the summary trial balance total and in the records when you review the chart of accounts balance details. Why would this entry not appear in the trial balance total? This is causing an out of balance between our detailed trial balance and our summary trial balance reporting.
Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Hi, this can occur when there is an unbalanced journal entry or a rounding difference using multi-currency. The solution is mentioned in the MS document, please refer to the link for some hints:
  • BJ-09051414-0 Profile Picture
    BJ-09051414-0 346 on at
    Hello,

    There are a couple things that can cause the Summary Information to not match the detailed information. 
     
    1. The summary information is just a running total of the detail that gets updated when things post.
      1. If there were any issues during the posting process, the summary information could not have been updated.
    2. If one report is modified and the other is not, the modifications could be causing the report to print different amounts.
    3. In the GL tables, there is a field called Ledger_ID which is used with multiple ledgers.
      1. This can at times have the wrong value. However, if this was the issue, I would think both reports would not reflect the amount.
    4. Manual changes to the summary window.
      1. If someone manually changed the summary amounts for the account in the summary window, this would cause the reports to not match.
    How I would approach this.
    1. First, I would review the data in the GL20000 table for the reversing entry that you are questioning and verify the Ledger ID and no damage to the GL Entry.
    2. Next, if either of the reports are modified, set security back to the core GP report and see if the same thing occurs.
      1. If it does not, then you need to look at the modifications made to the report.
    3. If no damage and the Ledger ID is correct, you can use Reconcile to update the summary information based off the detail.
      1. CAUTION – If you run this in live it can cause further issues if you have bad data or have manual changes as the Reconcile will update the Summary Amounts based on the Detail records.
        1. I highly suggest you run this in test first so you can see the changes as the only way to undo it if it is done in live is to restore a backup before this was done.
    4. Lastly, verify that the two reports are being run for the same date restrictions. If using different dates, this could be the cause as well.
    Based off your scenario provided, it sounds like it shows on the detail but not the summary. Reconcile should correct this if there is no damage or manual changes.

    Beyond the above, I would need to see the data, the dates being used to run the reports, to determine what might be the cause.
     
    I hope this helps!
     
    Thank you!
     
    Brandon
    Functional Consultant

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans