Skip to Content
This question has been flagged
currencyodoo
2 Replies
3923 Rodiniai
Portretas
albi

Hi,

I am customizing Odoo and I encountered the following issue.

I will give the client (hereafter HE) an Excel file, there he will choose a currency (let's say USD instead of INR as default one)

So, based on this entry (which I need to read) I have to change the default currency from INR to USD.

I know I can do it via Settings>>Accounting>>Default company currency   but I have to update database, so is there any way I can modify the database by some query? 

P.S for more detailed here is my stack overflow post: 

Portretas
Atmesti
albi
Autorius

Hi Hilar,

thanks for the answer!

This works perfectly for changing the company's default currency, but seems like sales, purchases, etc. are totally linked differently because there still the currency it is unchanged unfortunately.

Portretas
Hilar Andikkadavath
Best Answer

First, find active currencies;

select id, name from res_currency where active IS True


Next, update company currency by choosing of the currency id from the output.

update res_company set currency_id = 2 where id = 1 /*choose the company*/




Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
How to get the latest stored currency rate
exchange currency odoo
Portretas
Portretas
Portretas
3
bal. 20
13451
Odoo set default currency for payroll Solved
payroll currency odoo
Portretas
Portretas
1
saus. 20
5247
ENTREPRISE V18-Automatic draft Delivery Notes on Sales Orders causing sequence gaps and date inconsistencies
odoo
Portretas
0
gruod. 25
3
Automation to Validate Delivery and Invoice Addresses
odoo
Portretas
0
gruod. 25
66
Automation to Validate Delivery and Invoice Addresses
odoo
Portretas
0
gruod. 25
23