Skip to Content
This question has been flagged
upgradeopenupgrade
1 Reply
3865 डेटा देखने का तरीका
अवतार
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?

अवतार
खारिज करें
अवतार
Cybrosys Techno Solutions Pvt.Ltd
Best 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.

अवतार
खारिज करें
Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
Odoo Upgrade and Custom Modules
upgrade openupgrade v17
अवतार
अवतार
1
मार्च 24
5038
Upgrading from version 17 to 19 for production environments Solved
upgrade
अवतार
अवतार
अवतार
2
मई 26
980
Upgrade V19 problème de wishlist Solved
upgrade
अवतार
अवतार
2
फ़र॰ 26
2014
FileNotFoundError after v17 to v18 upgrade
upgrade
अवतार
अवतार
1
सित॰ 25
3625
Upgrade v18->v19 on-premise
upgrade
अवतार
अवतार
अवतार
2
सित॰ 25
10154