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


Regards


Phil
---

John Ralls has noted: "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.
"