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