[GNC] Transaction Report Preference missing?

classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

[GNC] Transaction Report Preference missing?

GnuCash - User mailing list
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

Christopher Lam
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
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

GnuCash - User mailing list
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 <[hidden email]> 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
>> [hidden email]
>> 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
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

GnuCash - User mailing list
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 <[hidden email]> 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 <[hidden email]> 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
>>> [hidden email]
>>> 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
>> [hidden email]
>> 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
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

Christopher Lam
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. <[hidden email] 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 <
> [hidden email]> 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 <[hidden email]>
> 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
> >>> [hidden email]
> >>> 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
> >> [hidden email]
> >> 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
> > [hidden email]
> > 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

GnuCash - User mailing list
In reply to this post by GnuCash - User mailing list
Then why include the option? It no longer does anything, except imply to the user that they have control over something they Nik longer can control.

David

On January 17, 2019, at 6:27 AM, Christopher Lam <[hidden email]> wrote:

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. <[hidden email] 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 <[hidden email]> 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 <[hidden email]> 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
>>> [hidden email]
>>> 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
>> [hidden email]
>> 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
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

Christopher Lam
Sadly, the gnucash project has a long history of never removing features.

The amount sign reversal is still functional for the transactional amounts.
Only the subtotals are unaffected.

On Thu., 17 Jan. 2019, 09:08 D <[hidden email] wrote:

> Then why include the option? It no longer does anything, except imply to
> the user that they have control over something they Nik longer can control.
>
> David
>
>
> On January 17, 2019, at 6:27 AM, Christopher Lam <
> [hidden email]> wrote:
>
>
> 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. <[hidden email] 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 <
>> [hidden email]> 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 <
>> [hidden email]> 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
>> >>> [hidden email]
>> >>> 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
>> >> [hidden email]
>> >> 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
>> > [hidden email]
>> > 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

GnuCash - User mailing list
Chris,
While I understand and respect the goal of backward compatibility, I'll point out that your changes to this report have already broken backward compatibility, as evidenced by my original example.  Settings which worked previously yield meaningless results now, and I have had to go through every one of my reports that are based on the transaction report and fix what got broken. 
For my use case (not all that exotic, IMHO), the setting appears to be broken; when transactions are shown, are you saying the transactions are reversed, but the totals are not? Because that would drive me crazy...
Is there truly no way to store and calculate values internally to the report but display results the way the user requests to see them?

David
 
 
  On Thu, Jan 17, 2019 at 7:13, Christopher Lam<[hidden email]> wrote:   Sadly, the gnucash project has a long history of never removing features.
The amount sign reversal is still functional for the transactional amounts. Only the subtotals are unaffected.
On Thu., 17 Jan. 2019, 09:08 D <[hidden email] wrote:


Then why include the option? It no longer does anything, except imply to the user that they have control over something they Nik longer can control.

David


On January 17, 2019, at 6:27 AM, Christopher Lam <[hidden email]> wrote:


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 -$50Income $100Expense $50Grand 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 -$50Income -$100 (subtotal negative)Expense $50Grand total $0
On Thu., 17 Jan. 2019, 00:34 David T. <[hidden email] 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 <[hidden email]> 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 <[hidden email]> 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 .



 
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

Christopher Lam
I don't know, sorry. You're very welcome to dive into code and try.
https://github.com/Gnucash/gnucash/pull/229 will be a good place to start
research.

On Thu., 17 Jan. 2019, 10:24 David T. <[hidden email] wrote:

> Chris,
>
> While I understand and respect the goal of backward compatibility, I'll
> point out that your changes to this report have already broken backward
> compatibility, as evidenced by my original example.  Settings which worked
> previously yield meaningless results now, and I have had to go through
> every one of my reports that are based on the transaction report and fix
> what got broken.
>
> For my use case (not all that exotic, IMHO), the setting appears to be
> broken; when transactions are shown, are you saying the transactions are
> reversed, but the totals are not? Because that would drive me crazy...
>
> Is there truly no way to store and calculate values internally to the
> report but display results the way the user requests to see them?
>
> David
>
>
> On Thu, Jan 17, 2019 at 7:13, Christopher Lam
> <[hidden email]> wrote:
> Sadly, the gnucash project has a long history of never removing features.
>
> The amount sign reversal is still functional for the transactional
> amounts. Only the subtotals are unaffected.
>
> On Thu., 17 Jan. 2019, 09:08 D <[hidden email] wrote:
>
> Then why include the option? It no longer does anything, except imply to
> the user that they have control over something they Nik longer can control.
>
> David
>
>
> On January 17, 2019, at 6:27 AM, Christopher Lam <
> [hidden email]> wrote:
>
>
> 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. <[hidden email] 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 <
> [hidden email]> 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 <[hidden email]>
> 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 .
>
>
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

GnuCash - User mailing list
Chris, 
Thanks for the offer, but readers of these lists over the years can vouch for my utter inability to contribute meaningfully to any code. That's why I've tried to contribute to the documentation (although to be truthful, even that is a stretch).
I apologize for suggesting tasks for you to do, and I will attempt in the future not to make that mistake again. It's too bad the transaction report will continue to have these problems for the foreseeable future. I'll try and figure out some way to document its quirks on the wiki, so that people may be made aware of them and work around them. 
David

 
 
  On Thu, Jan 17, 2019 at 8:04, Christopher Lam<[hidden email]> wrote:   I don't know, sorry. You're very welcome to dive into code and try.https://github.com/Gnucash/gnucash/pull/229 will be a good place to start research.
On Thu., 17 Jan. 2019, 10:24 David T. <[hidden email] wrote:

Chris,
While I understand and respect the goal of backward compatibility, I'll point out that your changes to this report have already broken backward compatibility, as evidenced by my original example.  Settings which worked previously yield meaningless results now, and I have had to go through every one of my reports that are based on the transaction report and fix what got broken. 
For my use case (not all that exotic, IMHO), the setting appears to be broken; when transactions are shown, are you saying the transactions are reversed, but the totals are not? Because that would drive me crazy...
Is there truly no way to store and calculate values internally to the report but display results the way the user requests to see them?

David
 
 
  On Thu, Jan 17, 2019 at 7:13, Christopher Lam<[hidden email]> wrote:   Sadly, the gnucash project has a long history of never removing features.
The amount sign reversal is still functional for the transactional amounts. Only the subtotals are unaffected.
On Thu., 17 Jan. 2019, 09:08 D <[hidden email] wrote:


Then why include the option? It no longer does anything, except imply to the user that they have control over something they Nik longer can control.

David


On January 17, 2019, at 6:27 AM, Christopher Lam <[hidden email]> wrote:


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 -$50Income $100Expense $50Grand 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 -$50Income -$100 (subtotal negative)Expense $50Grand total $0
On Thu., 17 Jan. 2019, 00:34 David T. <[hidden email] 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 <[hidden email]> 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 <[hidden email]> 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 .



 

 
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

Adrien Monteleone-2
In reply to this post by GnuCash - User mailing list
It seems the Balance sheet honors the setting, but using the ’None’ option in Preferences produces a disconcerting result.

With the option set to Credit Accounts, all amounts (normally balanced) are positive.

With the option set to None, the Liability and Equity line items are negative, but with positive totals!

So I would guess it is possible to honor the setting, but using ’None’ might produce an odd looking report. From your description, it seems the Transaction Report is effectively choosing ’None’ for the user.

Regards,
Adrien

> On Jan 16, 2019, at 8:24 PM, David T. via gnucash-user <[hidden email]> wrote:
>
> Chris,
> While I understand and respect the goal of backward compatibility, I'll point out that your changes to this report have already broken backward compatibility, as evidenced by my original example.  Settings which worked previously yield meaningless results now, and I have had to go through every one of my reports that are based on the transaction report and fix what got broken.
> For my use case (not all that exotic, IMHO), the setting appears to be broken; when transactions are shown, are you saying the transactions are reversed, but the totals are not? Because that would drive me crazy...
> Is there truly no way to store and calculate values internally to the report but display results the way the user requests to see them?
>
> David
>
>
>  On Thu, Jan 17, 2019 at 7:13, Christopher Lam<[hidden email]> wrote:   Sadly, the gnucash project has a long history of never removing features.
> The amount sign reversal is still functional for the transactional amounts. Only the subtotals are unaffected.
> On Thu., 17 Jan. 2019, 09:08 D <[hidden email] wrote:
>
>
> Then why include the option? It no longer does anything, except imply to the user that they have control over something they Nik longer can control.
>
> David
>
>
> On January 17, 2019, at 6:27 AM, Christopher Lam <[hidden email]> wrote:
>
>
> 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 -$50Income $100Expense $50Grand 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 -$50Income -$100 (subtotal negative)Expense $50Grand total $0
> On Thu., 17 Jan. 2019, 00:34 David T. <[hidden email] 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 <[hidden email]> 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 <[hidden email]> 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 .
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Transaction Report Preference missing?

Christopher Lam
In reply to this post by GnuCash - User mailing list
It's fine to make recommendations. During the transaction upgrade I
remembered some wishlist items and was able to implement them.

The limitations for reversing subtotals stem from the fact that subtotal &
grouping is not limited to account types, but can also be organised by date
and other keys. And to try establishing a reversing strategy for these keys
is an exercise in futility and it was safer to just disable subtotal
reversals. Hence the "recommended" amount display is now dual column
debit&credit which is works well.

On Thu., 17 Jan. 2019, 10:49 David T. <[hidden email] wrote:

> Chris,
>
> Thanks for the offer, but readers of these lists over the years can vouch
> for my utter inability to contribute meaningfully to any code. That's why
> I've tried to contribute to the documentation (although to be truthful,
> even that is a stretch).
>
> I apologize for suggesting tasks for you to do, and I will attempt in the
> future not to make that mistake again. It's too bad the transaction report
> will continue to have these problems for the foreseeable future. I'll try
> and figure out some way to document its quirks on the wiki, so that people
> may be made aware of them and work around them.
>
> David
>
>
> On Thu, Jan 17, 2019 at 8:04, Christopher Lam
> <[hidden email]> wrote:
> I don't know, sorry. You're very welcome to dive into code and try.
> https://github.com/Gnucash/gnucash/pull/229 will be a good place to start
> research.
>
> On Thu., 17 Jan. 2019, 10:24 David T. <[hidden email] wrote:
>
> Chris,
>
> While I understand and respect the goal of backward compatibility, I'll
> point out that your changes to this report have already broken backward
> compatibility, as evidenced by my original example.  Settings which worked
> previously yield meaningless results now, and I have had to go through
> every one of my reports that are based on the transaction report and fix
> what got broken.
>
> For my use case (not all that exotic, IMHO), the setting appears to be
> broken; when transactions are shown, are you saying the transactions are
> reversed, but the totals are not? Because that would drive me crazy...
>
> Is there truly no way to store and calculate values internally to the
> report but display results the way the user requests to see them?
>
> David
>
>
> On Thu, Jan 17, 2019 at 7:13, Christopher Lam
> <[hidden email]> wrote:
> Sadly, the gnucash project has a long history of never removing features.
>
> The amount sign reversal is still functional for the transactional
> amounts. Only the subtotals are unaffected.
>
> On Thu., 17 Jan. 2019, 09:08 D <[hidden email] wrote:
>
> Then why include the option? It no longer does anything, except imply to
> the user that they have control over something they Nik longer can control.
>
> David
>
>
> On January 17, 2019, at 6:27 AM, Christopher Lam <
> [hidden email]> wrote:
>
>
> 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. <[hidden email] 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 <
> [hidden email]> 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 <[hidden email]>
> 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 .
>
>
_______________________________________________
gnucash-user mailing list
[hidden email]
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.