Planning & Budgeting Account Balance Portlet
This portlet lets you access real-time account balance data in your Planning and Budgeting. The portlet shows values for the current month and the previous quarter of the year.
To display data in the portlet, you need to set up your custom record type in NetSuite.
To set up your custom record type:
-
Go to Customization > Lists, Records, & Fields > Record Types.
-
Click List for the NSPB | Account Balance Configuration record type.
-
Click New NSPB | Account Balance Configuration.
-
In the Dimension field, enter the name of a dimension that is configured in your Planning and Budgeting. The value must match exactly, including upper and lower case.
-
In the Member field, enter the name of a member that is configured for the dimension in your Planning and Budgeting. The value must match exactly, including upper and lower case.
-
From the Type dropdown list, select one from the following options:
-
POV to use the Point Of Views of this dimension and member to filter out the account balance value.
-
Rows to use the value of this dimension and member as the account balance value. We can use only one row for the dimension and member.
-
-
In the Cube Name field, enter the name of a corresponding cube in your Planning and Budgeting.
-
To display this member in the portlet, check the Show In Account Balance Portlet box.
-
Click Save.
The following screenshot illustrates the custom record type setup:
For instructions on adding the portlet to the Planning & Budgeting page, see Accessing Planning & Budgeting Overview Portlets.