How to get rid of "Could not determine the account currency. Using the default currency provided by your system."

[Paul Neuwirth]

On Wed, 03 Jan 2018 13:45:46 -0500
Derek Atkins <warlord at MIT.EDU> wrote:

> Hi,
> 
> Paul Neuwirth <mail at paul-neuwirth.nl> writes:
> 
> > Hello,
> > I always get "Could not determine the account currency. Using the
> > default currency provided by your system." when opening an account
> > since upgrade to 2.6.19.
> > according to SQL 
> > SELECT * FROM gnucash.accounts a left join gnucash.commodities c on
> > c.guid = a.commodity_guid;
> > all accounts have a currency set.
> >
> > Book Option "Use Trading Accounts" is off
> > Preferences Accounts, Default Currency is set (choose: EUR)
> >
> > what am I missing?  
> 
> What type of account is it?
> Specifically, is it a stock/mutual fund account?
> If so, is it a top-level account?
> 
> Stock/Mutual accounts need to be children of an Asset with a currency.

Thank you.
it was any account, any type and everywhere was Euro (EUR) set (not
changable in dialog).. I saw in the mysql table commodities, EUR defined
twice. when I imported transactions duplicate accounts where made with
the "other EUR currency". I replaced old commodity-guids in all tables
by the new guid..

update gnucash.transactions set
currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.accounts set
commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
= 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.customers set
currency='2e2395017967d7799120dc8585cf4080' where currency =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.invoices set
currency='2e2395017967d7799120dc8585cf4080' where currency =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
= 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.vendors set
currency='2e2395017967d7799120dc8585cf4080' where currency =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; 

and deleted the old EUR currency... 
now everything is fine.. 

> 
> > Any help appreciated.
> >
> > Happy new year,
> >
> > Paul  
> 
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.  
> 
> -derek
>