Example: Rounding Converted Limit Amounts
Limit amounts are credit limit amounts and minimum and maximum order amounts that you assign to a customer or supplier master record. Limit amounts are usually rounded numbers and are stored without decimals.
This example describes how the Address Book Conversion - F03012 and Address Book Conversion - F0401 (R890401E) programs round converted limit amounts when converting from Canadian dollars (CAD) to US dollars (USD) if you enter a rounding factor in the processing options.
In this example, the exchange rate is 1 CAD = 0.63492 USD and the rounding factor is 50. The conversion programs round converted limit amounts up or down.
This table describes the converted limit amounts:
Converted Limit Amounts |
Description |
|---|---|
Round Up |
The conversion program converts 8,000 CAD to 5,079.36 USD. The system rounds 5,079.36 USD up to 5,100 based on this calculation: Converted Amount ÷ Rounding Factor = Q with a remainder of R. If R is greater than or equal to half the rounding factor, then subtract R from the rounding factor and add that amount to the converted amount. In this example, 5,079 USD ÷ 50 = 101 with a remainder of 29, which is greater than half 50. Subtract 29 from 50 (50 − 29 = 21) and add 21 to 5,079 to get a rounded value of 5,100. |
Round Down |
The conversion program converts 12,000 CAD to 7,619.05 USD. The system rounds 7,619.05 down to 7,600 based on this calculation: Converted Amount ÷ Rounding Factor = Q with a remainder of R. If R is less than half the rounding factor, then subtract R from the converted amount. In this example, 7,619 USD ÷ 50 = 152 with a remainder of 19, which is less than half 50. Subtract 19 from 7,619 to get a rounded value of 7,600. |