NetSuite脚本问题：批量履约字段未填充及Item Name赋值失败

Hey there, let's break down your NetSuite scripting issues step by step—since you're new to this, I'll keep things clear and actionable.

1. Why Your Manual Fulfillment Has a Missing Item Name #

The nlapiGetCurrentLineItemText('item', 'item') function only pulls data from an active/selected line item on the item sublist when the pageInit event fires. When you land on the Fulfill Sales Order page, the first line item isn't always automatically selected by default. That's why your custbody_itemsku field stays empty—there's no "current line" to fetch the name from.

Quick Fix for Manual Fulfillment #

Instead of relying on the current line, grab the first line item's name directly using line number 1 (NetSuite sublist lines start at 1). Add a safety check for empty line items too:

function pageInit() { 
  var lineCount = nlapiGetLineItemCount('item');
  var category = '';
  var sku = '';

  // Only pull line data if there are items present
  if (lineCount > 0) {
    category = nlapiGetLineItemText('item', 'class', 1);
    sku = nlapiGetLineItemText('item', 'item', 1);
  }

  nlapiSetFieldValue('custbody_itemcategory', category); 
  nlapiSetFieldValue('custbody_itemsku', sku); 
  nlapiSetFieldValue('custbody_skucount', lineCount); 
}

2. Why Bulk Fulfillment Isn't Working At All #

This is the critical issue for your daily 100-200 order workflow: client-side scripts (like your pageInit script) don't run during bulk fulfillment operations. Bulk processing happens entirely server-side, so your client code never gets triggered—hence none of your fields populate.

The Solution: Switch to a Server-Side User Event Script #

You need a User Event Script that runs on the server, which triggers for both manual single-order fulfillment and bulk operations. Here's how to set it up:

1. Create a new User Event Script in NetSuite, and use the beforeSubmit event (it runs right before the Item Fulfillment is saved, so we can populate fields in time).
2. Use nlapiGetNewRecord() to access the Item Fulfillment record directly, then pull line item data from it.

Full User Event Script Code

function beforeSubmit(type) {
  // Skip if this isn't a create/edit operation (covers bulk and manual saves)
  if (type !== 'create' && type !== 'edit') return;

  var fulfillmentRec = nlapiGetNewRecord();
  var lineCount = fulfillmentRec.getLineItemCount('item');
  
  // Populate line item count first
  fulfillmentRec.setFieldValue('custbody_skucount', lineCount);

  // Populate class and item name using the first line (adjust if you need all lines)
  if (lineCount > 0) {
    var lineClass = fulfillmentRec.getLineItemText('item', 'class', 1);
    var lineItemName = fulfillmentRec.getLineItemText('item', 'item', 1);
    
    fulfillmentRec.setFieldValue('custbody_itemcategory', lineClass);
    fulfillmentRec.setFieldValue('custbody_itemsku', lineItemName);
  }
}

Optional: Handle All Line Items #

If you want to concatenate all item names/classes instead of just the first line, add a loop:

// Example: Join all item names with commas
var allItemNames = [];
for (var i = 1; i <= lineCount; i++) {
  var itemName = fulfillmentRec.getLineItemText('item', 'item', i);
  allItemNames.push(itemName);
}
fulfillmentRec.setFieldValue('custbody_itemsku', allItemNames.join(', '));

Final Setup Steps #

• Deploy this User Event Script to the Item Fulfillment record type, and set the deployment status to "Released".
• Keep your modified client script if you want real-time field population for manual single-order work (it won't interfere with the server-side script).
• Double-check that your custom fields allow editing on the Item Fulfillment form.

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