Yes I understand. And I have to open this in something like Excel and recalculate it. What is the problem to do this in GNC after
changing of sort order? > > On May 28, 2020 at 10:28, <David Carlson > (mailto:david.carlson....@gmail.com)> wrote: > > > > 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 > (mailto:finf...@gmail.com)> wrote: > > > > > > > > > > > > > > > > > > > > > > > > > Begin forwarded message: > > > > > > > > > > From: Finfort <finf...@gmail.com (mailto: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) (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) > > (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) (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) (mailto:finf...@gmail.com)" > > <finf...@gmail.com (mailto: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) (mailto:de...@ihtfp.com) > > www.ihtfp.com (http://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) (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 (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 > _______________________________________________ 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.
