[GNC] v4.2 report numbers change over gnucash restarts; Price Database dropping user:price-editor entries.

[John Ralls]

> On Oct 16, 2020, at 10:15 PM, Phil Diacono <satphil at gmail.com> wrote:
> 
> Hi team,
> 
> I have a vague recollection something like this happened a few years ago
> but it was just a display issue, restarting gnucash would display the
> seemingly missing manually added currency conversion rate.
> 
> However with v4.2, I'm actually seeing the added conversion rate for the
> end-of-financial-quarter date being lost after a restart of gnucash.
> What's more conversions in reports with settings "nearest" are now
> pulling in an entry from a different date (since the eofq date has
> disappeared), so the reports' numbers have changed between gnucash sessions!
> 
> Eek!
> 
> Procedure:
> 
> Example report: Balance Sheet, options -> commodities -> Price Sourcec:
> Nearest in time and tick "Show Foreign Currencies" and "Show Exchange
> Rates".
> 
> Line item for Paypal-USD reads:
> US$898.50   A$1,1239.99  (= exchange rate of 1.380067, presumably taken
> from an existing 10 Oct 2020 Price Database entry 1.380063)
> 
> Define exchange rate for end-of-financial-quarter:
> Tools -> Price Database -> Currencies -> USD (US Dollar) -> Add ->
> Namespace: Currencies
> Security: USD (US Dollar)
> Currency: AUD (Australian Dollar)
> Date: 30/09/20
> Type: Last
> Price: 1.39638
> OK
> 
> Reload Balance Sheet Report:
> 
> Line item for Paypal-USD now reads:
> US$898.50   A$1,254.65   (= exchange rate of 1.396383 matching the 30
> Sep 2020 entry we manually put into Price Database)
> 
> So far so good.
> 
> Exit gnucash. Re-enter gnucash.
> 
> Line item for Paypal-USD now reverted to:
> US$898.50   A$1,1239.99
> 
> Price Database entry for 30 Sep 2020 now missing (even after sorting on
> date column)! Report number changed over gnucash restart!
> 
> Anyone else seeing this?
> 
> Config details:
> Running Ubuntu 20.04.1 LTS on x64.
> Gnucash Version: 4.2
> Build ID: 4.2+(2020-09-26)
> Finance::Quote: -
> It was built using cmake and uses a SQLite 3.x database backend:
> libdbd-sqlite3:amd64    0.9.0-8ubuntu1
> libsqlite3-0:amd64      3.31.1-4ubuntu0.2
> libsqlite3-dev:amd64    3.31.1-4ubuntu0.2
> 

I'm able to reproduce the problem with losing prices, but only with the SQL backend. It works as expected for me on the XML backend.

Regards,
John Ralls