I am loading a search into a map reduce. Screensho...
# suitescript
j
I am loading a search into a map reduce. Screenshot of results tab included. This works completely fine within Netsuite. When I log the search within the map/reduce, it doesn't return the second numeric formula. (Screenshot of logging included as well). Do I need to do something different in NetSuite? I've tried just grabbing the values and the second formula returns nothing as a value.
I found the SuiteAnswers to use "formulanumeric_1" to get the second formula but that did not work.
s
I think you need to modify the search in getInput and change the type of the second formula to something like formulanumeric_1
j
You mean create the search in the getinput instead of loading in a search? I'll try again. I did that previously and it kept telling me that my formula was invalid even though I copied exactly what was in the UI. Damn NetSuite.
s
you can load the search and just modify that one column instead of completely recreating it
j
Hm, I was able to manipulate the search but now it won't trigger the map stage. Going to walk away for a while and try again later.