Skip to Content
Dette spørgsmål er blevet anmeldt
upgradeopenupgrade
1 Svar
2864 Visninger
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
Kassér
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Bedste svar

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
Kassér
Related Posts Besvarelser Visninger Aktivitet
Odoo Upgrade and Custom Modules
upgrade openupgrade v17
Avatar
Avatar
1
mar. 24
3677
FileNotFoundError after v17 to v18 upgrade
upgrade
Avatar
Avatar
1
sep. 25
1336
Upgrade v18->v19 on-premise
upgrade
Avatar
Avatar
Avatar
2
sep. 25
4992
Version 16 > Version 18 odoo
upgrade
Avatar
0
apr. 25
1961
Upgrade 17 to 18 on prem Løst
upgrade
Avatar
Avatar
Avatar
2
jan. 25
3936