Scenario
User customized a report but when he opens the standard report or changes the subsidiary context on the report, it is reverting to the original standard layout. User wants the customized layout to be the default one for all the subsidiaries.
Solution
This is a standard behavior in NetSuite as customization of a financial report is on a per-subsidiary basis. You need to set the Row Layout Assignment to the Customized Layout per Subsidiary. You need both the Financial Statements permission and the Report Customization permission to modify financial statement layouts.
Below are the sample steps to follow:
- Navigate to Reports > Financial > Row Layout Assignment
- On the left, turn on the In-line Edit Icon
- Set the following filters for convenience:
-- Report Type = Income Statement or any preferred report type
-- Subsidiary Context = - All -
-- Row Layout = Standard Income Statement Layout(US) or any standard layout you were looking for
- Under the Report Name column, look for concerned report
- Under the Row Layout column, click on the layout and select the Customized Layout for all the subsidiary rows you want to assign the layout to
- Click on the area outside of the selected imaginary box so that the change will be applied or click Refresh
- Access the Financial Statement once again and try changing the Subsidiary Context
Result: The report layout is now set to the Customized Layout regardless of the Subsidiary selected.
For a more detailed discussion about the Row Layout Assignment, you may also refer to SuiteAnswers 7621 | Financial Reports: Row Layout Assignment Page.
-----
If you find this information useful, let us know by reacting or commenting on this post!