Skip to main content

Return to Question

added 2 characters in body
Source Link
Abdulla Nilam
Abdulla Nilam
  • 39.7k
  • 18
  • 85
  • 115

Kind of embarrassed to post this here, but I'm at my wits end. I am trying to pull up a Sales Order in Netsuite, searching on a custom filed and using the PHP ToolKit, but have hit a brick wall. I've searched records on custom fields before and haven't had an issue, but this time I'm getting no results. This custom field is a place where we store an outside order number (like if the order came from Amazon or eBay) and I can pull up the record inside of Netsuite (using the GUI) with this custom field. Currently my code looks like this:

$ts = new TransactionSearch(); $tsb = new TransactionSearchBasic(); $oth = new SearchStringCustomField(); $oth->internalId = 69; $oth->searchValue = '700184356'; $oth->operator = 'is'; $cfl = new SearchCustomFieldList(); $cfl->customField = array($oth); $tsb->customFieldList = $cfl; $ts->basic = $tsb; $request = new SearchRequest(); $request->searchRecord = $ts; $response = $ns->search($request);

I've double and triple checked the id of the custom field and also tried using its name instead of id ($oth->scriptId = 'custbody_custbody_storefront_order'$oth->scriptId = 'custbody_custbody_storefront_order'). I get no errors, but also no records are returned. I'm hoping an extra set of eyes can spot what I'm doing wrong.

Custom field name

Kind of embarrassed to post this here, but I'm at my wits end. I am trying to pull up a Sales Order in Netsuite, searching on a custom filed and using the PHP ToolKit, but have hit a brick wall. I've searched records on custom fields before and haven't had an issue, but this time I'm getting no results. This custom field is a place where we store an outside order number (like if the order came from Amazon or eBay) and I can pull up the record inside of Netsuite (using the GUI) with this custom field. Currently my code looks like this:

$ts = new TransactionSearch(); $tsb = new TransactionSearchBasic(); $oth = new SearchStringCustomField(); $oth->internalId = 69; $oth->searchValue = '700184356'; $oth->operator = 'is'; $cfl = new SearchCustomFieldList(); $cfl->customField = array($oth); $tsb->customFieldList = $cfl; $ts->basic = $tsb; $request = new SearchRequest(); $request->searchRecord = $ts; $response = $ns->search($request);

I've double and triple checked the id of the custom field and also tried using its name instead of id ($oth->scriptId = 'custbody_custbody_storefront_order'). I get no errors, but also no records are returned. I'm hoping an extra set of eyes can spot what I'm doing wrong.

Custom field name

Kind of embarrassed to post this here, but I'm at my wits end. I am trying to pull up a Sales Order in Netsuite, searching on a custom filed and using the PHP ToolKit, but have hit a brick wall. I've searched records on custom fields before and haven't had an issue, but this time I'm getting no results. This custom field is a place where we store an outside order number (like if the order came from Amazon or eBay) and I can pull up the record inside of Netsuite (using the GUI) with this custom field. Currently my code looks like this:

$ts = new TransactionSearch(); $tsb = new TransactionSearchBasic(); $oth = new SearchStringCustomField(); $oth->internalId = 69; $oth->searchValue = '700184356'; $oth->operator = 'is'; $cfl = new SearchCustomFieldList(); $cfl->customField = array($oth); $tsb->customFieldList = $cfl; $ts->basic = $tsb; $request = new SearchRequest(); $request->searchRecord = $ts; $response = $ns->search($request);

I've double and triple checked the id of the custom field and also tried using its name instead of id ($oth->scriptId = 'custbody_custbody_storefront_order'). I get no errors, but also no records are returned. I'm hoping an extra set of eyes can spot what I'm doing wrong.

Custom field name

Source Link
John
John
  • 79
  • 2
  • 14

Netsuite PHP find Sales Order using custom field

Kind of embarrassed to post this here, but I'm at my wits end. I am trying to pull up a Sales Order in Netsuite, searching on a custom filed and using the PHP ToolKit, but have hit a brick wall. I've searched records on custom fields before and haven't had an issue, but this time I'm getting no results. This custom field is a place where we store an outside order number (like if the order came from Amazon or eBay) and I can pull up the record inside of Netsuite (using the GUI) with this custom field. Currently my code looks like this:

$ts = new TransactionSearch(); $tsb = new TransactionSearchBasic(); $oth = new SearchStringCustomField(); $oth->internalId = 69; $oth->searchValue = '700184356'; $oth->operator = 'is'; $cfl = new SearchCustomFieldList(); $cfl->customField = array($oth); $tsb->customFieldList = $cfl; $ts->basic = $tsb; $request = new SearchRequest(); $request->searchRecord = $ts; $response = $ns->search($request);

I've double and triple checked the id of the custom field and also tried using its name instead of id ($oth->scriptId = 'custbody_custbody_storefront_order'). I get no errors, but also no records are returned. I'm hoping an extra set of eyes can spot what I'm doing wrong.

Custom field name