NetSuite定时脚本更新发票行项目数量报错求助

Let's break down why you're hitting that USER_ERROR and fix your script step by step—this is a common gotcha with NetSuite sublists!

What's Triggering the Error? #

This message pops up because your script is trying to interact with a sublist line that doesn't exist (or isn't targeted correctly) when using dynamic mode. NetSuite interprets this as you trying to add a new line item without selecting an item for it.

Key Issues in Your Current Code #

1. Wrong Sublist Line Index
   NetSuite sublist lines are zero-indexed. Since each invoice only has one line item, using line : 1 is trying to select the second line (which doesn't exist). That's why the system thinks you're trying to add a new line without picking an item.

2. Overcomplicating with Dynamic Mode
   You're using isDynamic: true when loading the invoice, but for updating existing sublist lines, non-dynamic mode is simpler and less error-prone. You don't need to mess with selectLine/commitLine calls in non-dynamic mode.

3. Potential Field Reference Mistake
   The field path custentitynumber_lives.customer looks off. Double-check your saved search: if you're pulling a custom quantity field from the linked customer record, the correct field ID should likely be just custentitynumber_lives (no .customer suffix). A wrong reference here could pull an invalid value, making the update fail silently or trigger unexpected errors.

Corrected Script #

Here's the revised version with all fixes applied:

/**
*@NApiVersion 2.x
*@NScriptType ScheduledScript
*/
define(['N/search', 'N/record', 'N/email', 'N/runtime'],
function(search, record, email, runtime) {
    function execute(context) {
        var searchid = runtime.getCurrentScript().getParameter({'name': 'custscript_customsearch630'});
        var invoiceSearch = search.load({'id': searchid});
        
        invoiceSearch.run().each(function(result){
            // Fix: Use the correct field ID for your customer quantity field
            var newQuantity = result.getValue({'name': 'custentitynumber_lives'});
            var invoiceId = result.getValue({'name': 'internalid'});
            
            // Fix: Load invoice in non-dynamic mode for straightforward updates
            var invoice = record.load({
                type: record.Type.INVOICE,
                id: invoiceId,
                isDynamic: false
            });
            
            var sublistId = 'item';
            // Fix: Target the first (and only) line with index 0
            invoice.setSublistValue({
                sublistId: sublistId,
                fieldId: 'quantity',
                line: 0,
                value: newQuantity
            });
            
            // Save without ignoreMandatoryFields unless you explicitly need it
            invoice.save();
            
            return true;
        });
    }

    return {
        execute: execute
    };
});

Quick Tips to Avoid Future Headaches #

• Test with One Invoice First: Run the script against a single test invoice before rolling it out to all records—this lets you confirm the quantity updates correctly and catch any remaining issues.
• Validate Your Saved Search: Make sure the search returns only invoices with exactly one line item, and that the quantity field is pulling valid numeric values.
• Double-Check Field IDs: Use NetSuite's Customization menu to confirm the exact ID of your customer quantity field—typos here are one of the most common causes of these kinds of errors.

内容的提问来源于stack exchange，提问作者Logan