콘텐츠로 건너뛰기
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
모든 게시물 사용자 배지
태그 (모두 보기)
odoo accounting v14 pos v15
게시판 정보
신고된 질문입니다
currencyodoo
2 답글
3147 화면
아바타
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: 

아바타
취소
albi
작성자

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.

아바타
Hilar Andikkadavath
베스트 답변

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




아바타
취소
관련 게시물 답글 화면 활동
How to get the latest stored currency rate
exchange currency odoo
아바타
아바타
아바타
3
4월 20
12232
Odoo set default currency for payroll 해결 완료
payroll currency odoo
아바타
아바타
1
1월 20
4422
How to import product variants with my own external id when using dynamic creation mode 해결 완료
odoo
아바타
아바타
2
8월 25
2325
How to import Bulk Image in Product your local database not any cloud, odoo.sh 해결 완료
odoo
아바타
아바타
1
7월 25
844
Odoo sh - Connect As
odoo
아바타
1
8월 25
1150