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

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

2010-10-05T11:38:19Z

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)

2010-10-05T10:22:03Z

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)

2010-10-05T01:28:17Z

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)

2010-10-05T01:12:13Z

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