10
I Have problem , when we print a detail and summary report for 1 account. there is a difference of .01 cent
it seem to a rounding error. when i look at the database - the journal entry data show as xxxx.9167 in the SQL database but as .92 in the summary and .91 in the detail report
is there any way to fix this either via an script script or data entry via GP
I have seen this happen in GP 2015/GP 2016 with Excel Paste for journal entries. (I recommend clients on those versions to make certain to use =ROUND in their formulas in Excel to keep amounts to match their currency decimal places.)
To fix it, you'll need to do an update the data in SQL. (Insert all the regular warnings here: Backups, test, SQL experience, users out of the database, run financial reconcile after, etc.)
The testing warning is especially important if the problem entry impacts multi-currency and/or inter-company.
If the original entry is in a history year, you'll need to update the closing entries for the additional years as well.
If the entry is coming from a subsidiary ledger, you'll need to find/fix the source data there as well. :(
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (