Hi guys, i am trying to make a financial report in netsuite that shows debit credit in USD no matter what is the base currency of subsidiary i am selecting while running the report. Its a one world account that has 6 subsidiaries with different base currencies in different countries. Is that possible?
p
PWN
05/16/2023, 12:03 PM
Well not really unless the top node has USD as base currency, consolidation in additional currencies requires either multibook or to add an empty shell on top of the top node and adjusting consolidated exchange rates. From a (USD) consolidated view you should always get the USD currency regardless of subsidiary you drill down to.
What is your sub structure and what is the base currrency of top node?
w
Waqas Ahmad
05/16/2023, 12:05 PM
Top node has USD as base currency. And consolidated report is in usd but i want to see subsidiary level report in usd when base currency of that subsidiary is euro.
m
Michael McNamara
05/16/2023, 2:11 PM
You might want to checkout SuiteAnalytics Workbooks. I believe you can consolidate/Convert currencies to one.
l
Luis
05/17/2023, 1:56 AM
You can select Root Parent (Consolidated Report) in some financial report, add a Subsidiary filter and then select the subsidiary you want to run in USD.