Hello,
We have an issue where the currency revaluation is not as expected. We have some transactions in foreign currency and then we used a JE (in USD) to move the impact from one account to another as there was some items set up with the wrong account. In retrospect, we realize we should have used JEs in the currency of the original transaction to make the moves as our currency revaluation got messed up, we ended up with a huge gap between balance and balance (fx). So we believe we need to take reverse the original JE and replace it with JEs per currency. However, we just ran a balance sheet and added a coulmn for foreign currency. This column is mostly zero for the item fulfillments, but a few have a value. I believe this is because we have a GL customization which causes an impact to an expense account when a specific code is used on the item lines. It seems these IFs are the ones with a value for foreign currency.
Is it standard behavior that an IF would show zero on a balance sheet for foreign currency? Why?
Is taking out the USD JE and entering the foreign currency JEs the way to resolve this in full?
I guess I'm just looking for reassurance that there isn't something else I'm missing.