Hi, Paul Neuwirth <m...@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 warl...@mit.edu PGP key available _______________________________________________ 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.