Hey guys,
I'm trying to figure out why I can't call the results of a saved search I created into a custom suitelet I have written up via nlapiSearchRecord. Every time I attempt to do so I run into an "Unexpected Suitelet Error" and the script halts. The search itself runs fine when I bring it up in NetSuite proper, so I can't understand why it's having so much trouble in the script.
The issue seems to lie in a number formula column that I set up to calculate an amount to include an expected shrink value. I'll paste the SQL code from that column here, since I believe it's what's causing the code to halt.
MAX({quantityonhand})+SUM(CASE {transaction.type} WHEN 'Purchase Order' THEN {transaction.quantity} ELSE 0 END)-SUM(CASE {transaction.type} WHEN 'Work Order' THEN ROUND((-1*{transaction.quantity})/(1-{transaction.custcol_compstdshrink}), 2) ELSE 0 END )
Any offhand insights on what might be the problem here?