Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Trial balance report for an account is not showing.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee
Hello, I am using GP 2013 and I noticed that if I run trial balance report for a particular account in financial module it wont print out the report. But if it is for all the accounts it brings out the report. I cant understand the cause for this. Please I need help. Thank you

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Trial balance report for an account is not showing.

    Unfortunately, we've tried that already. I haven't looked into it any farther because the client didn't want me to spend the time. I should probably use PSTL to change it to a different account number and then change it back. That should shake it up enough to fix it. :)

    Thank you

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trial balance report for an account is not showing.

    Hi Leslie,

    Just resolved the issue by rebuilding GL00105 through PSTL. Recently I changed the Chart of Accounts using Account Modifier. We observed this issue after the modification. After rebuilding GL00105, the issue got resolved. Rebuilding GL00105 in PSTL is available through Toolkit option. 

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Trial balance report for an account is not showing.

    Frank,

    I have one client that has this issue. This anomaly has survived several upgrades. There is one GL account that will not print account transaction details on the TB report if you just select that one account.  

  • Suggested answer
    RE: Trial balance report for an account is not showing.

    Hi

    Please run reconcile of financial and try again, if that didn't work please run checklink against financial.  Please take a backup before doing this.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trial balance report for an account is not showing.

    Hi,

    Getting same error in GP2015. How did you resolve the issue

  • soma Profile Picture
    soma 24,406 on at
    RE: Trial balance report for an account is not showing.

    Can you attach the screenshots for the print option window with single account printing and all account printing?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trial balance report for an account is not showing.

    At Mahmoud,

    Thank you for your response.

    The appropriate options were selected. If I run the report for all the accounts the print out the report. But if it is just for one account it prints empty report.

    Thank you

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Trial balance report for an account is not showing.

    Hello,

    Well actually that's not quite precise. In Dynamics GP, all the screens considers what's called the "range" of entities, in which you can include either one to as many entities you want. 

    In your case, I do believe that this specific account falls into one of the following criteria, which is why it was excluded from the report;

    • Posting Accounts
    • Unit Accounts
    • Inactive Accounts
    • Zero Balance/ No Transactions
    • Multicurrency info 
    The trial balance report prints out as derived from the options checked or unchecked above. Below is a screen shot for the petty cash account in Dynamics GP- Fabrikam as printed out from the trial balance window;
    Your feedback is highly appreciated,
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Trial balance report for an account is not showing.

    Are you sure the account you're trying to report on has transactions?  I just tested in my 2013 test system and it works fine.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans