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 / 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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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.

  • William Kow Profile Picture
    William Kow 3,795 on at

    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 on at

    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

    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 on at

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

  • William Kow Profile Picture
    William Kow 3,795 on at

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

    Anyway thanks 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

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans