{"type":"error.SuiteScriptError","name":"INVALID_PAGE_RANGE","message":"Invalid page range: fetch.","id":null,"stack":["Error"," at searchTransactions (/SuiteScripts/_Suitelet 2x Item Purchasing Report AlJomaih.js10672)"," at createForm (/SuiteScripts/_Suitelet 2x Item Purchasing Report AlJomaih.js51638)"," at handleScriptCall (/SuiteScripts/_Suitelet 2x Item Purchasing Report AlJomaih.js25220)"," at Object.onRequest (/SuiteScripts/_Suitelet 2x Item Purchasing Report AlJomaih.js21613)"],"cause":{"name":"INVALID_PAGE_RANGE","message":"Invalid page range: fetch."},"notifyOff":false,"userFacing":true} function searchTransactions(itemid) { let transactionSearch = search.create({ type: search.Type.TRANSACTION, filters: [ ["type", "anyof", ["CashRfnd", "CashSale", "CustCred", "CustInvc"]], "AND", ["mainline", "is", "F"], "AND", ["taxline", "is", "F"], "AND", ["shipping", "is", "F"], "AND", ["cogs", "is", "F"], "AND", ["status", "noneof", ["CashSale:A", "CustRfnd:R", "CustRfnd:V", "CustInvc:D", "CustInvc:E", "CustInvc:V"]], "AND", ["item", "anyof", [itemid]] ], columns: [ { name: "item", summary: search.Summary.GROUP }, { name: "custitem_atc_item_brand", join: "item", summary: search.Summary.GROUP }, { name: "quantity", summary: search.Summary.SUM }, { name: "quantity", summary: search.Summary.AVG } ] }); const results = transactionSearch.runPaged({ pageSize: 1000 }).fetch({ index: 0 }).data.map(result => ({ item: result.getValue({ name: 'item', summary: search.Summary.GROUP }), brand: result.getValue({ name: 'custitem_atc_item_brand', join: 'item', summary: search.Summary.GROUP }), totalQuantity: result.getValue({ name: 'quantity', summary: search.Summary.SUM }), averageSales: result.getValue({ name: 'quantity', summary: search.Summary.AVG }) })); log.debug('Search Results', results); return { searchResults: results }; }

AI generated answer (using internal Slack threads):

Based on the conversations, there are several issues being discussed: 1. The first thread is about a problem with a transaction search in NetSuite where the user is trying to filter by Billing Address Internal ID or a custom field on the Address record. The user is not getting any results and suspects it might be a bug. 2. The second thread is about a search that is returning duplicate results. The user is trying to find inventory in one location only, but the search is returning the same result on two different lines. Another user suggests that this might be due to a join that returns several possible values. 3. The third thread is about an error (

SSS_INVALID_SRCH_OPERATOR

) that a user is encountering when running a search in a User Event script. The error message suggests that there is an invalid operator in the search filter for the "item" field. Another user suggests changing the parameter to

[\"item\",\"anyof\",22,332,42)]

. Please note that these are interpretations of the issues based on the provided conversations and may not fully capture the problems the users are facing.