This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

In a Saved Search or N/SQL, how differentiate the `unrealized` vs the `realized` `fxreval` transactions?

The XML representation of the record has `variancetype` = Realized.

By the gl account used I think or by variance type 

Variance type is not exposed, or at least I didnt find it. Will dig into the account.

```var fxrevalSearchObj = search.create({
   type: "fxreval",
   settings:[{"name":"consolidationtype","value":"ACCTTYPE"},{"name":"includeperiodendtransactions","value":"F"}],
   filters:
   [
      ["type","anyof","FxReval"], 
      "AND", 
      ["appliedtotransaction","anyof","@NONE@"], 
      "AND", 
      ["mainline","is","F"]
   ],
   columns:
   [
      search.createColumn({name: "transactionname", label: "Transaction Name"})
   ]
});```


If applied to transaction not empty = CR Realized if empty = CR Unrealized