[GNC] GC 3.1 Mac OS X 10.13.4 High Sierra Report issue

Sun May 6 11:53:27 EDT 2018

Sorry I’ve been delayed in responding.

I’ll try to reply to the various suggestions.

Adrien: The COA is perfectly fine, except that it’s not possible to embed the one figure in a multi-column report, so that doesn’t work for me.

As for what I had in 2.6.19, I included verbatim what I have had in the past in my original post. You’ve got it right there, and it’s what I’d hope to see after upgrading. Chris, your settings are closer to what I might live with—but I will note that this might work for me only because I have my dividend income accounts aggregated by brokerage—users who might have a different structure might not appreciate this. 

It doesn’t address the reversed values, though.

Another reply commented that the issue of the negative listing for income was somehow wrong—if that’s the case, then why offer the setting to "Reverse Income and Expenses” at all? If you have an option, it should actually do what it says, IMHO. And this setting does nothing. Fix it, or remove it. Fixing it would at least make it consistent with the other settings in the application.

David

> On May 3, 2018, at 9:47 PM, Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:
> 
> 
> 
>> On May 3, 2018, at 3:40 AM, Christopher Lam <christopher.lck at gmail.com> wrote:
>> 
>>> In general, the result is as follows:
>>> YTD Dividends
>>> From 01/01/2018 to 05/02/2018
>>> ————
>>> Grand Total $9,999.00
>> 
>> I don't really have a problem generating something similar to the above...
>> Accounts/Accounts = Income:Dividends, Sorting/Primary Sortkey = 'account',
>> Secondary Sortkey='none', Sorting/Show subtotals only = true, General/Dates
>> = ‘beginning-of-year' to 'today' - these options would be a good start.
> 
> Not sure about you, and David would need to clarify, but when I choose those options I’m still seeing the sub-accounts. (or even just a single account if that’s what I select) I *think* (as you note below) he only wants to see the grand total. As I pointed out in my first reply, that number is available on the Accounts tab, but I suppose if someone wants to see it in a ‘dashboard’ type report, that wouldn’t work.
> 
>> 
>>> I do see the option ‘Show subtotals only (hide transactional data)’ in
>> the sorting tab (shouldn’t this belong in ‘display’?) but I don’t see an
>> option to hide the per-account sub-totals.
>> 
>> Hmm it could belong in 'Display' tab... this option was meant for the
>> Sorting tab as an extension to the subtotal grouping options (especially
>> daily date subtotals) and is currently *only* selectable if subtotals are
>> generated, but apparently some wish to hide *everything* (and any
>> subtotals) except the "Grand Total". How odd... This would require a few
>> amendments to TR. If this is moved to the Display tab, it should toggle
>> most other Display options too...
> 
> I see. I chalk this up to the options window itself. I’ve always found some of the choices of why options are where they are or what they affect in conjunction with other options somewhat less than clear or intuitive. This could be due to the fact that within a tab, there is no clear grouping of options. I see Gtk has a List Box container which might be very helpful here. (their example image in the widget gallery looks like an options/preferences use case) Alternatively, a simple Frame would set the options apart and group them together.
> 
> At present, that option (and the other checkboxes above it) just looks like it’s on the same ‘level’ as the rest of the sorting options which begs the question.
> 
> Regards,
> Adrien
> 
> 
>> 
>> On 3 May 2018 at 03:11, Adrien Monteleone <adrien.monteleone at lusfiber.net>
>> wrote:
>> 
>>> David,
>>> 
>>> I haven’t noticed this case in particular but do see some other unique 3.1
>>> report problems. (filed a bug on one a couple of days ago) But since you
>>> mentioned other approaches, does not turning on the Total (Period) column
>>> on the Accounts tab not give you the info you’re looking for? I have this
>>> turned on and since totals roll-up to the parent, it shows me what I would
>>> expect to see if I ran such a report as you describe.
>>> 
>>> I just played with the Transaction Report and I also can’t get the
>>> individual sub-accounts to not display. But that might be intended. If I
>>> only select the parent, and run a *Transaction* report, I get nothing,
>>> because well, there are no transactions in it. I have to select the child
>>> accounts that hold the actual transactions. And that is what is being
>>> subtotaled. The “Totals” option appears to only sum all of the individual
>>> accounts. (or not) I don’t think it should mean to ONLY display that total.
>>> If it used to function that way, I should think it was a bug that has now
>>> been fixed.
>>> 
>>> I do see the option ‘Show subtotals only (hide transactional data)’ in the
>>> sorting tab (shouldn’t this belong in ‘display’?) but I don’t see an option
>>> to hide the per-account sub-totals.
>>> 
>>> Regards,
>>> Adrien
>>> 
>>>> Hello,
>>>> 
>>>> Before I submit a bug report, I’d like to see whether there has been
>>> some change to the reports system that causes the degradation I am seeing,
>>> and if there is a different way to achieve my same goal.
>>>> 
>>>> I have a custom report that is set to display a single figure for YTD
>>> totals for a subset of my income accounts (dividends). This is a simple
>>> transaction report that has the Income:Dividend accounts selected, is set
>>> to cover the current accounting period, and is supposed to display only
>>> “Totals”.
>>>> 
>>>> In general, the result is as follows:
>>>> 
>>>> YTD Dividends
>>>> From 01/01/2018 to 05/02/2018
>>>> ————
>>>> Grand Total $9,999.00
>>>> 
>>>> In the past, this report would present the current YTD dividend total in
>>> a single figure in a compact area (I use it on a dashboard multicolumn
>>> display). With 3.1, however, I get all the accounts listed, and no figures
>>> anywhere (not for individual accounts, and not for a grand total).
>>> Furthermore, if I try to load the saved report separately, I get a generic
>>> “Report Error” message. If I close out GC 3.1 without saving and reload the
>>> file in 2.6.19, the report functions as expected.
>>>> 
>>>> Finally, if I try to recreate the report from scratch, I cannot get the
>>> report to format as I prefer—with no account information and a single YTD
>>> amount. I can only seem to get the total if I display all the transaction
>>> data, which defeats the purpose of my report showing me at a glance how
>>> much dividend income I have accumulated YTD.
>>>> 
>>>> Has anyone encountered this problem and found a remedy?
>>>> 
>>>> While I am at it, I note that the report setting to reverse account
>>> signs on the transaction report doesn’t seem to affect the total amount any
>>> more—it worked correctly in 2.6.19. ISTR that others have noted this—or
>>> does that need to get a bug as well?
>>>> 
>>>> Cheers,
>>>> 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.