[GNC] Wrong running balances in reports

Derek Atkins derek at ihtfp.com
Wed May 27 10:39:13 EDT 2020


Hi,

"finfort at gmail.com" <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             www.ihtfp.com
       Computer and Internet Security Consultant


More information about the gnucash-user mailing list