[GNC] Fwd: Wrong running balances in reports

[David Carlson]

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 <finfort at gmail.com> wrote:

>
>
>
>
>
>
>
>
>
>
>
>  Begin forwarded message:
>
>
> >
> > From:  Finfort  <finfort at gmail.com (mailto:finfort at gmail.com)>
> >   Date:  May 28, 2020 at 09:13
> >   To:  David Carlson  <david.carlson.417 at gmail.com (mailto:
> david.carlson.417 at 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.417 at 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.417 at gmail.com (mailto:david.carlson.417 at 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  <finfort at gmail.com (mailto:
> finfort at 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:
> derek at ihtfp.com)>    wrote:
> > > > >   >
> > > > >   >
> > > > >   >
> > > > >   >    Hi, "finfort at gmail.com (mailto:finfort at gmail.com)"     <
> finfort at gmail.com (mailto:finfort at 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  derek at ihtfp.com (mailto:derek at ihtfp.com)   www.ihtfp.com (
> http://www.ihtfp.com)  Computer and Internet Security Consultant
> > > > >   >
> > > > >   >
> > > > >
> > > > >
> > > > >
> > > > >  _______________________________________________
> > > > >  gnucash-user mailing list
> > > > >   gnucash-user at gnucash.org (mailto:gnucash-user at 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 at 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