Hello! Does anyone know how is a Contact associate...
# suitescript
j
Hello! Does anyone know how is a Contact associated to Transaction record if the Contact is created from Transaction? We wanted to display all the contacts through a transaction saved search but unable to find the field. Or if the Subtab: Relationship > Contacts is accessible through script? SuiteAnswer is of no help. TIA
e
Need to create a Contact search and use the Transaction join. (Note: There are two joins) See 1.0 code below:
Copy code
var contactSearch = nlapiSearchRecord("contact",null,
[
   ["transaction.internalidnumber","equalto","8337"]
],
[
   new nlobjSearchColumn("entityid").setSort(false),
   new nlobjSearchColumn("email"),
   new nlobjSearchColumn("phone"),
   new nlobjSearchColumn("altphone"),
   new nlobjSearchColumn("fax"),
   new nlobjSearchColumn("company"),
   new nlobjSearchColumn("altemail"),
   new nlobjSearchColumn("internalid","transaction",null),
   new nlobjSearchColumn("tranid","transaction",null),
   new nlobjSearchColumn("recordtype","transaction",null),
   new nlobjSearchColumn("type","transaction",null)
]
);