RE: Netsutie search purchase requisition doesnt returns line item custom field through apieven though custom fields are present in UI

Hi Sir/madam,

I am searching purchase requisition using internal id using TBA. But it doesnt returns line item custom fields.

Here is my request

<env:Body>
<platformMsgs:search>
<platformMsgs:searchRecord xsi:type=”transactionsSales:TransactionSearchAdvanced”>
<transactionsSales:criteria>
<transactionsSales:basic>
<platformCommon:internalId operator=”anyOf”>
<platformCore:searchValue internalId=”91222″/>
</platformCommon:internalId>
<platformCommon:type operator=”anyOf”>
<platformCore:searchValue>_requisition</platformCore:searchValue>
</platformCommon:type>
</transactionsSales:basic>
</transactionsSales:criteria>
</platformMsgs:searchRecord>
</platformMsgs:search>
</env:Body>

Here is my response

<platformCore:recordList>
<platformCore:record internalId=”91222″ xsi:type=”tranPurch:PurchaseRequisition” xmlns:tranPurch=”urn:purchases_2019_2.transactions.webservices.netsuite.com”>
<tranPurch:createdDate>2019-02-07T06:30:19.000-08:00</tranPurch:createdDate>
<tranPurch:lastModifiedDate>2019-11-27T04:13:27.000-08:00</tranPurch:lastModifiedDate>
<tranPurch:currencyName>USA</tranPurch:currencyName>
<tranPurch:estimatedTotal>575.0</tranPurch:estimatedTotal>
<tranPurch:status>Pending Order</tranPurch:status>
<tranPurch:currency internalId=”1″>
<platformCore:name>USA</platformCore:name>
</tranPurch:currency>
<tranPurch:entity internalId=”-5″>
<platformCore:name>CJ TEST 123</platformCore:name>
</tranPurch:entity>
<tranPurch:tranDate>2019-02-06T10:30:00.000-08:00</tranPurch:tranDate>
<tranPurch:tranId>30</tranPurch:tranId>
<tranPurch:subsidiary internalId=”1″>
<platformCore:name>Honeycomb Mfg.</platformCore:name>
</tranPurch:subsidiary>
<tranPurch:department internalId=”1″>
<platformCore:name>Admin</platformCore:name>
</tranPurch:department>
<tranPurch:total>575.0</tranPurch:total>
<tranPurch:itemList>
<tranPurch:purchaseRequisitionItem>
<tranPurch:line>2</tranPurch:line>
<tranPurch:item internalId=”3238″>
<platformCore:name>556661</platformCore:name>
</tranPurch:item>
<tranPurch:quantity>5.0</tranPurch:quantity>
<tranPurch:description>TestCustom</tranPurch:description>
<tranPurch:estimatedRate>115.0</tranPurch:estimatedRate>
<tranPurch:estimatedAmount>575.0</tranPurch:estimatedAmount>
<tranPurch:rate>115.00</tranPurch:rate>
<tranPurch:amount>575.0</tranPurch:amount>
<tranPurch:isBillable>false</tranPurch:isBillable>
<tranPurch:isClosed>false</tranPurch:isClosed>
<tranPurch:expandItemGroup>false</tranPurch:expandItemGroup>
</tranPurch:purchaseRequisitionItem>
</tranPurch:itemList>
<tranPurch:customFieldList>
<platformCore:customField internalId=”5530″ scriptId=”custbody107″ xsi:type=”platformCore:BooleanCustomFieldRef”>
<platformCore:value>false</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId=”700″ scriptId=”custbody11″ xsi:type=”platformCore:BooleanCustomFieldRef”>
<platformCore:value>false</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId=”5541″ scriptId=”custbody110″ xsi:type=”platformCore:DateCustomFieldRef”>
<platformCore:value>2019-11-20T10:30:00.000-08:00</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId=”5021″ scriptId=”custbody60″ xsi:type=”platformCore:BooleanCustomFieldRef”>
<platformCore:value>false</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId=”5029″ scriptId=”custbody61″ xsi:type=”platformCore:SelectCustomFieldRef”>
<platformCore:value internalId=”1″ typeId=”-112″>
<platformCore:name>1000 Checking</platformCore:name>
</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId=”5400″ scriptId=”custbody69″ xsi:type=”platformCore:StringCustomFieldRef”>
<platformCore:value>Kamesh Krishna</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId=”4910″ scriptId=”custbody_cseg14″ xsi:type=”platformCore:SelectCustomFieldRef”>
<platformCore:value internalId=”1″ typeId=”505″>
<platformCore:name>value1</platformCore:name>
</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId=”4696″ scriptId=”custbody_cseg4″ xsi:type=”platformCore:SelectCustomFieldRef”>
<platformCore:value internalId=”1″ typeId=”487″>
<platformCore:name>netsuite</platformCore:name>
</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId=”4744″ scriptId=”custbody_cseg9″ xsi:type=”platformCore:SelectCustomFieldRef”>
<platformCore:value internalId=”3″ typeId=”499″>
<platformCore:name>servicenow segment</platformCore:name>
</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId=”220″ scriptId=”custbody_powf_ctrl_ok” xsi:type=”platformCore:BooleanCustomFieldRef”>
<platformCore:value>false</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId=”223″ scriptId=”custbody_powf_se_ok” xsi:type=”platformCore:BooleanCustomFieldRef”>
<platformCore:value>false</platformCore:value>
</platformCore:customField>
</tranPurch:customFieldList>
</platformCore:record>
</platformCore:recordList>

Here you can see the response doesnt have custom fields under itemlist

Meenakshi Rookie Asked on November 27, 2019 in SuiteTalk.
Add Comment
2 Answers

HI Meenakshi,

Some Fields are not populated when doing searches.

Try using getRecord(s) endpoint and see if that returns more data.

Also make sure that the form that the document is currently using has this field visible.

Rookie Answered on February 17, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.