Ir al contenido
Se marcó esta pregunta
upgradeopenupgrade
1 Responder
2835 Vistas
Avatar
Saeed Raeisi

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 should be applied by query or manually?

Avatar
Descartar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Mejor respuesta

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.

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
Odoo Upgrade and Custom Modules
upgrade openupgrade v17
Avatar
Avatar
1
mar 24
3626
FileNotFoundError after v17 to v18 upgrade
upgrade
Avatar
Avatar
1
sept 25
1274
Upgrade v18->v19 on-premise
upgrade
Avatar
Avatar
Avatar
2
sept 25
4833
Version 16 > Version 18 odoo
upgrade
Avatar
0
abr 25
1938
Upgrade 17 to 18 on prem Resuelto
upgrade
Avatar
Avatar
Avatar
2
ene 25
3887