Is there any way to avoid or minimize the rounding difference in Sales Order of foreign currency ?
Hello,
I have a sales order with multiple line items. Typically, the foreign unit cost is 0.9468 and the exchange rate (Divisor Method) is 0.2722941, which gives me a converted unit price of 3.47712271400666.
For a quantity of 782, the exact extended amount should be 2719.10996235321. However, since the system only allows 4 decimals for unit price (3.4771), the extended amount becomes 2719.09 (3.4771 × 782). This creates a difference of 0.02 on this line.
Because my sales order has 148 line items, the accumulated difference is more than 2.
Is there any way to avoid or minimize this rounding difference?
Regards
Arvind Kadam