search

scottohara / loot

An implementation of some of the core MS Money features in Ruby on Rails
MIT License
4 stars 3 forks source link

Running balance calcs incorrect when reconciled transactions interspersed #52

Closed scottohara closed 10 years ago

scottohara commented 10 years ago

Running balance is calculated by iterating over the set of fetched transactions on the client-side.

In the case of transfers, a transaction might be marked as reconciled from one side.

Viewing the ledger of the other side of the transaction with "Unreconciled Only" selected, the reconciled transaction is excluded from the fetched results, and the balance calculation is affected.

Perhaps we need to move from transaction_headers.status to transaction_accounts.status?

scottohara commented 10 years ago

Still an issue. When a reconciled transaction has a later date than an unreconcile one; and the ledger is showing unreconciled only; the opening balance needs to factor in any later reconciled transactions.