{"type":"error.SuiteScriptError","name":"SSS_INVALID_SRCH_OPERATOR","message":"An nlobjSearchFilter contains an invalid operator, or is not in proper syntax: join.","id":null,"stack":["Error"," at searchTransactions (/SuiteScripts/_Suitelet 2x Item Purchasing Report AlJomaih.js8140)"," at createForm (/SuiteScripts/_Suitelet 2x Item Purchasing Report AlJomaih.js50938)"," at handleScriptCall (/SuiteScripts/_Suitelet 2x Item Purchasing Report AlJomaih.js24520)"," at Object.onRequest (/SuiteScripts/_Suitelet 2x Item Purchasing Report AlJomaih.js20913)"],"cause":{"name":"SSS_INVALID_SRCH_OPERATOR","message":"An nlobjSearchFilter contains an invalid operator, or is not in proper syntax: join."},"notifyOff":false,"userFacing":true} let transactionSearch = search.create({ type: search.Type.TRANSACTION, filters: [ ["type", "anyof", ["CashRfnd", "CashSale", "CustCred", "CustInvc"]], "AND", ["mainline", "is", "F"], "AND", ["type", "join", "item", "anyof", ["InvtPart"]], "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 } ] });

AI generated answer (using internal Slack threads):

The error

SSS_INVALID_SRCH_OPERATOR

is thrown when an

nlobjSearchFilter

contains an invalid operator or is not in proper syntax. In the provided code, the error is thrown because of the incorrect usage of the

join

operator in the search filter. In NetSuite, the

join

operator is used to create a join with another record type. However, the join should be a valid join as per the NetSuite Records Browser. For example, in the provided code, the join

["type", "join", "item", "anyof", ["InvtPart"]]

is incorrect because

type

is not a valid field to join with

item

. To fix this issue, you need to ensure that the field you are trying to join is a valid join field. You can check the valid join fields in the NetSuite Records Browser. For example, if you are searching on the

transaction

record type, you should check the page for

transaction

in the Records Browser to see the valid join fields. Here is the corrected code:

javascript
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 } 
    ] 
});

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******