Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Bank Reconciliation
06-12-2014, 12:24 AM, (This post was last modified: 06-12-2014, 03:57 AM by agaluski.)
#1
Bank Reconciliation
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?

Any experts care to comment?
Reply
06-12-2014, 06:16 AM,
#2
RE: Bank Reconciliation
Just finished inserting these records (after chasing down another issue with gltrans bfwd).
Reconciliation was easy. Great functionality!
Reply
06-12-2014, 10:57 AM,
#3
RE: Bank Reconciliation
You already figured out the answer was yes :-)
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
07-02-2014, 02:22 AM,
#4
RE: Bank Reconciliation
Slightly off-topic but it's a pretty great feature/functionality phil. Keep it up! lol :-)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)