Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Debit & Credit bal...
Microsoft Dynamics GP (Archived)

Debit & Credit balance not tally in GL Trial Balance

(0) ShareShare
ReportReport
Posted on by William Kow 3,795

Appreciate if you can advice me on how to troubleshoot for GL Trial Balance Summary -- the printout for July-2010 Debit and Credit balance do not have same amount, the difference is $544.87 and the Begining Balance and Net Change is also same amount $544.87. HOWEVER, the trial balances for both June-2010 and Aug-2010 all are OK -- Debit & Credit is equal, and the Begining Balance & Net Change is zero amount for both moth, but not for July-2010.

All 3 months, June, July & Aug TB are all with zero Ending Balance. But ONLY July with $544.87 Begining Balance.

Please advise. Many thanks in advance.

*This post is locked for comments

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Re: Re: Re: Re: Debit & Credit balance not tally in GL Trial Balance

    Yes, the issue has been settled, BTW, it is not an issue, is because I am careless  -- overlook the report options.

    Anyway thanks again.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Debit & Credit balance not tally in GL Trial Balance

    Yes!! that would explain it. Did it resolve your issue?

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Re: Re: Debit & Credit balance not tally in GL Trial Balance

    Many thanks for reply, and I have missed look the settings for report options, the excluded Inactive Accounts. And then I received feedback from the user that she have inactive a Checkbook ID and the Cash Account, but then in JULY-2010 she have posted a transactions to transfer fund out from this Checkbook ID.

    I apology for my overlook of this report options -- to in/exclude inactive account.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Debit & Credit balance not tally in GL Trial Balance

    Hi William, Yes, I understood that it was the GP Trial Balance report - just mentioned using FRx just to see if the problem is duplicated in FRx - then its probably a data issue. If FRx balances, then you can compare the FRX report with the GP report and it will identify the problem account(s) and then you can dig deeper to find the actual GL Journal that is causing the issue.

    Have you access to customer / partner source?

     

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Debit & Credit balance not tally in GL Trial Balance

    Hi, Ian, many thanks for your reply. By the way, the Trial Balance is NOT generated from FRx, but is from (Reports > Financial > Trial Balance) Reports: Summary and selected for Posting account.

    I thought may be due to data damaged, so I have run CheckLink for all Financial logical files, but the Debit Credit balance $544.87 still showing in the July Trail balance report.

    Whether I print Detailed or Summary TB, the $544.87 difference is still showing.

    I have run the reconcile for current OPEN year 2010 (Utility>Financial>Reconcile) but then the TB still appear $544.87 (I am new to this reconcile and I did not see any report after the reconcile.

    Thanks again.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Debit & Credit balance not tally in GL Trial Balance

    Hi William. Tough one. Is the report modified?

    I presume you have looked through GL Enquiry to see if there is any account with a balance of 544.87 in July (that might be left off the report).

    Are you using FRx? Does a TB from FRx balance out? Might be worth creating a quick TB in FRx just to see - open a Row Format and click Edit >> Add Rows From chart of accounts...and add all accounts.

    If you print a detailed TB report, is this correct? If it is, then try reconciling your financial years (Tools >> Utility >> Financial >> Reconcile). Start at the earliest year and work your way forward to the current year, and then try the summary TB again.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans