Customizing a Planning and Budgeting Sync Saved Search
You can use the saved searches included in the Planning and Budgeting Sync SuiteApp. If you need to customize a created Planning and Budgeting Sync saved search to better suit your needs, make sure you customize it properly in NetSuite.
To customize a Planning and Budgeting Sync saved search:
-
In NetSuite, go to NetSuite EPM > Planning and Budgeting > Manage Saved Searches.
-
In the upper-right corner of the page, click Create Default Saved Searches.
-
From the Saved Search Group list, select the saved search group containing the saved search you want to customize. The following are the available saved search groups:
-
NSPB – Data Saved Searches
-
NSPB – Metadata Saved Searches
-
NSPB Financials – Demand Forecasting Saved Searches
-
NSPB Financials – Data Saved Searches
-
NSPB Financials – Metadata Saved Searches
-
Miscellaneous Saved Searches
For information about saved searches included in each group, see Saved Searches for Planning and Budgeting Sync.
-
-
Click the link to a saved search in the Created status.
-
On the saved search record page, you can modify the following:
-
Saved search title.
Note:Make sure the saved search name is unique in NetSuite.
-
Search ID. To modify it, click Change ID, and then do the following:
-
In the New ID field, enter the new search ID.
-
Click Save.
Important:Saved searches the IDs of which begin with customsearch_nspb are available in the RESTlet. The saved search ID cannot begin with customsearch_nspb_req.
Note:Read the following details about changing the saved search ID:
-
Make sure the saved search ID is unique in NetSuite.
-
When you change the ID of a saved search, the existing settings of the saved search will be lost.
-
-
-
Verify that the saved search is Public.
-
On the Criteria subtab, add or remove filters.
-
On the Results subtab, add or remove columns.
Note:When you enter a value in the Summary Type column, and then run the saved search in NetSuite, the Total row appears at the bottom of the saved search result. This Total row is excluded from CSV files that are exported to your Planning and Budgeting with Import Data/Metadata jobs.
-
Make any necessary changes, and click Save.
Read the following details about customization of the Planning and Budgeting Sync saved searches:
-
Next time you update your installed Planning and Budgeting Sync, the latest updates will not affect the Planning and Budgeting Sync saved searches you already created and customized in NetSuite. If you want to use saved searches included in the latest release of the SuiteApp, you need to recreate the saved searches in NetSuite. See Recreating a Planning and Budgeting Sync Saved Search.
-
The Data Exchange configurations are compatible with the saved searches included in the latest release of the SuiteApp. If you want to use your customized saved searches, you may need to manually update the Data Exchange configurations.
For information about the use of Data Exchange in the Oracle Planning and Budgeting Cloud Service, see the Oracle Help Center topic Administering Data Integration for Oracle Enterprise Performance Management Cloud.
-
Settings associated with a deleted saved search's ID remain in the system. If you create a new saved search with the same ID, NetSuite applies the same settings to this saved search.