[GNC] Transaction Report Advance Portfolio - Options - Account List

[john]

> On May 7, 2023, at 1:17 AM, Martin Booth via gnucash-user <gnucash-user at gnucash.org> wrote:
> 
> 
> I am running GNUCash - 5.1 flatpak on debian 11.I have been using GC for 15years now and the Advance Portfolio report does not list all the COA or highlight the selected accounts the report is based on unlike earlier versions > 4.xx. This also applies to the investment portfolio report
> 
> Selecting Reports>>Assets & Liabilities>>Advance Portfolio>> report runs fine
> I want to change this report so that I can run the report from each investment broker selected from COA. 
> 
> Selecting Reports>>Advance Portfolio>>options>>accounts
> It fails to list all the COA, it only lists Assets and the sub accounts under this e.g. fixed assets and current assets and I have retirement assets but not list my investment assets .
> It also does not list which accounts the report is based on and it fails to show equity, expenses or liabilities as previous versions of GC.
> Therefore I cannot select/filter the report by investment broker as previous GC versions.
> I ran my report on GC 4.13 and I can create and amend the report with all COA listed in the default Advanced Portfolio options (GC 4.13 running my VM), but the current release 5.1 does not show all the accounts and it cannot be modified. 

As part of rewriting the options code I fixed a bug in the Advance Portfolio Report: The accounts presented for selection are filtered to Asset, Stock, and Mutual Fund, and the default selection is all accounts of type stock and mutual fund. Makes sense, right? It had been in the report code all along but the implementation of the account option tree view didn't work right so you got the whole CoA. Now it works. Great, right? Not quite. The problem is that the accounts page in the options does a recursive search and it filters out parent accounts that aren't one of those types so if you have stock accounts under, for example, a Bank account they won't display on the selector. The initial query that loads the report does the filtering only on the leaf accounts so it gets all of the stock and mutual fund accounts, but if you open Options the GtkTreeView drops them--even if you don't visit that page on the options dialog.

This was first reported in https://bugs.gnucash.org/show_bug.cgi?id=798796

Regards,
John Ralls