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?