Hi
We have problem with the smart count review page.
Tha page stay in loading
Any idea?
The error is:
Error while loading Count Review Page
{"type":"error.SuiteScriptError","name":"SSS_SEARCH_ERROR_OCCURRED","message":"Se produjo un error de búsqueda: Failed to parse SQL [SELECT id from location where id = 6,75,61,63,62,59,60,73,64 and isinactive = 'F' union SELECT id from location where isinactive = 'F' start with parent = 6,75,61,63,62,59,60,73,64 connect by prior id = parent]: syntax error, state:2137(10102) near: ,(1,37, token code:0)","id":null,"stack":["SSS_SEARCH_ERROR_OCCURRED: Se produjo un error de búsqueda: Failed to parse SQL [SELECT id from location where id = 6,75,61,63,62,59,60,73,64 and isinactive = 'F' union SELECT id from location where isinactive = 'F' start with parent = 6,75,61,63,62,59,60,73,64 connect by prior id = parent]: syntax error, state:2137(10102) near: ,(1,37, token code:0)"," at Object.createError [as nlapiCreateError] (https://account_id.app.netsuite.com/javascript/suitescript/2.0/client/N.js?NS_VER=2024.2&minver=15&buildver=30050:828:16)"," at Object.createError [as create] (https://account_id.app.netsuite.com/javascript/suitescript/2.0/client/N.js?NS_VER=2024.2&minver=15&buildver=30050:2108:39)"," at invokeOn (https://account_id.app.netsuite.com/javascript/suitescript/2.0/client/N.js?NS_VER=2024.2&minver=15&buildver=30050:2368:47)"," at runSuiteQLInternalForScriptId (https://account_id.app.netsuite.com/javascript/suitescript/2.0/client/N.js?NS_VER=2024.2&minver=15&buildver=30050:18337:15)"," at Object.runSuiteQL (https://account_id.app.netsuite.com/javascript/suitescript/2.0/client/N.js?NS_VER=2024.2&minver=15&buildver=30050:18310:11)"," at u.executeQuery (https://account_id.app.netsuite.com/app/common/scripting/scriptmodule.nl?