David, I could be misunderstanding the option, but I think it is just a visual representation in the registers and on the COA.
Apparently, reports are their own beast and it is incumbent upon report writers to honor the setting. There’s a thread or two floating around in the last few months about the budget report not honoring it, at least consistently and I’ve seen others here and there. I just tested the Income Statement, and sure enough, while the income figures show as negative when the option is set to ’none’ the Income Total is positive and so is Net Income for Period. So even within that report, it’s not consistent.(on that note, why do we have BOTH Income Statement *and* Profit & Loss reports if they are the same thing? Certainly, anyone can change a title in the options) I would think a thorough going over of each report is long over due. And that’s something we users can tackle. Perhaps we can start a project here where we volunteer to test a particular issue with *each* report and then compile a list of what needs to be fixed, we file bug reports, and then those of us that have Scheme skills can tackle the work while the regular devs deal with their regular app code. I’ve seen enough discussion on this list about reports to think such an approach would be useful. (the reason why I say *each* report is it is probably easier to test every report for say, just honoring the sign reversal setting, or just calculating balances/totals properly, than to check a single report for everything. That way, a volunteer will check ALL reports for their one chosen issue and report back which need attention if any. Otherwise, if we each adopted a report to check in *its* entirety, some reports might not get checked at all) Some already identified issues to check: * Properly and consistently honoring the sign reversal setting * Correctly reporting account balances * Correctly reporting totals from displayed report figures * Correctly deriving figures based on displayed report figures * Playing nice and consistent with stylesheets * Report option arrangement & grouping. * Report options functioning as expected. * RFEs concerning useful options that might be missing. I’ll be happy to take on #4 as I’m already working on it prompted by a bug discussion concerning the unrealized gain/loss figure. (This same issue might also prompt a useful RFE to hide that figure on certain reports if one doesn’t need/want it shown) I’d hope a dev will chime in here. Maybe the best route is to file a set of tracker bugs, one for each of the above, and then link individual report bugs as they are found. I’m sure that approach will be more productive than an ad-hoc project conducted via the list. Or is there another mechanism I’m not thinking of? Any takers? Thoughts? Regards, Adrien p.s. - another major issue with reports, for myself, and from what I can see by the questions people ask, is with respect to discoverability. It isn’t that GnuCash can’t report what you are looking for, just that you might have to jump through several hoops of non-obvious options and workflows to get there. That’s an entirely separate project but one that I think would benefit us all greatly, especially the newcomers, and it would I think, make GnuCash be and appear as useful as it is and much less intimidating. > On May 6, 2018, at 10:53 AM, David T. <sunfis...@yahoo.com> wrote: > > 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.montele...@lusfiber.net> wrote: >> >> >> >>> On May 3, 2018, at 3:40 AM, Christopher Lam <christopher....@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.montele...@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@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@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@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@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.
