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

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

2018-01-04 Thread Derek Atkins

Hi,

Paul Neuwirth  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.eduPGP 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.

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

2018-01-03 Thread Paul Neuwirth

On Thu, 4 Jan 2018 06:05:02 +0100
Paul Neuwirth  wrote:

> On Wed, 03 Jan 2018 13:45:46 -0500
> Derek Atkins  wrote:
> 
> > Hi,
> > 
> > Paul Neuwirth  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.. 
> 
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...
___
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.

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

2018-01-03 Thread Paul Neuwirth

On Wed, 03 Jan 2018 13:45:46 -0500
Derek Atkins  wrote:

> Hi,
> 
> Paul Neuwirth  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.

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

2018-01-03 Thread Derek Atkins

Hi,

Paul Neuwirth  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.

> 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

-- 
   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.eduPGP 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.

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

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

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

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

4 matches

Site Navigation

Mail list logo

Footer information