Subsidiary Context for Reports in NetSuite

TL;DR

This article explains how to navigate subsidiary context for reports in NetSuite, allowing users with access to multiple subsidiaries to view consolidated or specific subsidiary data efficiently, enhancing reporting flexibility and accuracy.

How Does Subsidiary Context Work?

When you have access to multiple subsidiaries in NetSuite, you can view data for all subsidiaries collectively or drill down into individual subsidiary reports. This is facilitated through the Subsidiary Context filter located in the report footer.

Consolidated Reporting

If you utilize Multi-Book Accounting, you can generate consolidated reports for any accounting book designated for consolidation. By selecting the appropriate accounting book—which could be the primary or secondary book—you can match it with the chosen subsidiary context.

• Selecting a Subsidiary: When a subsidiary is selected, including elimination subsidiaries, NetSuite exclusively filters the report data to reflect the chosen subsidiary's information. For example, selecting a consolidated subsidiary displays data for all child subsidiaries, inclusive of any elimination subsidiaries.

Example Hierarchy

Consider the following subsidiary hierarchy for understanding how the context filter operates:

• Wolfe US (Consolidated)
• Wolfe US
• Wolfe Germany
• Wolfe UK (Consolidated)
• Wolfe UK
• Wolfe Japan
• Wolfe Singapore

NetSuite creates a virtual consolidated node for each parent subsidiary. When this node is selected, the report provides a comprehensive summary encompassing all transactions associated with its child subsidiaries.

Role-Specific Views

If your NetSuite role is restricted to specific subsidiaries, the available data will correspond to this limitation. For instance, if you only have access to the Japan subsidiary, the Subsidiary Context filter will adjust accordingly:

• Wolfe US (Context)
• Wolfe UK (Context)
• Wolfe Japan

For each selection, the displayed data will show:

With a single subsidiary restriction, consolidated data will not be included. However, the data views in Wolfe Japan will reflect the currencies and layouts of parent subsidiaries.

Important Considerations

Some reports in NetSuite do not accommodate consolidation, limiting you to one subsidiary at a time. Such reports will lack the Subsidiary Context filter in the report footer. To run these reports, you must adjust your user preferences to restrict your view to a single subsidiary:

1. Navigate to Home > Set Preferences.
2. Click the Restrict View subtab and make the necessary changes.

Related Topics

• Currency for Multiple Subsidiary Search Results
• Consolidated Reporting in OneWorld

Key Takeaways

• The Subsidiary Context filter allows flexible reporting across multiple subsidiaries.
• Consolidated nodes summarize data across child subsidiaries.
• Role-based restrictions determine the data visibility based on user access.
• Ensure you set user preferences for reports that do not support consolidation.

Source: This article is based on Oracle's official NetSuite documentation.