Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
currencyodoo
2 Vastaukset
3156 Näkymät
Avatar
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: 

Avatar
Hylkää
albi
Tekijä

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.

Avatar
Hilar Andikkadavath
Paras vastaus

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*/




Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
How to get the latest stored currency rate
exchange currency odoo
Avatar
Avatar
Avatar
3
huhtik. 20
12234
Odoo set default currency for payroll Ratkaistu
payroll currency odoo
Avatar
Avatar
1
tammik. 20
4422
How to import product variants with my own external id when using dynamic creation mode Ratkaistu
odoo
Avatar
Avatar
2
elok. 25
2330
How to import Bulk Image in Product your local database not any cloud, odoo.sh Ratkaistu
odoo
Avatar
Avatar
1
heinäk. 25
851
Odoo sh - Connect As
odoo
Avatar
1
elok. 25
1150