Forum Discussion

Gene1's avatar
Gene1
Member
22 days ago

FX rounding issue in MYOB AccountRight

Hi All,

 

I have a remaining Debit Amt (FX) showing as -0.01 USD, but when I try to apply it, MYOB internally treats it as 0.005 USD. Since MYOB only accepts 2 decimal places, I’m unable to apply the transaction successfully.

 

The transaction has already been locked/saved, and I don’t have permission to edit or delete it.

Has anyone experienced this before? What would be the best way to fix it?

 

Thanks in advance.

2 Replies

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    21 days ago

    Hi Gene1,

     

    That does look close to a foreign currency rounding issue. If the transaction is coming from an integration or external system, make sure that system is set to round values to 2 decimal places before sending them into MYOB. 

     

    As for the transaction being locked, it could be that there’s a locked period in place. It’s worth checking this help link on how to unlock the period and then see if you’re able to edit the transaction. If that’s not what’s causing it, it’d be best to reach out to our team so they can check what’s going on in the file. You can contact them on Live Chat via our virtual assistant, MOCA, or by submitting a support case via My Account.

     

    Cheers,

    Doreen

  • Gene1's avatar
    Gene1
    Member
    20 days ago

    Hi Doreen,

     

    Thanks for advice.

     

    Our bill invoice already pass the locked period long time, so I can't change the invoice. 

     

    At the moment, the only workaround I can do is to reverse the payment and reprocess it again. However, no matter how I recalculate the exchange rate, the issue still happens.

     

    As you mentioned, it looks like the amount generated when the invoice was entered is causing the problem.

     

    To work around this, I have to underpay the invoice by 1 cent. For example, if the system shows USD 21.53, I process the payment as USD 21.52 instead.

    After doing this, the Purchase Register shows:

    •  status: Closed
    • Amount Due (FX): 0.01

    I originally thought this was a perfect workaround. However, when I open the Pay Bills window for this supplier again, the remaining 0.01 still automatically appears and the transaction continues to show as Open.

     

    Would your team be able to investigate or fix this issue/bug?

     

    I’ve attached some screenshots to help explain the situation more clearly.

     

    Thanks again for your help.

    Kind regards