Tuesday, May 19, 2020

#766 OIC for Netsuite --> mapping Custom Fields

Simple scenario here - a custom field in the Customer object, need to be filled when creating a customer.



















I found this out, when I ran the integration, having only mapped, what I thought were the 2 mandatory fields - company and subsidiary --> internal ID.

So now the fun starts -
Where do I find such custom field definitions in Netsuite?















So there is a custom field Customer Type. Valid values are in the following list -












As you can see, B2B has the internalID = 2.
That's the one I want to use.














This is what I need to use in my mapping -

So I'm now good - I have found the custom field, I know the valid value I need to set.

Now to the OIC mapping - I look at the definition of the Target Netsuite Customer -






































Notice the customField section above. No mention of the specific custom field, Customer Type.
This is polymorphic.

Here I consult the Netsuite adapter documentation - essentially the screenshot is somewhat out of date, but the modus operandi remains the same.

























The full doc can be found here

Essentially we need to do the following -




















The result is -















Now to filling these fields -

internalId and scriptId need to be filled -

So from where do I get these values?

Back to the Netsuite UI and the custom field definition -














 script Id = custentity_sail_ef_customer_type














internalId = 1026

Now to the value - I need to set this to 2
as B2B type has the internal Id = 2

















I now test the mapping and validate the custom field mapping result
















Looks good!

I now activate and test -



















I validate in Netsuite -






Next step is to create a Lookup to contain these hard-coded values, thus making it easy to react to change. I leave that step up to you!






No comments:

Post a Comment