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 <[email protected]> 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, <[email protected]> > 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 >> [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.
