[GNC] Reported negative stock balance preventing Report generation

[Megan Tilley]

Thanks, David - your comment prompted me to reexamine a previously entered
Mutual Fund that was moved to Stock/Share status (ie from fund to
exchange), and I found I had missed a step in the creation of the security.

I am now able to generate my report!

Thanks!


Megan in Sydney

*GnuCash*
*Version: 5.8*
*Build ID: 5.8+(2024-07-06)*
*Finance::Quote: 1.62*

*Windows 10 Home*
*Version: 22H2*
*OS Build: 19045.5011*




On Sat, 31 May 2025 at 11:31, David H <hellvee at gmail.com> wrote:

> Megan,
>
> Have you tried doing Ctrl-F in the Accounts Register, changing the search
> type to Description, memory, whatever (I forget the exact name) and putting
> in the txn description in the search target field? I guess that should find
> it for you?
>
> Cheers David H
>
>
> On Sat, 31 May 2025, 10:15 am Megan Tilley, <megan.tilley at gmail.com>
> wrote:
>
>> I fear I am going around in circles.
>>
>> Since beginning with GnuCash in June 2024, I have learned a great deal
>> about how to manipulate the program to represent my financial situation
>> accurately.
>>
>> I have a list of stock/shares across 3 different Registries (companies
>> managing stock/shares) here in Australia.
>>
>> I have entered my holdings manually and also by using Stock Assistant.
>>
>> I have two reports that I use - the Investment default report from GNUcash
>> and a manually created (not a default report in GNUcash, if I remember
>> correctly), I call Advanced Portfolio.
>> The report parameters for Advanced Portfolio are:
>> 1) Accounts - All investments listed under the 3 registries, including
>> Mutual Funds and Stock/Shares
>> 2) Display - show ticker, listing, total shares, 3 decimal places, prices
>> 3) General - Date: today, Currency: AUD, price source nearest to report
>> date, basis calc - average all shares, set preference for price list
>> ticked, Include brokerage fees in basis.
>>
>> I use this Portfolio Report in conjunction with the default GNUcash
>> Investment report, and have done so from the start (June 2024) with no
>> issue/problem, quite successfully.
>>
>> Recently, there have been some movements (buys and sells), which I have
>> tracked using the Consignment Note (C/N) issued by my stockbroker.
>>
>> The C/N shows the number of units, price per unit and total for the
>> transaction. Brokerage fees and GST are added as separate values as a
>> subtotal on the C/N. I insert the unit total value against the stock line,
>> and the total of the C/N, including Fee/GST, is the amount against my cash
>> account.
>>
>> I now have an error report on my manual Advanced Portfolio report stating
>> -
>> "There is an error processing the transaction 'buying .0300 share units'.
>> This may be caused by a sell transaction causing a negative stock balance,
>> and a subsequent buy transaction causing a zero balance. This leads to a
>> division-by-zero error. It can be fixed by preventing negative stock
>> balances."
>>
>> My two questions:
>> a) How do I locate this "buying .0300 share units" in my investments?
>>
>> I have examined my entire list of investments and focused on the recent
>> changes and see no such value of .0300 share units. I believe such an
>> error
>> would show in the Account list/Investment section, as I have seen negative
>> stock/share amounts in the past that I have corrected and which have
>> disappeared from the Account list/Investment section after the correction.
>>
>> b) How do I manipulate my Advanced Portfolio parameters to ignore this
>> 'condition' so I can see the other investments?
>>
>> Thank you,
>> Megan in Australia
>> 2025-05-31 1010hrs
>>
>>
>> *GnuCash*
>> *Version: 5.8*
>> *Build ID: 5.8+(2024-07-06)*
>> *Finance::Quote: 1.62*
>>
>> *Windows 10 Home*
>> *Version: 22H2*
>> *OS Build: 19045.5011*
>> _______________________________________________
>> 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
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>