Hello, is it possible to get the createdfrom fiel...
# suitescriptp
Phillip
05/29/2020, 11:39 PMHello, is it possible to get the createdfrom field from a vendor bill record? I have tried the following: var soId = search.lookupFields({
"type" : "transaction",
"id" : sourcetran,
"columns" : [ "createdfrom" ]
});
b
battk
05/30/2020, 12:02 AMthat should work out if that transaction has a created from
battk
05/30/2020, 12:02 AMkeep in mind that that the return value of search.lookupFields should be an object
p
Phillip
05/30/2020, 12:09 AMthe vendor bill does not have a native createdfrom. it does return it with a regular saved search
Phillip
05/30/2020, 12:09 AMis there another way to get the value?
b
battk
05/30/2020, 12:27 AMim not sure what you are describing
battk
05/30/2020, 12:27 AMsearch.lookupFields is basically a search
battk
05/30/2020, 12:28 AMfor transactions, it uses columns from the mainline
battk
05/30/2020, 12:28 AMas long as the mainline has a value for the createdfrom column, you should be able to get a value
p
Phillip
05/30/2020, 12:28 AMam I calling it correctly? var potoset = sea[0].getValue('createdfrom');
Phillip
05/30/2020, 12:29 AMI keep on getting the error org.mozilla.javascript.EcmaError: TypeError: Cannot call method "getValue" of undefined (/SuiteScripts/jeamortizationpo.js#99)
b
battk
05/30/2020, 12:33 AMyou might want to look at it from a debugger
battk
05/30/2020, 12:33 AMits an object, where the key is the intenralid of the column
battk
05/30/2020, 12:33 AMand the value of the key should be an array
p
Phillip
05/30/2020, 12:35 AMok. there should only be one result for the array
b
battk
05/30/2020, 12:35 AMyes, the array should have 1 element, an object
battk
05/30/2020, 12:36 AMwhich has a value and text key
2 Views