AnsweredAssumed Answered

Error executing Netsuite operation: org.xml.sax.SAXException - Custom Segment Fields

Question asked by somesh_sharma702004 on May 7, 2018
Latest reply on Aug 14, 2018 by ravi.matavalam

Hi All,

 

I am trying to upsert Employee Expense Data with Custom Segment (CS) field "Project" with scriptId "custcol_csegir_project" in the Netsuite. This CS field I manually added into the Upsert request XML profile. When executing the process I am facing below error:

 

"First document failure: [Error executing Netsuite operation: org.xml.sax.SAXException: {urn:core_2016_2.platform.webservices.netsuite.com}CustomFieldRef is an abstract type and cannot be instantiated] Unknown failure"

 

The XML request I am using is:

 

<?xml version="1.0" encoding="UTF-8"?>
<ns1:ExpenseReport xmlns:ns1="urn:employees_2016_2.transactions.webservices.netsuite.com" xmlns:ns2="urn:core_2016_2.platform.webservices.netsuite.com" externalId="EXP2517a">
<ns1:customForm internalId="118" />
<ns1:entity externalId="10141" />
<ns1:subsidiary externalId="IRE" />
<ns1:tranDate>2018-05-07T08:00:32.505+01:00</ns1:tranDate>
<ns1:memo>November 2017</ns1:memo>
<ns1:supervisorApproval>1</ns1:supervisorApproval>
<ns1:accountingApproval>1</ns1:accountingApproval>
<ns1:expenseList>
<ns1:expense>
<ns1:category externalId="Personal Car Mileage" />
<ns1:quantity>1</ns1:quantity>
<ns1:rate>51.0000</ns1:rate>
<ns1:currency externalId="AUD" />
<ns1:amount>51.0000</ns1:amount>
<ns1:taxCode internalId="15" />
<ns1:tax1Amt>5.1000</ns1:tax1Amt>
<ns1:department externalId="5C" />
<ns1:class externalId="20" />
<ns1:location externalId="A3" />
<ns1:receipt>1</ns1:receipt>
<ns1:refNumber>122</ns1:refNumber>
<ns1:customFieldList>
<ns2:Employee>
<ns2:value externalId="10141" />
</ns2:Employee>
<ns2:Orig__Purchase_Date>
<ns2:value>2017-11-09T00:00:00.000+00:00</ns2:value>
</ns2:Orig__Purchase_Date>
<ns2:Concur_ER>
<ns2:value>2517a</ns2:value>
</ns2:Concur_ER>
</ns1:customFieldList>
</ns1:expense>
<ns1:expense>
<ns1:category externalId="Personal Car Mileage" />
<ns1:quantity>1</ns1:quantity>
<ns1:rate>22.2000</ns1:rate>
<ns1:currency externalId="AUD" />
<ns1:amount>22.2000</ns1:amount>
<ns1:taxCode internalId="15" />
<ns1:tax1Amt>2.2200</ns1:tax1Amt>
<ns1:department externalId="5C" />
<ns1:class externalId="20" />
<ns1:location externalId="A3" />
<ns1:receipt>1</ns1:receipt>
<ns1:refNumber>123</ns1:refNumber>
<ns1:customFieldList>
<ns2:Employee>
<ns2:value externalId="10141" />
</ns2:Employee>
<ns2:Orig__Purchase_Date>
<ns2:value>2017-11-01T00:00:00.000+00:00</ns2:value>
</ns2:Orig__Purchase_Date>
<ns2:Concur_ER>
<ns2:value>2517a</ns2:value>
</ns2:Concur_ER>
<ns2:customField xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" scriptId="custcol_csegir_project">
<ns2:value internalId="337"></ns2:value>
</ns2:customField>
</ns1:customFieldList>
</ns1:expense>
</ns1:expenseList>
</ns1:ExpenseReport>

 

The request goes through as success without "custcol_csegir_project" field. 

Any help on this highly appreciated?

Outcomes