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

Hello experts, I am usng SuiteQL to extract data out of NS. Struggling to get the Exchaneg Rate that applied on Intercompany Journals at Line Item.
In InterCompany Journals, the exchange rates are differ by LineItem. In the transaction &amp; transactionline items pull through SuiteQL, I couldnt find the exact feild name to pull Exchange Rate that applied at linelevel.
ANy insights are helpful. Thanks!

my usual advice is to build the dataset in the ui first

so you can see the data you are working with

<@U5TF1GQ20>  thanks for response.  I found ExchnageRate field in AccountingLine table.  May I know how do I access the UI you were mentioning ? 

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_158874665729.html|Getting Started with SuiteAnalytics Workbook>