Hi all, in SS2.0 I am trying to do a lookup for th...
# suitescript
n
Hi all, in SS2.0 I am trying to do a lookup for the 'Use bins' checkbox on the location record. Using this syntax:
Copy code
var location_bins= search.lookupFields({
									    	    	type: search.Type.LOCATION,
									    	    	id: location_id,
									    	    	columns: ["usebins"] 
									    	    	});
This always gives me an error:
Copy code
{
   type: "error.SuiteScriptError",
   name: "SSS_INVALID_SRCH_COL",
   message: "An nlobjSearchColumn contains an invalid column, or is not in proper syntax: usebins.",
   stack: [
      "doLookupFields(N/searchUtil)",
      "<anonymous>(/SuiteScripts/Bin Putaway Worksheet/SLE_Multiple_BinPutaway_v1.0.js:167)",
      "each(N/searchObject)",
      "onRequest(/SuiteScripts/Bin Putaway Worksheet/SLE_Multiple_BinPutaway_v1.0.js:161)"
   ],
   cause: {
      type: "internal error",
      code: "SSS_INVALID_SRCH_COL",
      details: "An nlobjSearchColumn contains an invalid column, or is not in proper syntax: usebins.",
      userEvent: null,
      stackTrace: [
         "doLookupFields(N/searchUtil)",
         "<anonymous>(/SuiteScripts/Bin Putaway Worksheet/SLE_Multiple_BinPutaway_v1.0.js:167)",
         "each(N/searchObject)",
         "onRequest(/SuiteScripts/Bin Putaway Worksheet/SLE_Multiple_BinPutaway_v1.0.js:161)"
      ],
      notifyOff: false
   },
   id: "",
   notifyOff: false
}
Any other field on the location field will work when I do a lookup. The field ID : usebins is correct and I can get the value in the console if I use SS1.0 syntax nlapiGetFieldValue('usebins'). Any idea what i may be doing wrong?