How to zero out currency revaluation in secondary books

AI generated answer (using internal Slack threads):

To zero out currency revaluation in secondary books, you need to create a journal entry into the elimination subsidiary. This should clear the USD balance to zero if you have an EUR bank account that has already 0 EUR balance but the USD balance, base currency, is not zero. If you have a total balance in foreign currency of zero in any account and the system doesn't run the revaluation, it means at some point in time you created an FX transaction and closed it with a non-FX transaction. The FX balance did not go away and this is what keeps revaluing. You need to create a search for all transactions since day one and have it with currency and FX rate and use both amount and amount (foreign currency) field. After you know which transaction caused the issue you need to reverse the non-FX transaction and book the FX transaction. If you want to delete a handful of Currency Revaluation (System Generated) as you are purging some old data, you need to know that currency revaluation does occur when payments are made or payments are applied so you would have to zero that stuff out before you can delete those entries. Alternatively, you can place reversing entries. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******