[GNC] $0 total balances wrongly appearing on Balance Sheet.

[John Ralls]

I'd go for the second. Account balances are on amounts (i.e. shares if that's what the account commodity is) and AFAIK nothing in the account code looks at split values.

Regards,
John Ralls


> On Jul 27, 2020, at 10:24 AM, David Carlson <david.carlson.417 at gmail.com> wrote:
> 
> I am curious.  Is it possible for this behavior to occur if
> 
> 1) a commodity account has a balance of zero shares but a residual value
> because it has a unrealized gain or loss.
> 
> 2) a commodity account actually has a tiny share balance or residual value
> below the threshold visible at the account display resolution, likely due
> to rounding errors in transactions.
> 
> David Carlson
> 
> On Mon, Jul 27, 2020 at 12:12 PM Adrien Monteleone <
> adrien.monteleone at lusfiber.net> wrote:
> 
>> Sorry, the report appears to be working correctly for me on MacOS
>> (10.15.6) using GnuCash 4.1.
>> 
>> The 1st option should be the only one you need to toggle the zero
>> balanced accounts from appearing.
>> 
>> The 2nd option will remove just the zero figure but retain the account
>> name if the 1st option is checked.
>> 
>> Let's use an example where 'Cash' has a 0.00 balance,
>> 
>> 
>> If you uncheck both options you'll see:
>> 
>>        Cash 0.00
>> 
>> If 1st option is unchecked, second option checked, you'll see:
>> 
>>        Cash
>> 
>> If 1st option is checked, the second option is now irrelevant, and
>> you'll see nothing about 'Cash' at all.
>> 
>> Or at least that is the way I think it is supposed to work.
>> 
>> Regards,
>> Adrien
>> 
>> On 7/27/20 11:01 AM, peterb wrote:
>>> I've encountered a bit of a Scooby Doo mystery, and I'm hoping someone
>> can
>>> help me figure it out.
>>> 
>>> My Balance Sheet report consistently includes commodity accounts with 0
>>> balance figures for me, even when I've unchecked "Include accounts with
>>> zero total balances."  Trying to reproduce this with a brand-new book for
>>> demo purposes doesn't show this behavior, so I'm left assuming there's
>>> something about my file that is odd.
>>> 
>>> Specifically, there are two options under "Display" for Balance sheet, to
>>> wit:
>>> 
>>> • Include accounts with zero total balances
>>> • Omit zero balance figures
>>> 
>>> I would expect that having the first option UN-checked and the second
>>> option checked would result in my stock accounts with 0 shares in them
>>> appearing; sadly, they're all over the report.
>>> 
>>> In contrast, the "Balance Sheet using eguile-gnc" report has an option
>>> (under "Accounts", not "Display" this time) of "Exclude accounts with
>> zero
>>> total balances".  Checking this option achieves what I'd consider the
>> right
>>> result - no zero balance values are shown.
>>> 
>>> After further experimentation, there seems to be an interaction with the
>>> "Levels of Subaccounts" control on the Accounts tab of the report
>> options.
>>> If I increase the levels of subaccounts accordingly, or flatten the list
>> to
>>> the depth limit, the 0 balance figures don't appear - again, only (so
>> far)
>>> in this one file.
>>> 
>>> So I have two workarounds to the problem (either using the eguile report,
>>> or adjusting the depth limit/flattening options), but I am still
>> concerned
>>> that I don't understand why the behavior is happening in the first place.
>>> 
>>> My questions are:
>>> (1) Has anyone else seen this behavior?
>>> (2) If so, do you understand what's triggering it?
>> 
>> _______________________________________________
>> 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.
>> 
> 
> 
> -- 
> David Carlson
> _______________________________________________
> 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.