Remove Bin Number from {item.inventorydetail} When Printing with Advanced PDF Templates

Product:  NetSuite 2021.2

Scenario

When printing Invoice transactions that contain serialized items with bins using {item.inventorydetail} in the Advanced PDF Layout, it prints the value in the following format: "serial number,bin number". 

This article describes how to print only the "Serial Number", without "Bin Number".

Printing the "Serial Number" without "Bin Number" can be achieved using a custom field and a User Event script:

1. Create a new Transaction Line Field by navigating to Customization > List, Records & Fields > Transaction Line Field; Set the following parameters:

   a. Applies To = Sale Item
   b. Type = Text Area
   c. Store Value = T
   d. ID = _invdetail

2. Save the below code snippet as a *.js file on your computer:

   /**
    * @NApiVersion 2.x
    * @NScriptType UserEventScript
    * @NModuleScope SameAccount
    */
   define(['N/record'],
   function(record) {
   
       function beforeSubmit(scriptContext) {
   		var rec = scriptContext.newRecord;
   		var lines = rec.getLineCount({sublistId:'item'});
   		var tempS = '';
   
   		for(var i=0;i<lines;i++){ // for each line
   
   			var subList = rec.getSublistSubrecord({
   					sublistId:'item',
   					fieldId:'inventorydetail',
   					line:i
   				});
   
   			if(subList.getValue('id')){ //if the line has inventory details
   				var sublistLines = subList.getLineCount({
   						sublistId:'inventoryassignment'
   					});
   				for(var j=0;j<sublistLines;j++){ //for each line of the inventory details
   					tempS+=subList.getSublistText({
   						sublistId:'inventoryassignment',
   						fieldId:'issueinventorynumber',
   						line:j
   					});
   					if(j<sublistLines-1) tempS+='\n';
   				}
   				rec.setSublistValue({
   					sublistId:'item',
   					fieldId:'custcol_invdetail',
   					line:i,value:tempS
   				});
   				tempS='';
   			}
   		}
       }
   
       return {
           beforeSubmit: beforeSubmit
       };
   });

   Copy

3. Create the script record in the NetSuite: Customization > Scripting > Scripts > New > Upload the *.js file > click Create Script Record;
   On the Deployments tab select Applies to: Invoice, and Status: Released

4. Add the Custom Column field to the Advanced PDF Layout