RE: 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.

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 & 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!

prateekhexa Rookie Asked on August 23, 2022 in SuiteAnalytics.
Add Comment
1 Answers

Hi,

I think you might need to join to TransactionAccountingLine to get this.

Thanks,

Chris

Intermediate Answered on September 5, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.