Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
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
  • BJ-09051414-0 Profile Picture
    BJ-09051414-0 248 on at
    Difference between the summary Trial Balance and detailed trial balance report
    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
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Difference between the summary Trial Balance and detailed trial balance report
    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:

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans