Planning and 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 uppercase and lowercase letters.
-
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 uppercase and lowercase letters.
-
From the Type 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 cube that is configured in your Planning and Budgeting. The value must match exactly, including uppercase and lowercase letters.
-
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 NetSuite EPM page, see Accessing Planning and Budgeting Sync Portlets in NetSuite EPM Overview.
Related Topics
- Planning and Budgeting Sync Portlets
- Adding the Planning and Budgeting Sync Portlet to Your Home Page
- Accessing Planning and Budgeting Sync Portlets in NetSuite EPM Overview
- Planning and Budgeting Form/Dashboard Portlet
- Planning and Budgeting Substitution Variables Portlet
- Job Execution Portlet for Planning and Budgeting
- Execution Logs Portlets for Planning and Budgeting
- Planning and Budgeting Sync Checklist Portlet