When a Business moves from another ERP system to IFS or IFS older version to a new one, what are the mechanisms to move cash balances to the new system?
Further, if already moved cash balances (under any mechanism) have any issues, how can those be corrected subsequently using themix payment window?
Look at manual vouchers, we’ve always done this task via a manual voucher to set the opening balance for each of the various accounts. I don’t think we’ve ever used the mixed payment for any purpose related to opening balances or correcting them later. Vouchers only.
+7
Hello
To upload opening balances to GL accounts Q vouchers are used.
Using mixed payment window to upload cash balances is not appropriate.
I hope using manual cash balance or a similar window would be appropriate..
Thank you,
Dhananga
Hi
Using a Q voucher will only affect the GL, not the cash book balance.
For each sub-ledger ‘Control Account’ such as AP, AR, Cash and Stock I normally create a temporary ‘offset GL account’ to handle the double entry at go-live.
For example your Cash Account has a 100 balance. So you need to create a mixed payment with a single ‘Direct Cash Transaction’ to your Cash ‘Offset Account’. This will Debit the PP1 Cash Account and Credit the Offset account.
When you migrate your historic GL Balance, you will find you now have 200 debit to your PP1 GL account.
So you need to do a final ‘clear down’ Q Voucher to Credit the PP1 Cash Account and Debit the offset account.
The offset account balance will now be zero and the Cash Account Balance in both the GL and the Cash Book will be 100.
I know this method requires additional steps to those above, but is the only way to create matching GL and Cash Book Balances that I am aware of.
Regards
Barrie
As per my understanding, there is no need to perform any additional step in migration. You need just one (or more) control accounts for various migration parts (various ledgers migrated).
e.g.
Finally, when you book remaining part of trial balance migrated using manual voucher (usually M, if control accounts are marked as non-ledger, there is no ledger account in this voucher, as you are booking control accounts instead original ledger accounts migrated elsewhere), control accounts are closed - by definition…
Q vouchers can be useful in specific cases only (e.g. in case of Revenue Recognition initialization), but they should be avoided in general.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
