Hello! We often have projects that are paid out in foreign currency and need to include foreign exchange revaluations when we calculate how much we've paid in USD. Today, the calculation is made based on a saved search that aggregates all transactions that are related to a specific project. This was working fine until the NetSuite 2021.1 release changed how foreign exchange revaluations were handled. Now, foreign exchange revaluations are completely separate transactions and are no longer being included in our calculations because the transactions are not being assigned to the project (even though the bill they are created from is assigned). I'm trying to figure out a way to automatically assign these transactions to a project. From the documentation, it looks like these records aren't supported in workflows, suitescripts, or even bulk imports. I tried a recommendation from this blog to use a scheduled script (https://netsuiteguru.blogspot.com/2020/10/currency-revaluation-record-update.html?showComment=1642781310004#c1684343222056384739), however, it failed when I tried to use record.submitFields because the operation is invalid for fxreval record types. Does anyone have any recommendations for how I can work around this issue? The only other option I would try is to handle the issue in journal entries since we can assign them to projects.

Speaking from one world experience here, what we do is not changing the currency reval, but we create journals that will create the GL impact that will affect that. Either that or with suiteGL and manipulate the gl of the given records to net off the currency reval impact.

Thank you for your response! How do you remove the GL impact of the currency reval when you move it to a journal or related record?

depending on preference, in our case the currency reval came from the discrepancy between the bill and the bill payment so the idea is to remove that. It depends on what's important for you. If they're both the same, there shouldn't be currency reval