I recently discovered something that I need to further understand and fix. We are a US company with locations in Canada and Bulgaria. Our Canadian entities base currency is in CAD, but we have a number of customers that are were billed in USD. We've made a point of moving those customers to our US entities so we no longer have any USD billings in a CAD base currency entity. However, what I am seeing is that we still have a large amount that is revalued every month. Investigating this further I see what has happened. The invoices/credit memos/debit memos come into the deferred revenue as USD, but are amortized out as CAD. Therefore I have a perpetual foreign currency amortization difference. When I looked in SuiteAnswers it shows foreign currency amortization is available only in the NetSuite UK editions.
I have two questions. The first is if I make a journal entry to remove all of the USD entries and reinput them as CAD entries (add them all the original entries together and use the average exchange rate for those entries) will it will that fix my perpetual foreign exchange problem without causing other problems?
My second question, is it possible to set up amortization schedules (deferred revenue or otherwise) to amortize in the currency from the original input transaction.
I have attached a spreadsheet which shows the issues (Source 3). Unfortunately the volume of these transactions is huge and contains confidential information. I've summarized the type of USD entries entered for Source 3 on the bottom section of the spreadsheet.
All help is appreciated.