[GNC] Transaction Report Preference missing?

Christopher Lam christopher.lck at gmail.com
Wed Jan 16 19:56:57 EST 2019


This is by design.

Previously a transaction report including *all* accounts for a specified
period would erroneously add the sign-reversed amounts as displayed, which
would lead to the grand total being a nonsensical number. Eg income
$100 expense
$50. Amounts:
Bank $100 -$50
Income $100
Expense $50
Grand total $200 (nonsense)

>From 3.0 onwards the subtotal strategy always adds the non-reversed
amounts, which means the grand total for all accounts for any specified
period would always be $0 thanks to the accounting equation.

Bank $100 -$50
Income -$100 (subtotal negative)
Expense $50
Grand total $0

On Thu., 17 Jan. 2019, 00:34 David T. <sunfish62 at yahoo.com wrote:

> Chris,
>
> I do note one issue with the new transaction report: it doesn’t seem to
> utilize the Sign Reverses option—at least, not that I can see.
>
> Cheers,
> David
>
> > On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user <
> gnucash-user at gnucash.org> wrote:
> >
> > Chris,
> >
> > Thank you for the lead.
> >
> > It turns out that I can get almost exactly the same result using the
> hide transactional data option, when I combine it with "Amount - Single”.
> The only difference is that the Account name is not presented before the
> total line. I consider that to be an improvement, actually.
> >
> > Bug avoided.
> >
> > David
> >
> >> On Jan 16, 2019, at 6:01 PM, Christopher Lam <christopher.lck at gmail.com>
> wrote:
> >>
> >> There's "Sorting / Show subtotals only (hide transactional data)"
> >>
> >> You may be right that 'Display / Amount' = none is not completely
> handled as before.
> >>
> >> Please file a bug, and screenshot a sample report, anonymised; please
> enable 'General / Add options summary' to display options used.
> >>
> >> Also, https://bugs.gnucash.org/show_bug.cgi?id=795064
> >>
> >> Thank you for finding these edge cases.
> >>
> >> C
> >>
> >>
> >> On 16/1/19 8:09 pm, David T. via gnucash-user wrote:
> >>> Hello,
> >>>
> >>> Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I use
> around this time of year (I call it “W-2 - David”) that shows me the total
> amounts assigned to a subset of my expense accounts (i.e., my tax expense
> accounts).
> >>>
> >>> The purpose of this report is to allow me to compare my GnuCash
> numbers to the numbers issued to me by my employer. In GnuCash 2.6.19, this
> report looks something like this:
> >>>
> >>> ———————————————————————
> >>>
> >>> From 01/01/2018 To 12/31/2018
> >>>
> >>> Fed
> >>> Total For Fed       $XXXXX.XX
> >>> Medicare
> >>> Total For Medicare  $XXXXX.XX
> >>> Soc Sec
> >>> Total For Soc Sec   $XXXXX.XX
> >>> State
> >>> Total For State     $XXXXX.XX
> >>> Grand Total $XXXXX.XX
> >>>
> >>> ———————————————————————
> >>>
> >>> As I said, this report is intended to match my employer’s reporting,
> so I can compare the two.
> >>>
> >>>
> >>> However, when I run the *SAME REPORT* in GnuCash 3.4, I get
> unsatisfactory changes to the results. My LITERAL results are:
> >>>
> >>> ———————————————————————
> >>>
> >>> From 01/01/2018 to 12/31/2018
> >>>
> >>> Account
> >>> Fed
> >>> Fed
> >>> Fed
> >>> Fed
> >>> Fed
> >>> Fed
> >>> Fed
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Medicare
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> Soc Sec
> >>> State
> >>> State
> >>> State
> >>> State
> >>> State
> >>> State
> >>> State
> >>> State
> >>> ———————————————————————
> >>>
> >>> Now, there are two significant problems here: first, every transaction
> for the year gets a line, and second, THERE ARE NO AMOUNTS. I have tinkered
> with every setting I can find on the report options, but I cannot find the
> setting that will display ONLY THE TOTALS. It would appear that in a recent
> update to this report, the “NONE” option on line amounts has been removed.
> >>>
> >>> Unless someone can point me to the obvious place where I missed this
> setting, I believe this is a regression in the report. I ought to be able
> to display a report that includes totals only.
> >>>
> >>> David T.
> >>> _______________________________________________
> >>> 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.
> >> _______________________________________________
> >> 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.
> >
> > _______________________________________________
> > 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.
>
>


More information about the gnucash-user mailing list