Dynamics Community Forum Thread Details

Rounding methods for taxes

Hi everyone can somebody pleases give me the break down on the various rounding methods in the Tax Detail Maintenance window? I can't seem to find it anywhere.

Primarily I'm looking for what the difference would be between rounding $23.7406 using these two methods.

Up to the Next Currency Decimal Digit

To the Nearest Currency Decimal Digit

Thanks in advance!

Categories:

Administration and Setup

Hello,

Assuming that your Currency Decimal Digit is 2, here is how I would expect your amount of $23.7406 to round.

Up to the Next Currency Decimal Digit = $23.75 (Essentially always round up)

To the Nearest Currency Decimal Digit = $23.74 (Round up or down, whichever is closer)

Now if your Currency Decimal Digit is 3, here is how I would expect your amount of $23.7406 to round.

Up to the Next Currency Decimal Digit = $23.741 (Essentially always round up)

To the Nearest Currency Decimal Digit = $23.741 (Round up or down, whichever is closer)

If you open the Tax Detail window (Administration >> Setup >> Company >> Tax Details) and go to Help>About this Window, under the Fields tab is has the following explanations.

Round:

Determine how tax calculations will be rounded. Choose from the following options:

Up to the Next Currency Decimal Digit

Select to round numbers to the next currency decimal digit. For example, if the tax amount is calculated to be $1.563, the tax will be $1.57.

To the Nearest Currency Decimal Digit

Select to round numbers to the nearest currency decimal digit. For example, if the tax amount is calculated to be $1.563, the tax will be $1.56.

Down to the Previous Currency Decimal Digit

Select to round numbers down to the previous whole digit. For example, if the tax amount is calculated to be $1.3306, the tax will be $1.33.

Up to the Next Whole Digit

Select to round numbers up to the next whole digit. For example, if the tax amount is calculated to be $1.263, the tax will be $2.00.

To the Nearest Whole Digit

Select to round numbers to the next whole digit. For example, if the tax amount is calculated to be $1.26, the tax will be $1.00. If the tax amount is calculated to be $1.51, the tax will be $2.00.

Down to the Previous Whole Digit

Select to round numbers down to the previous whole digit. For example, if the tax amount is calculated to be $1.563, the tax will be $1.00.

I hope this helps!

Isaac Olson

Microsoft Support

Quick Links

Leaderboard