Custom Fields
Custom Fields integrated with Breadwinner for NetSuite custom fields setup can be added to the parameter list when creating the custom URL button.
Note here that a Salesforce ID field has been added to NetSuite and integrated into Salesforce using Breadwinner for NetSuite. The NetSuite field API name is custbody_sfdcid, and the corresponding Salesforce custom field is ncf_body_sfdcid__c.
The parameter call for cURL consists of category (cf_), type (text_), netsuite field (custbody_sfdcid) and the salesforce field (Id above) which holds the value which the netsuite field will be set to.
And why is ncf_body_sfdcid__c not being used here? Simply because that is the location where the value you are setting in NetSuite is reflected back to. When the value is set in NetSuite, Breadwinner reads that value back into the Salesforce Invoice record, on the Invoice object as shown above. Passing the Salesforce Opportunity ID, into the custom field in NetSuite, and showing on the custom field in Salesforce.
We designate a custom field on a transaction by starting the line of the Custom URL as &cf which is followed by the type of the custom field (in this case a picklist) followed by the API name of the NetSuite field. Here is the theoretical construction.
NetSuite Field Type | Type Value | Example |
|---|---|---|
Date | date | &cf_date_netsuite_api_name=formula_field__c |
DateTime | datetime | &cf_datetime_netsuite_api_name=formula_field__c |
List Record (Lookup) | picklist | &cf_picklist_netsuite_api_name=formula_field__c |
Integer Number | integer | &cf_integer_netsuite_api_name=formula_field__c |
Decimal Number | number | &cf_number_netsuite_api_name=formula_field__c |
Currency | number | &cf_number_netsuite_api_name=formula_field__c |
Percent | number | &cf_number_netsuite_api_name=formula_field__c |
Check Box | checkbox | &cf_checkbox_netsuite_api_name=formula_field__c |
Free Form Text | text | &cf_text_netsuite_api_name=formula_field__c |
Text Area | textarea | &cf_textarea_netsuite_api_name=formula_field__c |
Long Text | longtextarea | &cf_longtextarea_netsuite_api_name=formula_field__c |
Email Address | text | &cf_text_netsuite_api_name=formula_field__c |
Hyperlink | text | &cf_text_netsuite_api_name=formula_field__c |
Note that the above Custom Fields at the header level are prepended with cf_ and below Custom Line Item Fields are prepended with co_cf_ This denotes cf "custom field" and co_cf "child object custom field".
We designate a custom field on a line item by starting the line of the Custom URL as &co_cf, which is followed by the type of the custom field (in this case, a picklist) followed by the API name of the NetSuite field. Here is the theoretical construction.
NetSuite Field Type | Type Value | Example |
|---|---|---|
Date | date | &co_cf_date_netsuite_api_name=formula_field__c |
Datetime | datetime | &co_cf_datetime_netsuite_api_name=formula_field__c |
List Record (Lookup) | picklist | &co_cf_picklist_netsuite_api_name=formula_field__c |
Integer Number | integer | &co_cf_integer_netsuite_api_name=formula_field__c |
Decimal Number | number | &co_cf_number_netsuite_api_name=formula_field__c |
Currency | number | &co_cf_number_netsuite_api_name=formula_field__c |
Percent | number | &co_cf_number_netsuite_api_name=formula_field__c |
Check Box | checkbox | &co_cf_checkbox_netsuite_api_name=formula_field__c |
Free Form Text | text | &co_cf_text_netsuite_api_name=formula_field__c |
Text Area | textarea | &co_cf_textarea_netsuite_api_name=formula_field__c |
Long Text | longtextarea | &co_cf_longtextarea_netsuite_api_name=formula_field__c |
Email Address | text | &co_cf_text_netsuite_api_name=formula_field__c |
Hyperlink | text | &co_cf_text_netsuite_api_name=formula_field__c |
To populate custom segment fields, the structure is similar to how we pass other custom fields, but the netsuite_api_name starts with "cseg" instead of custbody or custcol and the type value should be a picklist.
Example of passing custom segment field at Transaction level:
&cf_picklist_cseg_region=formula_field__c
Example of passing custom segment field at Line Item level:
&co_cf_picklist_cseg_region=formula_field__c
