[GNC] Report seems to pull wrong amount from transaction

[Adrien Monteleone]

Art, you’re welcome and I’m fine with just list messages. I’m glad you got it resolved. (just curious, is this a custom report?)

The price db *should* get a ’transaction’ type entry for every such buy/sell transaction. You might need to have trading accounts turned on for that, I’m not certain. If you already do, then, you might have a bug.

I track some metal holdings and while I don’t do trades often, I have transaction type entries in my price db. I haven’t done any transactions since probably v3.5 or so. Maybe there is a code regression since then.

Regards,
Adrien

> On May 13, 2020 w20d134, at 9:15 AM, Art Chimes <artsonline at gmail.com> wrote:
> 
> Sorry Adrien, I should have sent a personal copy to you, too. Thanks
> for your help on this.
> 
> ---------- Forwarded message ---------
> From: Art Chimes <artsonline at gmail.com>
> Date: Wed, May 13, 2020 at 10:13 AM
> Subject: Re: Report seems to pull wrong amount from transaction
> To: Gnucash Users <gnucash-user at gnucash.org>, D. <sunfish62 at yahoo.com>
> 
> 
> I think D. wins this round. Not exactly the right answer, but close
> enough that it pointed me to the explanation. I hope you'll forgive
> the longish explanation that follows.
> 
> My report apparently uses the number of shares x the price per share
> to compute the dollar amount. Possibly the dollar value of the
> transaction is not stored in the user's data file but rather is
> computed on the fly? The incorrect dollar figure in the report was the
> product of the correct number of shares times an incorrect share
> price. But the share price in the account register is correct. So
> where is the incorrect share price coming from?
> 
> The account from which the withdrawal was made is not a publicly
> traded fund but is a pension plan, so there is no way (that I know if)
> to retrieve the share price automagically. By force of habit, from my
> Quicken days, I enter each week's closing share prices into the Price
> Database. So Jan. 24 and 31, Fridays, are in there, but not the day of
> this transaction (Wednesday, Jan 29).
> 
> That's a bit of a puzzle. I though that if I entered a transaction
> into an account register, it would appear in the Price Database. Maybe
> because I didn't enter the price manually and it was computed from the
> dollar value and number of shares that I did enter? Anyway, there was
> no entry for for Jan. 29.
> 
> Anyway, I quickly determined that the incorrect dollar amount entered
> was the result of multiplying the number of shares times the share
> price on Jan 31 — the closest date in the Price Database. I manually
> added the correct share price for Jan. 29. And now the report has the
> correct dollar amounts.
> 
> Problem solved. But I wonder if I should file an enhancement request
> that reports using a calculated value based on a close but not exact
> share price should be flagged (with an asterisk and footnote?) as
> questionable.
> 
> Thanks all who chipped in to help solve this mystery Great community here!
> 
> Art