Foreign Currency - Receivables Reports Corrupted!
We are having major issues whereby even though we only have 4 invoices open as paybale with one of them being in USD our aged receivables reports tells a completely different story with various amounts owning on various client invoices going as far back as 8 years ago which is the duration which we still keep transaction reports! This makes our aged receivable reports, statement reports and "to do list" receivables completely useless. Below is what our actual receivables is: Below is what MYOB Aged receivables and receivables to do list spits out. None of these invoices have anything owing on them. Below is a look into one of these invoices which is showing as still owing a large amount: The invoice itself is also showing "0" balance as owing. When we look at the payment/transaction history of this invoice we see the following: There is a difference in the calculated AUD amount of the invoice at the time of the invoice and the AUD equivalent amount of the payment which is expected if there is FX change between payment received and invoice issued which should normally show up as FX gain or loss however the "Balance due" amount makes no sense as it is completely different from the difference of the AUD Equivalent Payment and AUD equivalent invoice and should not even be showing up as "balance due" . There seems to be some serious issues/flaws with the way Foreign currency is handled in MYOB and this is causing us allot of problems!! We need assistance on this in an urgent manner! All of these invoices are USD and they have been fully paid and fully closed with the exception of the 1 invoice which is still open as per provided screen shots.
