> On Oct 16, 2020, at 10:15 PM, Phil Diacono <satp...@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
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
