Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
5 Trả lời
12301 Lượt xem

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 - 

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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.


Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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".

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ

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).

Tác giả Câu trả lời hay nhất

Thanks @cesar mateo

can i delete those transactions or make it go back to how it is, so i can change the currency?


Ảnh đại diện
Huỷ bỏ