When calculating trial balance of subsidiary using suiteQL, I stumbled across subsidiaries with 1 accounting book for their own currency but no transactions for the accounting book of their parent with the parent's currency This means that I get trial balance of accounts by their subsidiary's currency but can't accuretly know the trial balance by the parent's currency (

exchangerate

field is

1

in

transactionaccountingline

) How can I sum the transactions by the paren't currency in that case?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the issue you're facing is related to the way NetSuite handles currency conversions in a multi-subsidiary environment. When you're looking at a transaction, the currency field on the accounting tab determines the currency of the amount on the transaction. The subsidiary comes into play when you're looking at searches, reports, and related records like revenue arrangements. The Amount field will show the amount in the subsidiary currency unless you're showing consolidated exchange rates. In your case, if you want to sum the transactions by the parent's currency, you might need to create a consolidated report with the parent's currency. You can select Root Parent (Consolidated Report) in some financial reports, add a Subsidiary filter and then select the subsidiary you want to run in the parent's currency. Another option could be to use SuiteAnalytics Workbooks, which allows you to consolidate/convert currencies to one. However, please note that this might not give you the exact results you're looking for if there are no transactions for the accounting book of the parent with the parent's currency. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

isn't there a way to do that with a suiteQL query?