Your example had two transactions for the same day. If they are not sorted in the default sort order, the end-of-day running balance is not the last balance displayed.
On Thu, May 28, 2020 at 1:16 AM Finfort <finf...@gmail.com> wrote: > > > > > > > > > > > > Begin forwarded message: > > > > > > From: Finfort <finf...@gmail.com (mailto:finf...@gmail.com)> > > Date: May 28, 2020 at 09:13 > > To: David Carlson <david.carlson....@gmail.com (mailto: > david.carlson....@gmail.com)> > > Subject: Re: [GNC] Wrong running balances in reports > > > > > > > > > > > > If it is out of sequence - it shows wrong values after some > transactions, including the end of the day (in my example). > > > > Who needs running balance like that? > > > > > > > > > > > > > > > > > > > > On May 28, 2020 at 02:51, <David Carlson (mailto: > david.carlson....@gmail.com)> wrote: > > > > > > > > > > > > > > > I forgot the other point I intended to make. > > > > > > > > > > > > GnuCash does not necessarily calculate intra-day balances correctly. > It is only correct at the end of the day. Gnucash may sort same day > transactions differently than you or I want it to. > > > > > > > > > > > > > > > On Wed, May 27, 2020 at 6:44 PM David Carlson < > david.carlson....@gmail.com (mailto:david.carlson....@gmail.com)> wrote: > > > > > > > > > > > > > > > IIRC, in some views the running total is not shown at all when it is > not in sort order. In other views it is shown out of sequence, but it is > correct if the view including the running totals is re-sorted to the > 'correct' sequence. Thus it is not actually wrong, it is just out of > sequence. > > > > > > > > > > > > > > > > That is my opinion. > > > > > > > > > > > > > > > > On Wed, May 27, 2020 at 3:33 PM Finfort <finf...@gmail.com (mailto: > finf...@gmail.com)> wrote: > > > > > > > > > > > > > > > > > > > > > > > > But this is wrong and should be recalculated when changing > sort order, isn't it? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On May 27, 2020 at 17:39, <Derek Atkins (mailto: > de...@ihtfp.com)> wrote: > > > > > > > > > > > > > > > > > > > > > > > > Hi, "finf...@gmail.com (mailto:finf...@gmail.com)" < > finf...@gmail.com (mailto:finf...@gmail.com)> writes: > Appears > in reports when you sorting by date and you have 2 > transactions of > the same date. > > Needs recalculation of running balance. > > > Example of General Ledger report: > > VAT Output > Dr Cr Running Balance > > 31/12/19 O.. LTD > €25,080.00-€212,124.82 > > 31/12/19 R.. GMBH > €2,926.00-€187,044.82 > (should be 215050.82) > > Total > For VAT Output €28,006.00 > > In this example rows should stay > vice versa, like in the editable form > to have correct running > balance. > > So the form has recalculation of running balance, > the report does not have. If you change the sort-order in the register you > will also notice the balance is "off" -- the balance is computed based on > the default sort order and displayed in whatever view you have. In other > words, the balance is ONLY valid in the default sort order, not any other > sort order. This is true in reports as well as the register. > > Please remember to CC this list on all your replies. > You can do > this by using Reply-To-List or Reply-All. -derek -- Derek Atkins > 617-623-3745 de...@ihtfp.com (mailto:de...@ihtfp.com) www.ihtfp.com ( > http://www.ihtfp.com) Computer and Internet Security Consultant > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > gnucash-user mailing list > > > > > gnucash-user@gnucash.org (mailto: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. > > > > > > > > > > > > -- > > > > > > > > > > > > David Carlson > > > > > > > > > > -- > > > > > > > > > David Carlson > > > > _______________________________________________ > 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. > -- David Carlson _______________________________________________ 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.
