FrontAccounting forum — Reconcile Bank Account - removing extra statement(s)

Re: Reconcile Bank Account - removing extra statement(s)

null@example.com (tom) — Tue, 05 Oct 2010 11:38:19 +0000

Ok here I go with Backup in hand!

Thanks
ps. editing the database directly is NOT for the faint of heart! and *always* have a backup ready for when you DO mess up!

Re: Reconcile Bank Account - removing extra statement(s)

null@example.com (itronics) — Tue, 05 Oct 2010 10:22:03 +0000

Yes, it is so simple. Beginning balance is calculated on the fly as a sum of all reconciled transactions with older date (see get_max_reconciled()).
Janusz

Re: Reconcile Bank Account - removing extra statement(s)

null@example.com (tom) — Tue, 05 Oct 2010 01:28:17 +0000

Could it be as simple as clearing the 'reconciled' field?

But there is still the question of where are the beginning/ending balances stored for each statement.

Perhaps a bank_trans transaction?

tom

Reconcile Bank Account - removing extra statement(s)

null@example.com (tom) — Tue, 05 Oct 2010 01:12:13 +0000

Is there any easy (or hard) way to remove a statement to start it over?

I have a messed up statement and I just noticed there is an extra statement that only about a week long.

I must have made a typo on the date one time... this could explain why it is messed up.

Yes I have backup *now* but I am not sure when that extra statement came in.

tom