You can create custom fields in NetSuite to hold any data you'd like. For example, FarApp requires you to create two custom fields for sales order imports and one custom field for each marketplace/cart you want to sync product/inventory to. NetSuite calls custom fields on transactions (e.g. sales orders, cash sales, etc.) Transaction Body Fields. They call custom fields on the line items of these transactions Transaction Line Fields. And finally they call custom fields on item records just Item Fields. Here are instructions on how to create these fields in NetSuite:
Transaction Body Fields
- In NetSuite, go to Customization->Lists, Records, & Fields->Transaction Body Fields->New.
- Give it a label of your choosing (this is the visible name of the field).
- Preferably, also give it an ID that's easy to identify. Whatever you put in this field will be prefixed by "custbody" to make the field ID that FarApp uses to sync data to/from NetSuite.
- Give it a type of your choosing. You can get more help on the different types by clicking NetSuite's Help button at the top right.
- In the Applies To tab, select the transaction types that you'd like to display this field. SALE is for your sales transactions like sales orders and cash sales so you'll want to check that for the field to show up on those transaction types.
- Click Save.
- If you're using custom transaction forms, click Apply to Forms at the top and make sure to check the "SHOW" column for the appropriate forms.
Transaction Line Fields
- In NetSuite, go to Customization->Lists, Records, & Fields->Transaction Line Fields->New.
- Give it a label of your choosing (this is the visible name of the field).
- Preferably, also give it an ID that's easy to identify. Whatever you put in this field will be prefixed by "custcol" to make the field ID that FarApp uses to sync data to/from NetSuite.
- Give it a type of your choosing. You can get more help on the different types by clicking NetSuite's Help button at the top right.
- In the Applies To tab, select the transaction types that you'd like to display this field. SALE ITEM is for your line items on sales transactions like sales orders and cash sales so you'll want to check that for the field to show up on line items for those transaction types.
- Click Save.
- If you're using custom transaction forms, click Apply to Forms at the top and make sure to check the "SHOW" column for the appropriate forms.
Item Fields
- In NetSuite, go to Customization->Lists, Records, & Fields->Item Fields->New.
- Give it a label of your choosing (this is the visible name of the field).
- Preferably, also give it an ID that's easy to identify. Whatever you put in this field will be prefixed by "custitem" to make the field ID that FarApp uses to sync data to/from NetSuite.
- Give it a type of your choosing. You can get more help on the different types by clicking NetSuite's Help button at the top right.
- Please note when manually creating a custom item field to use as the flag field, you must select "Free-Form Text" as the Type and "1" for the Maximum Length in the Validation & Defaulting Tab (screenshot below):
- Please note when manually creating a custom item field to use as the flag field, you must select "Free-Form Text" as the Type and "1" for the Maximum Length in the Validation & Defaulting Tab (screenshot below):
- In the Applies To tab, select the item types that you'd like to display this field.
- Click Save.
- If you're using custom item forms, click Apply to Forms at the top and make sure to check the "SHOW" column for the appropriate forms.
- Please see instructions on how to flag existing NetSuite items here: https://support.farapp.com/hc/en-us/articles/360040572213-How-to-flag-items-to-sync-in-NetSuite
Customer Fields
- In NetSuite, go to Customization->Lists, Records, & Fields->Entity Fields->New.
- Give it a label of your choosing (this is the visible name of the field).
- Preferably, also give it an ID that's easy to identify. Whatever you put in this field will be prefixed by "custcol" to make the field ID that FarApp uses to sync data to/from NetSuite.
- Give it a type of your choosing. You can get more help on the different types by clicking NetSuite's Help button at the top right.
- In the Applies To tab, select the item types that you'd like to display this field.
- Click Save.
- If you're using custom item forms, click Apply to Forms at the top and make sure to check the "SHOW" column for the appropriate forms.
Comments
0 comments
Please sign in to leave a comment.