Bill Payment Cross Rate decimals inadequate
I have an issue where the cross-rate decimals is inadequate to clear the bill.
A bill is created in Indonesian Rupiah.
RP275,400,000.00 at a rate of 1AUD to RP 10,598.984. The AUD Equivalent is AUD 25,983.62.
When the IDR bill is paid using an AUD Cash account, the Cross rate required is based on 1AUD to RP11016 = 0.000090777051561
AUD25,000 / 0.000090777051561 = RP275,400,000.00
However, in Acumatica there cross rate only allows up to 8 decimals, i.e. 0.00009078
The payment is AUD25,000/0.00009078 = RP275,391,055.30
That means that the balance on the Foreign currency bill is RP275,400,000 - RP275,391,055.30 = RP 8,944.70 which is AUD0.81
Although the payment of AUD25,000 is the final payment, the lack of decimals in cross-rate caused a remaining balance in the Bill.
How can we pay the bill without any balance? Any workarounds?