Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
currencyodoo
2 Odpowiedzi
3901 Widoki
Awatar
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: 

Awatar
Odrzuć
albi
Autor

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.

Awatar
Hilar Andikkadavath
Najlepsza odpowiedź

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




Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
How to get the latest stored currency rate
exchange currency odoo
Awatar
Awatar
Awatar
3
kwi 20
13447
Odoo set default currency for payroll Rozwiązane
payroll currency odoo
Awatar
Awatar
1
sty 20
5237
error while rendering the template website_sale.product_title after upgrading to Odoo 19
odoo
Awatar
0
gru 25
8
We are using Odoo POS (v19) for a wholesale / cash & carry business.
odoo
Awatar
0
gru 25
118
Odoo installatie
odoo
Awatar
Awatar
1
gru 25
229