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
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
Thank you, thank you, thank you - it was the Inactive Accounts checkbox, not checked. Magic!
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.
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.
Have you tried Tools->Utilities->Financial->Reconcile to reconcile all your GL accounts? Are all your accounts off by a penny or just some?
André Arnaud de Cal...
292,516
Super User 2025 Season 1
Martin Dráb
231,407
Most Valuable Professional
nmaenpaa
101,156