Subsidiary Context for Reports

If you have access to multiple subsidiaries, you can view the data for all subsidiaries at one time. You can also view data for individual subsidiaries. In the report footer, select the subsidiary in the Subsidiary Context filter.

Note:

If you use Multi-Book Accounting, you can run consolidated reports for any accounting book enabled for consolidation. Use the Accounting Book list to choose the primary or secondary accounting book that correlates with the selected subsidiary context.

When you select a subsidiary, including elimination subsidiaries, NetSuite filters the report data to display data only from the selected subsidiary. In the case of consolidated subsidiaries, the data that displays is for all child subsidiaries of the consolidated parent subsidiary, including elimination subsidiaries.

For example, if a company has the following subsidiary hierarchy:

Diagram of subsidiary context specific to reporting.

The Subsidiary Context filter on reports would be organized as follows:

Wolfe US (Consolidated)

Wolfe US

Wolfe Germany

Wolfe UK (Consolidated)

Wolfe UK

Wolfe Japan

Wolfe Singapore

NetSuite inserts a virtual consolidated node for each parent. When you select a consolidated node, the data returned is a summary of all transactions associated with the node’s child subsidiaries, including elimination subsidiaries.

If you use a role that is restricted to specific subsidiaries, the data returned is based on your level of access.

Using the preceding example hierarchy, if you have access to only the Japan subsidiary, the Subsidiary Context filter would be organized as follows:

Wolfe US (Context)

Wolfe UK (Context)

Wolfe Japan

You would see the following for each selection:

Selection	Transactions Included	Currency Shown	Financial Statement Layout
Wolfe US (Context)	Wolfe Japan	US dollar	Wolfe US
Wolfe UK (Context)	Wolfe Japan	British pound (GBP)	Wolfe UK
Wolfe Japan	Wolfe Japan	Japanese yen	Wolfe Japan

Because this role is restricted to a single subsidiary, the results do not include consolidated data. However, you can still see the data in Wolfe Japan as it would appear in the currencies and layouts of parent subsidiaries.

Important:

Some reports do not support consolidation and return results for only one subsidiary at a time. These reports do not include the Subsidiary Context filter in the report footer. Before you can run one of these reports, you must set your user preferences to restrict your view to a single subsidiary. Go to Home > Set Preferences and then click the Restrict View subtab. See Restrict Your Subsidiary View.

Related Topics