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

[Derek Atkins]

Hi,

Paul Neuwirth <mail at paul-neuwirth.nl> writes:

[snip]
>> 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.. 
>> 
> Now I have the same issue with all foreign currency accounts...
>
> Execute:
>> SELECT * FROM gnucash.commodities
>
> + --------- + -------------- + ------------- + ------------- +
> ---------- + ------------- + --------------- + ----------------- +
> ------------- +
> | guid | namespace | mnemonic | fullname | cusip | fraction |
> | quote_flag | quote_source | quote_tz |
> + --------- + -------------- + ------------- + ------------- +
> ---------- + ------------- + --------------- + ----------------- +
> ------------- +
> | 090f9175bf272d914fc77cf8990ddde8 | CURRENCY | USD | US-Dollar | 840
> | | 100 | 1 | currency | |
> | 1669bedf79e858ba5ec3358346eee9b1 | CURRENCY | ZWL | Simbabwe-Dollar
> | | 716 | 100 | 0 | currency | |
> | 2d24b3b5c4ac803f1ef048f43801905c | CURRENCY | GBP | Pfund Sterling |
> | 826 | 100 | 1 | currency | |
> | 2e2395017967d7799120dc8585cf4080 | CURRENCY | EUR | Euro | 978 | 100
> | | 1 | currency | |
> | 4636ac6477efed452967bdb61c4a46ff | CURRENCY | PLN | Zloty | 985 |
> | 100 | 1 | currency | |
> | aad29cfc8037ac37b0a30fb16fad538a | template | template | template |
> | template | 1 | 0 | | |
> | bc7184bbbdac77765e615d7a3e2547d3 | CURRENCY | USD | US-Dollar | 840
> | | 100 | 1 | currency | |
> | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
> + --------- + -------------- + ------------- + ------------- +
> ---------- + ------------- + --------------- + ----------------- +
> ------------- + 8 rows
>
> what is bad at first entry for USD (old accounts), but new want the
> last line's USD...

This seems like a bug that there are multiple entries for a currency.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available