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

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

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

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

Any help appreciated.

Happy new year,

Paul
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins
Hi,

Paul Neuwirth <[hidden email]> 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
       [hidden email]                        PGP key available
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: 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 <[hidden email]> wrote:

> Hi,
>
> Paul Neuwirth <[hidden email]> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

Paul Neuwirth
On Thu, 4 Jan 2018 06:05:02 +0100
Paul Neuwirth <[hidden email]> wrote:

> On Wed, 03 Jan 2018 13:45:46 -0500
> Derek Atkins <[hidden email]> wrote:
>
> > Hi,
> >
> > Paul Neuwirth <[hidden email]> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins
Hi,

Paul Neuwirth <[hidden email]> 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
       [hidden email]                        PGP key available
_______________________________________________
gnucash-user mailing list
[hidden email]
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.