In a Map Reduce script, why am I getting the error

Cannot find function setCurrentSublistValue in object standard record.","stack":["createError(N/error)"],"cause":{"message":"Cannot find function setCurrentSublistValue in object standard record.

The relevant code is below. I am trying to simply copy the lines from an Invoice -> New Opportunity record.

log.debug({
                title: 'Begin Create Opportunity',
                details: '.'
            }); 
            var params = {};
            params.inactiveItem = '';
            log.debug({
                title: 'params',
                details: JSON.stringify(params)
            });
            log.debug({
                title: 'create opportunity',
                details: JSON.stringify(opportunityData)
            });
            var invoice = record.load({
                type: record.Type.INVOICE,
                id: invoiceIdee,
                isDynamic: true
            });

            var totalLines = invoice.getLineCount("item");
            
            var rec = record.create({
                type: record.Type.OPPORTUNITY
            });

            rec.setValue('title', opportunityData.opportunityname);
            rec.setValue('entity', opportunityData.customerid);
            rec.setValue('memo', opportunityData.memo);
            rec.setValue('custbodyend_customer', opportunityData.endCustomer ? opportunityData.endCustomer : '');
            rec.setValue(CUSTOM_FIELDS.BUSINESS_TYPE, 3);

            if (!isNullOrEmpty(opportunityData.expectedCloseDate)) {
                rec.setValue('expectedclosedate', opportunityData.expectedCloseDate);
            }

            for (var ii = 0; ii < totalLines; ii++) {
                rec.insertLine({
                    sublistId: 'item',
                    line: ii,
                });

                // var isInactive = opportunityData.lineItem[ii].isInactive == 'T' || '';
                // var displayName = opportunityData.lineItem[ii].itemDisplayName || '';
                var isInactive = '';
                var displayName = '';

                if (!isNullOrEmpty(isInactive) && !isNullOrEmpty(params.inactiveItem)) {
                    rec.setCurrentSublistValue({
                        sublistId: 'item',
                        fieldId: 'item',
                        value: params.inactiveItem
                    });
                    rec.setCurrentSublistValue({
                        sublistId: 'item',
                        fieldId: 'description',
                        value: displayName
                    });
                } else {
                    rec.setCurrentSublistValue({
                        sublistId: 'item',
                        fieldId: 'item',
                        value: opportunityData.lineItem[ii].item
                    });
                }

                rec.setCurrentSublistValue({
                    sublistId: 'item',
                    fieldId: 'quantity',
                    value: opportunityData.lineItem[ii].quantity
                });
                // rec.setCurrentSublistValue('item', CUSTOM_COLUMNS.START_DATE, opportunityData.lines[ii].startDate || '');
                // rec.setCurrentSublistValue('item', CUSTOM_COLUMNS.END_DATE, opportunityData.lines[ii].endDate || '');
                rec.setCurrentSublistValue({
                    sublistId: 'item',
                    fieldId: CUSTOM_COLUMNS.SERIAL,
                    value: opportunityData.lineItem[ii].serial
                });
                rec.commitLine({
                    sublistId: 'item'
                });
            }

How to return the file from the suitelet to another script like map-reduce? response.writeFile()?

Hi all, I need to create a suitelet that will allow me to create a PO based on an item’s suggested quantity. Is there a way for me to get a saved search that will group by item, and get their suggested quantity? The quantity should be based off of the demand plan that we put into the system.

HI , From client script on save record, i am setting new lines on to the record. But the lines are not committing instead of that its overriding the same line. And it was working before from yesterday onwards its not working, any suggestions on this?

Hi, so I'm creating a suitelet where a user is inserting values that are passed to a log list, i want to be able to load the log list records back to the suitelet form (somewhere amity the behaver in transaction item sub list) so i can preform CRUD actions inside the form and load the changes back to the log list. i created a search on the log list and im trying to insert the line to the form.... it's not working, please help 🙂 i think mt approach is totally wrong.... End result is 3 sub lists in one form all actioning the log record

let logSearchObj = search.create({
                    type: "xxx_log",
                    filters: [],
                    columns:
                        [
                            search.createColumn({name: "", label: ""}),
                            search.createColumn({name: "", label: ""}),
                            search.createColumn({name: "", label: ""}),
                            search.createColumn({name: "", label: ""})]
                });

logSearchObj.run().each(function(result){
    for(let i=0; i<result.columns.length;i++){
        let val = result.getValue({
            name: result.columns[i].name
        });

        scriptDeployment.insertLine({
            sublistId: id,
            line: i,
        });
        scriptDeployment.setCurrentSublistValue({
            sublistId: id,
            fieldId: recSublistIdsArr[i],
            value: val
        });
        scriptDeployment.commitLine({
            sublistId: 'id'
        });


    }

Hey all, I have a script that is using record.attach at try and attach credit memo to sales orders, however I am getting the error 'Attaching of record type creditmemo to salesorder is not supported', is there any way to attach these records together via script?

I found the SuiteAnswers to use "formulanumeric_1" to get the second formula but that did not work.

How do I convert a Base64 String to a PDF file using Suitescript 2.0? I need to send the files as email attachments but I receive them as Base64 strings

This message was deleted.

Am I able to set the lines of a sublist of type

serverWidget.FieldType.LIST

in a client script?

Is there a best practice to delay/retry a http call to an external API in a map reduce script? Or do I just use a datetime.now + 5 second in a while loop?

does anybody have experience with pulling FORECAST data (automated) out of Netsuite for my data warehouse?

Can I trigger a suitelet in a user event aftersubmit without redirecting to said suitelet? Use case is that I'm trying to use a UE to trigger another UE with the suitelet as the in between. But I don't need users going to the suitelet. Want this to all be background stuff they don't even notice.

Nope you can't return the value of what the user entered in a suitelet without doing a POST. Also you need to use quotes in your 'searchorder("' + currentstartdate + '")' call

how to handle a restlet that is giving usage limit exceed in 1.0

Do you use 3rd party libraries to validate json input in restlet? If so can you share any links?

What's the benefit of creating Saved Searches via Suitescript? I've been using Saved Searches in UI only, and now I'm thinking I may resolve more complex scenarios if I learn Suitescript.

anybody have experience automating a solution that resutls in the parsing of a netsuite report result set?

This message was deleted.

Got an error email ([NetSuite Script Error])... but when I go into the script logs, there is no error at all. Anyone seen this before?

This message was deleted.

Hey all - we are randomly getting an error when submitting an external form that is "Script Execution Usage Limit Exceeded" - nothing has changed on the external form in months, and we have never seen this error. Can someone please help?

I'm working Sutiescript example of add a bill address and ship address to the record when transform the sales order to invoice. my code doesn't work: var transformRecord = record.transform({ fromType: record.Type.SALES_ORDER, fromId: salesOrder.id, toType: record.Type.INVOICE, isDynamic: false }); transformRecord.setValue({fieldId: "billAddress",value: "address sample"}); transformRecord.setValue({fieldId: "billingAddress_text",value: "address sample"});

Have you included the N/http module so that you can use that enum? The documentation also states that you need the option "id" for suitelets. It should be the deployment id.

context.response.sendRedirect({
  type: http.RedirectType.SUITELET,
  identifier: 'customscript761',
  id: 'customdeploymentXX', //or maybe the internalid of the script deployment
  parameters: { entity: 8 },
})

To the best of my knowledge redirect is not part of context.response, redirect is a method of the n/redirect module. So it cannot call toSuitelet of "context.response.redirect" Try removing "context.response."

Hello, what criteria do you guys use to return search results with multiselect field not being empty in SS2? I tried

[fieldId, search.Operator.NONEOF, '@NONE@']

and

[fieldId, search.Operator.ISNOTEMPTY, '']

, but both of them seem to have no effect and search returns all results regardless of multiselect value.

I need to generate barcode using SuiteScript (Suitelet) without using adv PDF. Is this possible? any library?

hi everyone, I have this question. I am trying to run an N/query query using join. I have this bank payment record that has fields joined to other records like gateway (custom), batchid (custom), and transaction (ns). When I do autojoin with custom records and try to get other fields it works ok but it fails when i try to reference the transaction field.

“SSS_SEARCH_ERROR_OCCURRED”

“Search error occurred: Record Join ‘custrecord_bankpay_record’ for record ‘CUSTOMRECORD_BANKPAY’ was not found.”