• tom
  • Senior Member
  • Offline
  • From: USA, FL, Tampa
  • Registered: 03/24/2009
  • Posts: 288

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

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

tom's Website

  • tom
  • Senior Member
  • Offline
  • From: USA, FL, Tampa
  • Registered: 03/24/2009
  • Posts: 288

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

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

tom's Website

  • Registered: 12/25/2007
  • Posts: 2,446

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

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

4 Reply by tom (edited by tom 10/05/2010 11:39:13 am)

  • tom
  • Senior Member
  • Offline
  • From: USA, FL, Tampa
  • Registered: 03/24/2009
  • Posts: 288

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

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!

tom's Website