Scenario
In NetSuite, entity financial statements (unconsolidated) can be run only in the base currency of the subsidiary.
If the currency of the consolidating parent entity is, as an example say USD, it is possible to run the consolidated version of the entity income statement in the currency of the parent (USD). Please note that the amounts are converted to USD using the consolidated exchange rates for the period the income statement is being run at. Here are the steps to accomplish this:
Solution
1. Navigate to Reports > Financial > Income Statement > set:
- Subsidiary Context = (Subsidiary Consolidated)
2. Hit Refresh
3. Click on Customize so you will be redirected to the Financial Report Builder.
4. Under the Filters section, set a filter for the subsidiary by selecting the Name field under the Financials main folder > Subsidiary subfolder > select the subsidiary for running the income statement.
5. Under Edit Columns, set the View Columns By field to Accounting Period.
6. Assign a report name and hit Save.