Hi,
I have run into an issue with retrieving the column based on a new Date custom entity field for the Customer record. Most concerning is the bizarre behavior of the NetSuite Web Service.
Using 2016_2 WSDL.
New entity field: custentity_sc_cust_at_risk, type Date, as seen below
[ATTACH=JSON]{"data-align":"none","data-size":"large","data-attachmentid":424197}[/ATTACH]
This field is present on the Customer form and accessible. However, most of the time when performing a search through the Web Services, I'm receiving the error
<?xml version="1.0" encoding="utf-8"?> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <soapenv:Header> <platformMsgs:documentInfo xmlns:platformMsgs="urn:messages_2016_2.platform.webservices.netsuite.com"> <platformMsgs:nsId>WEBSERVICES_3624522_061620171306794252338827884_83d1aefdd800</platformMsgs:nsId> </platformMsgs:documentInfo> </soapenv:Header> <soapenv:Body> <searchResponse xmlns="urn:messages_2016_2.platform.webservices.netsuite.com"> <platformCore:searchResult xmlns:platformCore="urn:core_2016_2.platform.webservices.netsuite.com"> <platformCore:status isSuccess="false"> <platformCore:statusDetail type="ERROR"> <platformCore:code>INVALID_SEARCH_FIELD_OBJ</platformCore:code> <platformCore:message>custentity_sc_cust_at_risk is not a valid search custom field</platformCore:message> </platformCore:statusDetail> </platformCore:status> </platformCore:searchResult> </searchResponse> </soapenv:Body> </soapenv:Envelope>
The search request generating this is:<?xml version="1.0" encoding="UTF-8"?> <Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="urn:core_2016_2.platform.webservices.netsuite.com" xmlns:ns2="urn:common_2016_2.platform.webservices.netsuite.com" xmlns:ns3="urn:relationships_2016_2.lists.webservices.netsuite.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns4="urn:messages_2016_2.platform.webservices.netsuite.com" xmlns:ns5="ns"> <Header> <searchPreferences xsi:type="SearchPreferences"> <bodyFieldsOnly>false</bodyFieldsOnly> <returnSearchColumns>true</returnSearchColumns> <pageSize>200</pageSize> </searchPreferences> <tokenPassport xsi:type="TokenPassport"> ... </tokenPassport> </Header> <Body> <search> <searchRecord xsi:type="CustomerSearchAdvanced"> <criteria> <basic> <lastModifiedDate operator="within"> <searchValue>2017-06-16T17:00:01.000+00:00</searchValue> <searchValue2>2017-06-16T18:13:11.000+00:00</searchValue2> </lastModifiedDate> <stage operator="anyOf"> <searchValue>_customer</searchValue> </stage> <subsidiary operator="anyOf"> <searchValue internalId="2" type="subsidiary"/> </subsidiary> </basic> </criteria> <columns> <basic> <billAddress1/> <billAddress2/> <billCity/> <billCountryCode/> <billState/> <billZipCode/> <companyName/> <creditLimit/> <entityId/> <entityStatus/> <fax/> <internalId/> <isInactive/> <lastModifiedDate/> <parent/> <phone/> <salesRep/> <salesTeamMember/> <salesTeamRole/> <terms/> <customFieldList> <customField scriptId="custentity_sc_common_name" xsi:type="SearchColumnStringCustomField"/> <customField scriptId="custentity_sc_dba_name" xsi:type="SearchColumnStringCustomField"/> <customField scriptId="custentity_sc_custom_msa" xsi:type="SearchColumnStringCustomField"/> <customField scriptId="custentity_sc_custom_msa_editor" xsi:type="SearchColumnSelectCustomField"/> <customField scriptId="custentity_sc_kw_overage_price" xsi:type="SearchColumnDoubleCustomField"/> <customField scriptId="custentity_sc_multirack_drawcap" xsi:type="SearchColumnBooleanCustomField"/> <customField scriptId="custentity_sc_billing_status" xsi:type="SearchColumnSelectCustomField"/> <customField scriptId="custentity_sc_primary_admin" xsi:type="SearchColumnSelectCustomField"/> <customField scriptId="custentity_sc_primary_technical" xsi:type="SearchColumnSelectCustomField"/> <customField scriptId="custentity_sc_primary_billing" xsi:type="SearchColumnSelectCustomField"/> <customField scriptId="custentity_sc_cust_saleseng" xsi:type="SearchColumnSelectCustomField"/> <customField scriptId="custentity_sc_cust_implmgr" xsi:type="SearchColumnSelectCustomField"/> <customField scriptId="custentity_sc_allow_portal_ach_edit" xsi:type="SearchColumnBooleanCustomField"/> <customField scriptId="custentity_sc_allow_portal_cc_edit" xsi:type="SearchColumnBooleanCustomField"/> <customField scriptId="custentity_sc_allow_portal_otc" xsi:type="SearchColumnBooleanCustomField"/> <customField scriptId="custentity2" xsi:type="SearchColumnSelectCustomField"/> <customField scriptId="custentity_sc_hold_invoices" xsi:type="SearchColumnBooleanCustomField"/> <customField scriptId="custentity_sc_hold_invoice_reason" xsi:type="SearchColumnStringCustomField"/> <customField scriptId="custentity_sc_ach_shadow" xsi:type="SearchColumnSelectCustomField"/> <customField scriptId="custentity_sc_cust_at_risk" xsi:type="SearchColumnDateCustomField"/> </customFieldList> </basic> <contactJoin> <internalId/> <isInactive/> </contactJoin> <contactPrimaryJoin> <internalId/> </contactPrimaryJoin> </columns> </searchRecord> </search> </Body> </Envelope>
Occasionally the error is not reported, but the response does not include the custentity_sc_cust_at_risk field.