On 11/25/19 7:16 AM, Derek Atkins wrote: > Hi David, > > David Carlson <david.carlson....@gmail.com> writes: > >> Derek, >> >> If what you call a rolling balance is what I call a running balance, then I >> think that the account register view will show that when it is sorted in >> chronological order. In fact, as others have already noted, you can see that >> in your top level accounts. Where you won't see it is in mixed commodity/ >> mixed currency cases such as stock brokerage accounts or other mixed currency >> accounts. For those cases it is necessary to use a report that can evaluate >> appropriate exchange rates. > Yes, rolling/running balance. However, while there is a balance column > being displayed, it might not show the *correct* balance because each > split shown has a precomputed balance for the actual account it is tied > to. This balance is recomputed whenever a split in the account is > modified. However, it is NOT computed in real-time for display. > > So when you do a "Open Subaccounts" view, it is not recomputing the > balance including everything, but rather it is still showing the > pre-computed balance of the split's account balance for that split. > > It *MAY* look correct at some points in time, but in general, no, it is > not. > >> David Carlson > -derek >
I understand the legacy reasons for doing this, but as a corporate DBA (Oracle), I find this troubling. Running balances should never be stored! Again, I understand why legacy systems do this but we now have enough horsepower in the CPU and back-end database systems to alleviate the need. Hopefully as GnC is migrated to a multi-user database back-end system, this will be redesigned. --Steve _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.