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

Anyone have any tips on handling currency, subsidiaries and transactions? Using SuiteAnalytics connect to pull the tables separately and combine them I think I might be over engineering it.

I’m using transaction conversion rate &gt; sub and then have logic rolling up each sub to it’s parent and its seems overly complicated

what are you trying to do exactly?  view transactions at subsidiary level?  use Amount field for that, and for specific currency use Amount (transactional currency)

Basically trying to roll things up from the source currency to the parent company in USD

and the transaction currency can differ from the subsidiary currency

And then that sub can roll up through multiple subs changing currency before it gets to the parent sub in USD

use Amount field, not Amount (transactional currency)

Have you had a look at the currencies related <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_161950565221.html#SuiteQL-Supported-Built-in-Functions|Built-in Functions>? `BUILTIN.CONSOLIDATE` / `BUILTIN.CURRENCY_CONVERT`

I have not used those <@U29QCJQF3>! I’m getting errors when I try to use them in a net suite connection in a different software solution but I’ll play with it a bit 

When I try to run this in Domo, I’m getting this error message:

[NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Failed to retrieve data.