One account I checked in detail has no children. In the report, it shows as VOO The only account with that name is a trading account. The corresponding stock investment account is Vang 500 ETF The account has two buys and two sells in 2023 with a net of zero. I am doing a Balance Sheet for today. I believe that most (if not all) of the zero lines are for stocks that have been sold and have no children accounts.
If I run a report with default level of 3, but check Flatten list to depth limit, then the zero lines in the report go away. On Thu, Jun 20, 2024 at 3:54 PM Michael or Penny Novack < [email protected]> wrote: > On 6/20/2024 10:03 AM, Fred Tydeman wrote: > > Fedora Linux 37 > > GnuCash 4.14 > > > > Doing Reports: Assets&Liabilities: Balance Sheet > > In the Options: Display: > > I uncheck Include accounts with zero total balances > > I check Omit zero balance figures > > > > If I take the default of 3 Levels of subaccounts > > the report has lots of lines with zero amounts. > > > > If I change the Levels of subaccounts to All, > > then the zero entries go away. > > > > Seems wrong. > > I'm not so sure wrong. Let me ask you a question > > These accounts that appear (even though showing zero) at a small number > of levels but that disappear then the nesting level is increased enough > to expand the entire tree ........ Do they have children that are not > appearing because of level truncation. > > Consider THIS situation << where truncation is set so that only Account > X shows >> > > Account X (balance 0) > > Account Y (balance debit 10) > > Account Z (balance credit 10) > > In other words, I might want to see an account whose balance is zero IF > it has children (being truncated) with non-zero balances. I'd at least > want to think about it some before deciding show vs don't show. And > possibly any situation where the children COULD BE non-zero. In other > words, is the "exclude zero" not working as you expect because because > truncation of levels means the report can no longer "see" if below there > all zero or not. > > Michael D Novack > > > > > > > > > > > > _______________________________________________ > gnucash-user mailing list > [email protected] > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > 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 [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
