OpenUpgrade Error 13-14 different foreign currency

Question

OpenUpgrade: You cannot set a currency on this account as it already has some journal entries having a different foreign currency.

In version 13, there are many journal entries and their currency is not set

UPDATE account_move_line
SET currency_id = (SELECT id FROM res_currency WHERE name = 'Currency Name')
WHERE currency_id IS NULL; journal entry -> It has 30 out of 50 currencies
journal items -> It has 41000 out of 5000 currencies
account -> All have currency
In your opinion, these changes s

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,

Run this Python code in Odoo shell or migration script:
lines = env['account.move.line'].search([('currency_id', '=', False)])
for line in lines:
if line.account_id.currency_id:
line.currency_id = line.account_id.currency_id
This fills missing currencies using each line’s account currency - safely through ORM.

Hope it helps.

Relaterade inlägg	Svar	Vyer
Odoo Upgrade and Custom Modules upgrade openupgrade v17	1 mars 24	4996
Upgrading from version 17 to 19 for production environments Löst upgrade	2 maj 26	861
Upgrade V19 problème de wishlist Löst upgrade	2 feb. 26	1906
FileNotFoundError after v17 to v18 upgrade upgrade	1 sep. 25	3500
Upgrade v18->v19 on-premise upgrade	2 sep. 25	10026

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!