Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Rounding Adjustment Exceeds Limit of 5

Posted on by Microsoft Employee

We're using FRx for financial reporting and I've noticed that for the last couple of months when creating the Balance Sheet report, we get a message that says, "Rounding Adjustment0 -50238 Exceeds Limit of 5". I wasn't sure what this meant, but  I pressed "OK" and the FRx Engine continued to prepare the Report. I then noticed that this adjustment is getting applied to Retained Earnings.

Does anyone know what the Rounding Adjustment is and how to fix it? I can't imagine that we have $50k in rounding adjustments so something appears to be off but I have no idea of where to start looking for answers.

Any help would be appreciated.


Kind regards,
Sam

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Rounding Adjustment Exceeds Limit of 5

    Open the report in question and open the row format.

    Click on Edit >> Rounding adjustment. This will tell you the total asset and liability rounding rows.

    Check what the rounding limit is. Increase it to 100.00 and try the report again (100.00 might be a reasonable rounding figure based on your overall totals).

    Its possible that you are missing an account from your report and it is causing the rounding adjustment to be very large. To find any mising accounts, in the Report Format window, select to report on missing accounts.

    Check if any of these have balances.

    Above might point you in the right direction.

    Ian.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans