rounding difference in GL summary / detail report

Like (0) Share

Report

Posted on 20 Apr 2020 21:02:46 by Liveinc2011

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

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Lisa at AonC.com 682 on 20 Apr 2020 at 23:10:18

Like (0)

Report

RE: rounding difference in GL summary / detail report

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. :(