Custom Segment Metadata

Planning and Budgeting Sync does not include a default saved search for custom segments. To push the hierarchy of your custom segment to Data Exchange, you need to set up the custom segment and create the saved search properly in NetSuite.

To set up your custom segment and create a saved search:

  1. Go to Customization > Lists, Records, & Fields > Record Types.

  2. Click the custom segment of your choice.

  3. Check the Include in Search Menu box.

  4. Click Save.

  5. Go to Customization > Lists, Records, & Fields > Custom Segments.

  6. Click Edit for the updated custom segment.

  7. Click the Permissions subtab.

  8. In the Role column, select the NSPB Integration role.

  9. Select View as the access level for this role.

  10. Click Add to assign this role to the custom segment.

  11. Click Save.

  12. Go back to Customization > Lists, Records, & Fields > Record Types.

  13. Click Search for the updated custom segment.

  14. Click the Create Saved Search button.

  15. Enter a title for the search.

  16. In the ID field, make sure you prefix the saved search ID with customsearch_nspb_sync_cseg.

  17. Check the Public box.

  18. On the Criteria subtab, add filters.

  19. On the Results subtab, in the Columns sublist, add the first five columns exactly as illustrated below:

    Columns subtab showing five columns to be added

    You can substitute Prefix_ in the formula for the Child column with any prefix to help you identify the saved search. For example, formula 'Seg_' ||{internalId} will list all the custom segment records under the top–level parent named Seg.

  20. Click Save.

For information about custom segments in NetSuite, see Custom Segment and Custom Segments in Record Searches. If you need to create a custom segment, see Creating a Custom Segment.

Related Topics

General Notices