Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

penny difference on TB

(0) ShareShare
ReportReport
Posted on by

Penny difference shows up on Summary TB, SQL totals of GL20000 are OK.  Is there anything in the standard GP Trial Balance report that would account for this?

*This post is locked for comments

  • DCSisler Profile Picture
    DCSisler on at
    RE: penny difference on TB

    Thank you, thank you, thank you - it was the Inactive Accounts checkbox, not checked.  Magic!

  • Verified answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 604 on at
    RE: penny difference on TB

    I have seen this in GP 2015 when using Excel Paste and the data in Excel went out extra decimal places.  Your check on the data out extra decimal places should have caught that.

    If it is just a difference in the beginning balance, you may want to check data in the prior year to see if the extra decimal places rolled into the new year during close.

    And, of course, I'm assuming you have Unit Accounts unmarked and Inactive Accounts marked in the Trial Balance Report Option to make certain you have the complete GL financial data.

  • DCSisler Profile Picture
    DCSisler on at
    RE: penny difference on TB

    I have not yet hit the Reconcile routine - too many users trying to do year-end work at the moment.  It's off in total, shows Beginning Balance off by .01 Debit, Debits & Credits off by (.01) too high on Credits, nets to 0.00 at the end.  I even checked the totals of all the JE batches, looked for excess decimal places with anything other than '000', came up empty.  Never seen anything like it, and so long as it doesn't actually interfere with the upcoming year-end processing, I probably won't spend any more time on it.  Thanks for the input, Richard.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: penny difference on TB

    Have you tried Tools->Utilities->Financial->Reconcile to reconcile all your GL accounts? Are all your accounts off by a penny or just some?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans