[GNC] Balance Sheet mismatch

[Fred Tydeman]

I have made a test file with just two transactions:
  Opening Balance in GBP on 3/13/2011
  xfer and convert to USD 1/1/2016
So, those two transactions put two entries in the Price database for GBP.
I then added a third price between those two dates on 1/11/2013
The Balance Sheet shows a mismatch if run on 1/11/2013 or any date after
that date
but is OK if run on 1/10/2013 or any date earlier
The value of the GBP (reported in USD) is changing in the Assets section of
the report,
but the Equity section is remaining constant.
Should the Equity section show an Unrealized gain/loss?
This looks like a bug to me.  I am not sure how to report, or what is
needed.
The test2.gnucash file is around 5000 bytes small
Now sure where the Price history is kept, nor the Report options.



On Wed, Jun 1, 2022 at 7:56 AM Fred Tydeman <tydeman.fred at gmail.com> wrote:

>
>
> On Wed, Jun 1, 2022 at 6:45 AM Fred Tydeman <tydeman.fred at gmail.com>
> wrote:
>
>> I am now trying going back in time to see when the first imbalance starts.
>> How do I get a list of transactions in a specific date range?
>> Is there a way to find stock/mutual fund prices of zero(0)?
>>
>
> First mismatch happens back in 2012.
> It appears that using Report Options / Commodities / Price Source of
> Closest to report date   is a problem when the date of the report
> is between two dates of a Foreign currency exchange rate in Price Database.
> However, that is not the only problem, as now using
> Last up through report date for Commodities, I get a mismatch
> when the Balance sheet report is the same date as a Price Database entry
> of a foreign currency.
>