How can I change the currency, whenever i try to do it this pops up - You cannot change the currency of the company since some journal items already exist -
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- 会計
- 在庫
- PoS
- Project
- MRP
この質問にフラグが付けられました
5
返信
12061
ビュー
Hi,
When transactions with the currency are already made, such as creating accounting journals, it no longer allows you to change the company's currency.
Thank you.
One dirty solution could be temporary change company_id of some registers using psql.
update account_journal set company_id = 'temp_company_id' where company_id = 'current_company_id';
update account_move set company_id = 'temp_company_id' where company_id = 'current_company_id';
update account_move_line set company_id = 'temp_company_id' where company_id = 'current_company_id';
After that you can change the currency of the company.
At the end you can return to the previous value of "company_id" of the modified registers.
Hi,
Thank you for your solution.
I am getting this error while deleting a paid invoice:
ERROR: update or delete on table "account_move_line" violates foreign key constraint "account_partial_reconcile_debit_move_id_fkey" on table "accoun t_partial_reconcile"
DETAIL: Key (id)=(45) is still referenced from table "account_partial_reconcile".
yea u can go to psql and use command
delete from account_move_line;
and delete all the transactions (ONLY IF YOU DONT NEED THOSE DUMMY ENTRIES)
Then you can change currency.
This is not a proper solution.
What if those entries are real-time entries and are reconciled and you don't want to delete them?
didnt you see-> (ONLY IF YOU DONT NEED THOSE DUMMY ENTRIES).
Thanks @cesar mateo
can i delete those transactions or make it go back to how it is, so i can change the currency?
