web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Multicurrency Rounding and Decimal Placement Discrepancy in Year-End Close

(0) ShareShare
ReportReport
Posted on by

Hello:

We recently closed FY2016 in our twenty companies, in GP 2013 R2, and almost half of those companies are based overseas.

 

One of our UK companies reports that there is a discrepancy caused by what they call "wrong rounding in GP".  The app's "canned" G/L trial balance shows amounts rounded to two decimal places.  They are comparing this to a SmartList that they created called the "Global Trial Balance", and that SmartList shows amounts that have more than 2 decimal places.

 

As a result – 12 accounts in the G/L trial balance are out of balance by 1 cent each.  So, that company's FY2016 Trial Balance is out by 10 cents.

 

Does GP have any sort of file maintenance or utility that could be used to fix these rounding differences?

 

John

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at
    RE: Multicurrency Rounding and Decimal Placement Discrepancy in Year-End Close

    You can disregard.  Apparently, it is not a Multicurrency rounding issue.  

    Instead, it has to do with how some end users during FY2016 copied data from Excel containing more than two decimal places into GP, which "cuts off" data past two decimal places.

    This is discussed in the following article:

    support.microsoft.com/.../2428683

    John

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans