Total Columns on Invoice Incorrectly Calculated

Hi ozeami, 

Thanks for your post.

My apologies for the late response. I appreciate your detailed description of the issue you're experiencing with the invoice total calculations. If your multi-currency is still calculated incorrectly, we recommend updating it by going to Setup> Preferences. You may check out this helpful article: Working with Multiple Currencies. This article provides detailed steps on how to work with multiple currencies in MYOB software. It should guide you on how to update the multi-currency function on the software and correct any multi-currency calculation issues on your end.

If you need further assistance, please don't hesitate to reply.

Kind regards,

Shella

Shella_A 

This was a bug in the software. Had nothing to do with setup of multiple currencies. We are very familiar with using the software and the multiple currency feature and have been doing so for 20+ years. 

The total column in in the invoices rows were not being calculated correctly. Instead the invoice had to be deleted and recreated for the invoice to calculate correctly. 

This was some sort of database, software issue. 

As you can see in the screenshot 30x USD$100.24 is not being shown as USD$3,007.20. Instead it is the AUD value being shown in the USD column and even that is not in the correct exchange rate. And the AUD column is converting the Incorrect AUD value again and generating some incorrect value for the total invoice in AUD. 

USD$3,007.20 does not equal AUD$7,104. I would have thought this is pretty simple to deduce. 

Whereas the system is converting $3,007.20 to AUD and then converting it again for a second time. This is what seems to be happening at some random FX rate. We had to delete this invoice and re-create it to get rid of the issue but this was definitely a bug. 

Hi ozeami, 

Thanks for the response. 

I understand how updating muti-currency will be some work. However, checking and updating this will fix any currency issues with your AccountRight transactions. We appreciate your patience with this. If you still need assistance with this, please don’t hesitate to reply, as we’re always delighted to assist you further.

Otherwise, if my response has answered your inquiry, please click "Accept as Solution" to help other users find this.

Kind regards,

Shella

Shella_A 

Hi Shella

I am not clear at all on what you mean?? We have multi-currency allready activated on our system. Have had multi-currency for over 20 years! 

This is a bug in the forms... It happened once and we have not been able to recreate it. 

What are you actually saying, suggesting? It is totally unclear. Have you looked the sample image and the issue? 

Hi ozeami, 

Thanks for the response.

My apologies for the late reply. I understand your concern about the multi-currency bug in the forms. Your patience with this is highly appreciated. We're recommending an update to your multi-currency settings, as checking and updating this will fix any currency issues with your AccountRight transactions. If you believe this is a bug, I would recommend documenting the exact steps you took when you encountered the issue, including any error messages you received. We're looking forward to your response.

Kind regards,

Shella

Hi ozeami,

I hope this message finds you well today. I just wanted to follow up on whether you still require further assistance with your invoice calculated incorrectly, as we’re not able to receive any updates. If you encounter any further issues, please feel free to reply, as we're happy to assist you further.

Kind regards,

Shella

Hi Shella

Your recommendation did not address our concern. We have given up on this issue and will just have to double check every invoice total going forward because we can't trust that the MYOB forms are going to add up basic items correctly. 

Hi ozeami,

Thanks for the response.

I'm sorry to hear that updating the multi-currency setting didn't resolve the issue. Your patience and understanding in this matter are highly appreciated. Moving forward, if multi-currency settings are updated, double-checking the invoice can be the best option we recommend to avoid any incorrectly calculated invoices for future transactions.

Please be informed that we will be closing this thread now. Feel free to write a new post if you have any other questions.

I also recommend reaching out to our online help desk and exploring our MYOB Academy to learn more about MYOB product information. We're always delighted to assist you further. 

Kind regards,

Shella