Creating Custom Lists and Fields in NetSuite

Creating custom lists and fields in NetSuite allows for enhanced inventory management through the configuration of storefront flag fields and product syncing capabilities.

How to Create a Custom List

If you already have a flag field, you can utilize the list associated with that field. However, if you're starting fresh, follow these steps to create a custom list:

1. Navigate to Customization > Lists, Records, & Fields > New.
   This action opens the Custom List page.
2. In the Name field, input a name for your custom list.
3. In the ID field, designate an ID for your custom list.
4. Set the Show Options In field to Order Entered.
5. Ensure that the Matrix Option List and Inactive check boxes are unchecked.
6. In the Values sublist, enter the following values in the specified order:
   • Add/Update Item
   • Remove Item
   • Ignore Item
   • Post Children as Stand-Alone
     Important: It's crucial to enter the values in this precise order, as it impacts the internal ID configuration.
7. Click Save.

How to Create a Custom Field

Once your custom list is in place, you can create a corresponding custom field:

1. Navigate to Customization > Lists, Records, & Fields > Item Fields > New.
   This action opens the Custom Item Field page.
2. In the Label field, provide a display name for the field on the item record.
3. In the ID field, input the field's ID.
   This ID will be used for the flag field in product mappings.
4. From the Type list, select List/Record.
5. In the List/Record dropdown, choose your newly created custom list.
6. Under the Applies To subtab, check the relevant boxes for item types where this field should be applicable.
7. (Optional) In the Display Type subtab, you may specify where the field appears on the item record by selecting a subtab.
   If no subtab is chosen, the field will default to the Custom subtab.
8. Click Save.

Creating these custom lists and fields enhances your product management capabilities within NetSuite, providing granularity and control over how items are synced to storefronts.

Key Takeaways

• Custom lists are essential for setting up storefront flags in NetSuite.
• The order of entries in a custom list affects internal IDs.
• Custom fields allow for extensive customization of item records.
• Each custom field can apply to specific item types for better management.

Source: This article is based on Oracle's official NetSuite documentation.