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.

المنشورات ذات الصلة	الردود	أدوات العرض
Odoo Upgrade and Custom Modules upgrade openupgrade v17	1 مارس 24	3666
FileNotFoundError after v17 to v18 upgrade upgrade	1 سبتمبر 25	1322
Upgrade v18->v19 on-premise upgrade	2 سبتمبر 25	4936
Version 16 > Version 18 odoo upgrade	0 أبريل 25	1955
Upgrade 17 to 18 on prem تم الحل upgrade	2 يناير 25	3924

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!