[GNC] Balance Sheet mismatch

[davidcousens49 at gmail.com]

Fred,

The price database is stored in your main datafile for the set of books. You can
edit it from the Tools->Price Database  in the menu.

David Cousens
On Thu, 2022-06-02 at 21:50 -0700, Fred Tydeman wrote:
> 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.
> > 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.