How to get Currency Revaluation Transaction Details with SuiteQL including the exchange rate?

AI generated answer (using internal Slack threads):

To get Currency Revaluation Transaction Details with SuiteQL including the exchange rate, you can use the

TransactionAccountingLine

table which has an exchange rate field. However, it's important to note that the Currency Revaluation transaction is not exposed in SuiteScript for creation or modification. Here is a sample SuiteQL query that you might use to get the exchange rate from the

TransactionAccountingLine

table:

sql
SELECT exchangeRate
FROM TransactionAccountingLine
WHERE transactionId = 'your_transaction_id'

Please replace

'your_transaction_id'

with your actual transaction ID. However, it's worth noting that the Currency Revaluation transaction is not directly exposed for manipulation via SuiteScript or workflows. As per the conversations, it seems that NetSuite support has confirmed this limitation. As a workaround, some users create journals to create the GL impact that will affect the Currency Revaluation. This involves creating a journal that can exactly negate the Currency Revaluation at the point of bill payment. This journal should reverse all that was done by the Currency Revaluation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

The case we're interested in is the following: We have Currency Revaluation of type Reversal of Unrealized Gain / Loss and we would like to get back the exchange rate that appears in the details of the Currency Revaluation page inside a Query. Is this possible?