Forum Discussion

FrankNeoGL's avatar
FrankNeoGL
Partner
5 months ago

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?

 

Replies have been turned off for this discussion

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.