Reports and prices
Steve Kelem
steve at kelem.net
Thu Jan 11 18:32:27 EST 2007
I'm running gnucash 2.0.4 on SuSE linux.
I'm having trouble getting a report to come out with accurate information.
I have the following account hierarchy (names changed to protect the
innocent):
Assets
+-Current Assets
+-Fixed Assets
+-Investments
+-Brokerage
+-Fezziwig
+-Mutual Fund
+-Stock
+-Stryker Drilling
In the Stryker Drilling account I have one transaction:
1999-03-19
Xfr Assets...Stryker Drilling 75 shares 23.6875 1,776.56
Retained Earnings 1,776.56
1
The Price Editor shows only two entries for Stryker Drilling:
NASDAQ/STRK USD 2007-01-11 Finance::Quote last 29.400000
NASDAQ/STRK USD 1999-03-31 user:price-editor last 22.500000
I then created a Balance sheet report for Fezziwig that includes
Fezziwig and all of its sub-accounts.
The report's currency is USD. The price source is "Most Recent" (or
"Nearest in Time", it doesn't make a difference.)
Under Balance Sheet/Display, I checked all the boxes except "Include
accounts with zero total balances".
The Balance Sheet Date is set to 1999-03-31.
The resulting report shows
Stryker Drilling 75 STRK $2,205.00
But this is not correct! 75 shares times $22.5/share is $1,687.50.
$2,205 reflects the price in 2007 ($29.40), not the 1999 price!
How do I get the report to reflect the most recent (i.e., less than or
equal to the date for the report) quotes?
Thanks,
Steve
More information about the gnucash-user
mailing list