On Wed, 03 Jan 2018 13:45:46 -0500 Derek Atkins <warl...@mit.edu> wrote:
> Hi, > > Paul Neuwirth <m...@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 > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
