Lot Sales Calculation Errors

[Mike C.]

On 2/6/2011 11:42 AM, David T. wrote:
>
> --- On Sun, 2/6/11, Mike C. <subscribe307 at verizon.net> wrote:
>
>> From: Mike C. <subscribe307 at verizon.net>
>> Subject: Lot Sales Calculation Errors
>> To: gnucash-user at gnucash.org
>> Date: Sunday, February 6, 2011, 8:59 AM
>> I have been using the "view lots" to
>> calculate the FIFO gains/losses for
>> investment sales and find that I can no longer expect the
>> calculations
>> to be valid.  I set up a dummy file to try to
>> understand the problem and
>> found that if a correction is made in a sale, then the lot
>> calculations
>> are invalid. 
> Wow. Can you explain "invalid" in a little more detail? And what steps are you taking to create the problem? A step-by-step description of the steps you took is needed.
By invalid I mean that the total gain/loss is incorrect.  There is not a
problem if you enter sales in chronological order and don't change any
later.  If there is a change it seems to calculate the lot in the wrong
order.  I made a change in lot 4 (the latest) and the view lots
calculation showed that lot closed (all sold) and lot 2 (an earlier lot)
still open (not sold).  This happened even when I deleted lot 4 and its
related gain/loss completely and reentered.  At least for the present I
am using a spreadsheet to calculate FIFO gain/losses and so far out of 5
securities that were sold only one was calculated correctly and it was
one with only one sale.
I really like GnuCash and hope this problem can be fixed or at least
explained  so we know how to avoid errors.
Mike
> I was just looking at the View Lots/Scrub Lots feature as a real saving grace, since I was having such trouble understanding the whole calculate gains thing. If it's wrong, folks should definitely know!
>
> I have noticed that once a lot is calculated, there seems to be no modifying it; perhaps this is related? I was not prepared to delete everything in the transaction history, but would if it became necessary. Bummer!
>
> David
>  This is the case even if you delete all
>> the gain/loss
>> transactions and the sale that was changed.  The only
>> way to fix the
>> problem is to delete all sales of that security and start
>> over with all
>> sales transactions.  Also at times when you open and
>> close the view lots
>> a new gain/loss transaction is added to the register for
>> some unknown
>> reason.  I haven't determined exactly what keystrokes
>> causes this to
>> happen.  I am using version 2.4 on Windows XP.
>> I hope this can be fixed soon since calculation errors are
>> the worst
>> problem because you don't know when it is happening.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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.
>>
>
>       
>