Scenario:
Most users customize their Income Statement in accordance with their need and company’s financial design.
Did you know that you can use your saved custom Row Layouts in your new or existing custom Income Statement reports without having to re-create it and assigning it easily on subsidiaries?
Solution:
Here’s how you can do it, let’s say for example you want to create a new custom Row Layout:
- Navigate to Reports > Financial > Income Statement
- Click Customize
- In the Edit Layout tab, change the LAYOUT to the Standard ones depending on your Subsidiary’s Edition for example, in US use Standard Income Statement (US)
Note: It is best practice to use and customize layouts based on the edition of your subsidiaries especially for OneWorld accounts. Please check SuiteAnswers ID: 9869
4. Click Edit Layout.
5. Perform changes in Row Layout, such as:
· Renaming Header Rows, Section Names
· Adding Rows
· Editing Rows
· Row Filters, Format, Summary Row Calculation
7. Save the Custom Income Statement
8. Navigate to Reports > Financial > Row Layout Assignment
9. Filter the following:
Report Type = Income Statement
Subsidiary Context: Select Appropriate Subsidiary (For OneWorld Accounts)
10. Enable the Inline-edit function
11. Select your existing Income Statement
12. Change the Row Layout for this report and choose the one you created in Step 5.
13. Click Refresh
14. Disable Inline Editing
Notes:
· In OneWorld, your preferred layout should be assigned to subsidiaries one by one
· If your custom income statement is being referenced by other reports and you made changes in the layout, you will need to REDEFINE these reference row(s) to avoid invalid rows.
You can check these SuiteAnswers ID for reference:
SuiteAnswers ID: 7621 | Financial Reports: Row Layout Assignment Page
SuiteAnswers ID: 7616 | Editing a Financial Statement Layout
Have you tried this one? Do you have other tips in customizing reports? Feel free to share your thoughts