Financial Report Builder Edit Columns Page

On the Edit Columns page of the Financial Report Builder, you can make changes to the columns for a custom financial statement.

Screenshot of the Edit Columns page of the Financial Report Builder

The functions available on this page are similar to those available on the Report Builder Edit Columns page, as described in Adding, Removing, or Reordering Report Columns. Additional capabilities include:

Avoid selecting values related to time from the View Columns By dropdown list for reports that use the Subsidiary Context of Subsidiary (Consolidated).

Note:

If you remove the original Amount column, you cannot drill down on the data in the Amount column that you add later.

Most of your financial statement customizations are likely to be made to rows, and so are done on the Financial Report Builder Edit Layout Page.

Column values in financial statement results are rounded to the currency precision, as determined by the format of the company currency, or in NetSuite OneWorld, by the format of the subsidiary base currency. This rounding applies to currency values and non-currency values, including formula column values.

Warning:

For performance reasons, a report cannot include more 30 data columns. If you try to add a 31st column on the Edit Columns page, you will receive an error. Report results may include more than 30 columns because of persistent matrix columns defined in the View Columns By list. See Adding Persistent Matrix Columns to Financial Statements.

You need both the Financial Statements permission and the Report Customization permission to customize reports in the Financial Report Builder. If you do not have necessary permissions, contact your account administrator. See Giving Access to Financial Statements for more information.

Related Topics

Financial Report Builder
Financial Report Builder Edit Layout Page
Adding, Removing, or Reordering Report Columns

General Notices