Se rendre au contenu
Cette question a été signalée
upgradeopenupgrade
1 Répondre
3767 Vues
Avatar
Fadoo, 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
Ignorer
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Meilleure réponse

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
Ignorer
Publications associées Réponses Vues Activité
Odoo Upgrade and Custom Modules
upgrade openupgrade v17
Avatar
Avatar
1
mars 24
4969
Upgrading from version 17 to 19 for production environments Résolu
upgrade
Avatar
Avatar
Avatar
2
mai 26
823
Upgrade V19 problème de wishlist Résolu
upgrade
Avatar
Avatar
2
févr. 26
1881
FileNotFoundError after v17 to v18 upgrade
upgrade
Avatar
Avatar
1
sept. 25
3477
Upgrade v18->v19 on-premise
upgrade
Avatar
Avatar
Avatar
2
sept. 25
9995