At go live I entered my bank balances as G/L entries using the Z_ImportGLTransactions.php. I assumed by looking at the logic that the proper banktrans records would get created for those accounts that were bank accounts. This didn't happen because of the transaction type column being 0.
This is fine for the G/L and I can manually reconcile the account looking at the G/L inquiry however now when I use WebERP to reconcile an account I am off by the opening balance of the account.
How can I fix this? Can I insert using SQL a banktrans record for the opening balance?
I did this in a development system without issue. Any gotchas?