Create a NetSuite search object to retrieve the status and document number of the sales order associated with the return authorization records.

function (search) { 

        function searchSalesOrder(rmaId) { 

            try { 

                let returnauthorizationSearchObj = search.create({ 

                    type: “returnauthorization”, 

                    filters: 

                        [ 

                            [“type”, “anyof”, “RtnAuth”], 

                            “AND”, 

                            [“internalid”, “anyof”, rmaId], 

                            “AND”, 

                            [“mainline”, “is”, “T”] 

                        ], 

                    columns: 

                        [ 

                            search.createColumn({ 

                                name: “custbody_jj_exchg_sales_order_ahap1625”, 

                                summary: “MAX”, 

                                label: “Exchange Sales Order” 

                            }), 

                            search.createColumn({ 

                                name: “statusref”, 

                                join: “CUSTBODY_JJ_EXCHG_SALES_ORDER_AHAP1625”, 

                                summary: “MAX”, 

                                label: “Status” 

                            }), 

                            search.createColumn({ 

                                name: “tranid”, 

                                join: “CUSTBODY_JJ_EXCHG_SALES_ORDER_AHAP1625”, 

                                summary: “MAX”, 

                                label: “Document Number” 

                            }) 

                        ] 

                }); 

                let searchResultCount = returnauthorizationSearchObj.runPaged().count; 

                if (searchResultCount > 0) { 

                    let dataObj = {}; 

                    returnauthorizationSearchObj.run().each(function (result) { 

                        dataObj.status = result.getValue({ 

                            name: “statusref”, join: “CUSTBODY_JJ_EXCHG_SALES_ORDER_AHAP1625”, summary: “MAX”, label: “Status” 

                        }); 

                        dataObj.docNumber = result.getValue({ 

                            name: “tranid”, join: “CUSTBODY_JJ_EXCHG_SALES_ORDER_AHAP1625”, summary: “MAX”, label: “Document Number” 

                        }); 

                        return true; 

                    }); 

                    return dataObj; 

                } 

                else { 

                    return {}; 

                } 

            } 

            catch (err) { 

                console.error(“error@searchSalesOrder”, err); 

                return {}; 

            } 

        } 

Leave a comment

Your email address will not be published. Required fields are marked *