[GNC] Need help locating transaction(s) in advance portfolio

[Kalpesh Patel]

I was able to flag it down using Geoff's suggestion of binary divide and conquer method, although it took some time -- I wish there was a way to select/unselect multiple accounts by clicking on the parent account rather than individual ones without losing all the other ones selected but .... 

It is interesting case though. It was in a money market (MM) account with a brokerage with two entries for the same day: first was the purchase of the funds followed by a transfer of the same amount from another account to balance out. The MM account was already zero and since the purchase transaction came first it went to negative quantity and then the transfer of funds into the account set it back to zero amount. This transactions were imported ones.

Since this was a MM account, I was able to change the date to reorder the transactions since MM account normally do not deviate from a buck. But I would love to hear what is one to do if this was a transaction of a commodity where date is material and you want to change the order of transactions so that this condition does not arise.  

-----Original Message-----
From: Fred Tydeman <tydeman.fred at gmail.com> 
Sent: Saturday, February 15, 2025 11:23 AM
To: Kalpesh Patel <kalpesh.patel at usa.net>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Need help locating transaction(s) in advance portfolio

I had this happen recently.  It was caused by the order of deposits / withdrawals in my cash account on the same day.
I excluded that account from the report and it worked ok.


On Thu, Feb 13, 2025 at 11:47 PM Kalpesh Patel <kalpesh.patel at usa.net>
wrote:

> I am running Advance Portfolio report and I noticed it display 
> following error message at the top:
>
>
>
> There is an error processing the transaction 'buying XXXX.XXXX share 
> units'.
> This may to 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.
>
>
>
> I was hoping to track down this (these) transaction(s) which are in errors.
> I don't remember doing this for an account but I have not founds how 
> to locate these specific transactions. Any idea how to go about 
> finding it? Is the value error referring to one specific transaction? 
> I am hoping to avoid going through each and every investment account 
> manually which I don't even know how to do that given that the value 
> given in the error message could possibly be from variable number of 
> additions and subtractions in an account.
>
>
>
> Any help is welcome. Thanks.
>
> _______________________________________________
> 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.
>