Import Entitlement can throws error: The custom column field '<field_name>' is mandatory but was not present.

Changing some of the fields to mandatory on Software Entitlement form can cause issues while importing the entitlement even though the mandatory fields are present in the import document.

> Any instance which is in Orlando version
> Change some of the fields that are not mandatory OOTB to mandatory(fields like start_date,end_date,publisher_part_number,unit cost)
> Import an entitlement with above mandatory fields present in the excel sheet.

Error is thrown:
Multiple reasons for error: Publisher Part Number not found; The custom column field 'end date' is mandatory but was not present; The custom column field 'publisher part number' is mandatory but was not present; The custom column field 'start date' is mandatory but was not present; The custom column field 'unit cost' is mandatory but was not present

The issue can be fixed by adding the mandatory fields to line 67 of the script include SAMPEntitlementUtil

https://<instance-name>.service-now.com/nav_to.do?uri=sys_script_include.do?sys_id=31630b8587420300562e4127f5cb0b01

OOTB:

MANDATORY_NON_CUSTOM_FIELDS: ['model', 'model_category', 'quantity', 'license_metric', 'purchased_rights', 'software_model', 'product_type'],

Add the other fields like below:

MANDATORY_NON_CUSTOM_FIELDS: ['model', 'model_category', 'quantity', 'license_metric', 'purchased_rights', 'software_model', 'product_type','start_date','end_date','unit_cost','publisher_part_number'],

Note: SAMPEntitlementUtil is a protected script so customers would not be able to modify this, if required customer support would be able to assist the customer further if they choose to use the workaround.