Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Rounding Adjustment Ex...

Rounding Adjustment Exceeds Limit of 5

(0) Share

Report

Posted on by Community Member 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

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (1)

Report

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.