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,

Did you find a solution regarding this issue?

Best,

Caroline

Rookie Answered on December 11, 2019.
Add Comment

Your Answer

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