Hello Community,
I am stuck in an issue, where my company, in Acumatica, has the base currency of EUR and the payments recorded under this company’s cash account is in SGD. So here I have the Bills and Invoices in multiple currencies (AUD, MYR, INR etc). I have been migrating the data from Xero to Acumatica, so all the previous payments that have been recorded in Xero has the company been created with base currency of SGD, and also the cash accounts in SGD. Can you please suggest me how can I now make this in an easy work around in Acumatica for recording the payments?
Hello,
If you are migrating General Ledger Trial Balances or history by the month, trial balances and GL history must be migrated in one currency, your base currency EUR so that total debits match total credits.
For each bank account that is denominated in currency other than Euro: After GL is migrated and approved, use Banking module, Transfer to create a multi-currency transfer from the Cash Account that is holding the migrated cash balance to a Cash account that is denominated AUD, MYR, INR, etc.
Open Bills can be migrated with Migration Mode on, in the various currencies to match the Xero system you are migrating from.
If you have open custom Payments in AR, I think these can be entered in Migration mode and left un-applied (please try one in your Test environment). If you can’t migrate an open Payment then a Credit Memo can be substituted so that the customer’s total balance is correct.
Laura
Hello,
If you are migrating General Ledger Trial Balances or history by the month, trial balances and GL history must be migrated in one currency, your base currency EUR so that total debits match total credits.
For each bank account that is denominated in currency other than Euro: After GL is migrated and approved, use Banking module, Transfer to create a multi-currency transfer from the Cash Account that is holding the migrated cash balance to a Cash account that is denominated AUD, MYR, INR, etc.
Open Bills can be migrated with Migration Mode on, in the various currencies to match the Xero system you are migrating from.
If you have open custom Payments in AR, I think these can be entered in Migration mode and left un-applied (please try one in your Test environment). If you can’t migrate an open Payment then a Credit Memo can be substituted so that the customer’s total balance is correct.
Laura
Hello
Hello
HI
If you plan to change the currency, you have to ensure that there are no transactions in the tenant. I would suggest creating a new test tenant and testing your needs. Once there are transactions or if it it is a shared base currency, you will not be able to change it, it is not editable.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.