Skip to Content
Menu
This question has been flagged
2178 Views

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
Discard
Related Posts Replies Views Activity
1
Mar 24
2617
0
Apr 25
1224
2
Jan 25
2534
2
Jan 25
2954
0
Mar 23
3099