Marty Zigman on "How to Search for NetSuite Inventory Detail Records"

How to Search for NetSuite Inventory Detail Records

By Marty Zigman , on October 24, 2015

This article is for the NetSuite SuiteScript programmers who are need to search on NetSuite’s Inventory Detail Records.

Background

The NetSuite Inventory Detail is effectively a ledger structure that is used to manage Serial and Lot Control Numbers on inventory transactions. Often times, there is a need to extend this record type. For example, we created a custom serialized asset manager application that links up to NetSuite Inventory Detail record structure. Accordingly, we needed to update the Inventory Detail record to produce linkages from NetSuite Work Order Assembly operations to the key in our custom application.

The challenge is that this area of the NetSuite API is not well documented which effectively “blinded” one of our senior consultants. However, he pushed through it (we nearly always do) through trial and error and perseverance. We present you the following.

SuiteScript Search Pattern to Find Inventory Detail Record InternalIDs

var func = "SomeSuiteScriptRoutine;"
var assemblybuildid = 12333 // reference assembly build record

var AB = nlapiLoadRecord("assemblybuild",assemblybuildid);
var INVDTL = AB.viewSubrecord("inventorydetail");

//hunt for related inventory detail records
filters = [];
columns  = [];
filters.push(new nlobjSearchFilter('internalid', null, 'is', INVDTL.getFieldValue("id")));
columns.push(new nlobjSearchColumn('internalid',"inventorynumber"));

results = nlapiSearchRecord('inventorydetail', null, filters, columns) || [];

var inventoryNumberId;
if (results.length > 0) {
	//in our case, we expect only one
	inventoryNumberId = results[0].getValue("internalid","inventorynumber");
	nlapiLogExecution("DEBUG", func, "Assembly Build references Inventory Number " + inventoryNumberId);
} else {
	obj = {};
	obj.error = 'Could not find Inventory Number linked to Assembly Build';
	nlapiLogExecution("ERROR", func, obj.error);
	return obj;
};

//with the inventoryNumberId in hand, we can now load it perform our updates

Come Work with Us

If you love the NetSuite platform yet you feel undervalued by others for your problem solving capacities, perhaps we can work together. Our clients value NetSuite based innovation and leadership. Are you ready to raise your standards, serve others, and grow your career? If so, let’s have a conversation.

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube

27 thoughts on “How to Search for NetSuite Inventory Detail Records”

Ravishanker Dwivedi says:

October 27, 2015 at 10:33 pm

Hi Marty,
This is the great approach to filter out the NetSuite record based on InternalID, but NetSuite formula field has its own limitation of 1000 characters only.

Any suggestion on this.

Thanks

Marty Zigman says:

November 1, 2015 at 10:41 am

Hi Ravishanker,

Wouldn’t we go into an expressions and use ORs to express criteria chunks?

Marty

Marty Zigman says:

November 1, 2015 at 10:42 am

Hi Ravishanker,

Wouldn’t we go into an expressions and use ORs to express criteria chunks?

Marty

Rajitha K S says:

May 3, 2017 at 2:23 am

Hi,

I tried to create a inventory transfer record from salesorder using suitescript.
But when execute the script it displays the error “. ERROR: USER_ERROR – Please configure the inventory detail for this line.”.

How we can configure it programatically?

Could you please help me for this configuartion?

Thanks

Marty Zigman says:

May 3, 2017 at 4:07 am

Rajitha,

When you get USER_ERRORs, this is an indication you need more logic. In this case, it appears you are going to need to program the inventory sublist feature as you may be working with Bins, Lots, Serial Numbers. Are you able to follow it via the HELP?

Marty

Rajitha says:

June 15, 2017 at 10:47 am

Hi ,
My Problem is not solved. I want to set a serialized inventory item programaticaly using client. when i try to add an item into invoice, it shows the same error”please configure inventory detail for this line”.As per my knowledge i think we can’t create inventory detail in client script.how i can save this item without inventory detail.

Could you please help me?

Thanks,
Rajitha K S

Marty Zigman says:

June 18, 2017 at 6:36 am

Hell Rijitha,

We have updated the serial number field using 1.0 client side script. Here, we did it by adding lot numbers. The syntax is similar for serial numbers:

nlapiSetCurrentLineItemValue(type,’serialnumbers’, lotnumber,false,false);

Rajitha K S says:

June 19, 2017 at 3:59 am

Thank you. I will try and let you know the result

Rajitha K S says:

June 21, 2017 at 9:18 pm

Hi,

is it possible to add multiple serial numbers for particular item using nlapiSetCurrentLineItemValue(type,’serialnumbers’, lotnumber,false,false);?

Marty Zigman says:

July 12, 2017 at 4:57 pm

See this code example, as offered by Help and notice how they add more than one serial number.

var record2= nlapiLoadRecord(‘purchaseorder’, id, {recordmode: ‘dynamic’});
record2.selectLineItem(‘item’, 1);
record2.setCurrentLineItemValue(‘item’, ‘quantity’, 2);

var subrecord2= record2.editCurrentLineItemSubrecord(‘item’, ‘inventorydetail’);
subrecord2.selectLineItem(‘inventoryassignment’, 1);
subrecord2.setCurrentLineItemValue(‘inventoryassignment’, ‘issueinventorynumber’, ‘working123’);
subrecord2.selectNewLineItem(‘inventoryassignment’);
subrecord2.setCurrentLineItemValue(‘inventoryassignment’, ‘issueinventorynumber’,
‘2ndlineinventorynumber’);
subrecord2.setCurrentLineItemValue(‘inventoryassignment’, ‘quantity’, ‘1’);
subrecord2.commitLineItem(‘inventoryassignment’);

subrecord2.commit();

record2.commitLineItem(‘item’);

var id = nlapiSubmitRecord(record2);

Chris Fitch says:

September 29, 2017 at 8:26 am

Wondering if there is a way to set a bin location on components in a lot numbered assembly

Marty Zigman says:

October 1, 2017 at 7:02 am

Have you looked at the inventoryassignment sublist on the Inventory Detail record object? You should be able to program against it to drive the bin number into a lot / serialized number record type.

Quentin Pongrass says:

October 6, 2017 at 6:59 am

Marty, sorry if this is not directly related to the topic, but how would you go about checking if the user has entered inventory detail on a TO item receipt via a client onsave script? I’ve tried >>>var invdetail = nlapiGetLineItemValue(‘item’,’inventorydetail’,i);<<< but get a nlobjError. I tried nlapiGetLineItemText but get null.

This is confusing because "inventorydetail" is clearly on the item sublist according to the Record Browser (https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_2/script/record/itemreceipt.html).

Thanks for your time.

Marty Zigman says:

October 8, 2017 at 6:10 am

Lookup topic: Scripting the Inventory Detail Subrecord in the HELP. You can’t edit the inventory detail record in client side script.

Quentin Pongrass says:

October 9, 2017 at 11:15 am

I’m merely trying to verify the user has entered inventory detail on a TO receipt. NetSuite does this by putting a green check mark on the inventory detail icon. Is it possible to check for the green check?

Marty Zigman says:

October 9, 2017 at 3:41 pm

Yes, you have to “break out” of NetSuite’s library and work the browser’s Document Object Model. We sometimes do this for our clients.

Marty

Quentin Pongrass says:

October 10, 2017 at 4:49 am

Marty, I actually went a different route: view page source 🙂

I sifted through the page source code and grabbed what I needed to make my onsave script run as follows:


var linecount = nlapiGetLineItemCount('item');
	for(i=1; i <= linecount; i++){
		nlapiSelectLineItem('item', i)
		var itemtext = nlapiGetLineItemValue('item', 'item', i)
		
		try{
			var invdetail_avail = nlapiGetCurrentLineItemValue('item', 'inventorydetailavail')
			var invdetail = nlapiViewCurrentLineItemSubrecord('item','inventorydetail');
			var invdetail_linecount = invdetail.getLineItemCount('inventoryassignment');
			for(var j = 1; j <= invdetail_linecount; j++){
				invdetail.selectLineItem('inventoryassignment', j)
				var binnumber = invdetail.getCurrentLineItemValue('inventoryassignment', 'binnumber')
				var binqty = invdetail.getCurrentLineItemValue('inventoryassignment', 'quantity')
				console.log(invdetail_avail + ' ' + invdetail + ' ' + binnumber + ' ' + binqty)
			}
		}catch(err){
			console.log(err)
		}
	}

Marty Zigman says:

October 11, 2017 at 1:56 pm

That looks like a good code pattern! Great!

Wanda Colombe says:

January 27, 2020 at 10:34 am

How do I create inventory record to show batch number and lot number?

Marty Zigman says:

February 1, 2020 at 6:15 pm

Hi Wanda,

The Lot Number is via the inventory detail sublist. But what do you mean by batch? Are you using NetSuite Advanced Manufacturing?

Marty

Shanty says:

March 8, 2020 at 6:10 pm

Hi Marty,

I want to fill/insert the inventory details in item fulfillment page using suitescript. Since I can’t create subrecord inventory detail with client script, I want using user event before submit script but the problem is when i click Save button there is alert that display i need to configure inventory details in line-i. Can you give me your suggestion how to handle this?Thank you before.

Marty Zigman says:

March 10, 2020 at 8:08 pm

You should be able to via client script. Are you programming against the inventory detail record?

See this code snippet on how to work with the inventory detail record which is where lots and serial numbers exist:

//Set Inventory Detail data var invDetailSubrecord = REC.getSubrecord({ fieldId: 'inventorydetail' });


setAssemblyInvDetailSubrecordHeader({

	invDetailSubrecord: invDetailSubrecord,

	qty: shipCartonQty,

	expiration: expiration,

	binLocation: binLocation,

	inventoryStatus: inventoryStatus,

	lotNumber: lotNumber

});
function setAssemblyInvDetailSubrecordHeader(invDetail) {

	var invDetailSubrecord = invDetail.invDetailSubrecord;

	var qty = invDetail.qty;

	var expiration = invDetail.expiration;

	var binLocation = invDetail.binLocation

	var inventoryStatus = invDetail.inventoryStatus;

	var lotNumber = invDetail.lotNumber;
	invDetailSubrecord.insertLine({

		sublistId: 'inventoryassignment',

		line: 0

	});
	var subrecordFieldsToSet = {

		'quantity'				: qty,

		'expirationdate'		: expiration,

		'binnumber'				: binLocation,

		'inventorystatus'		: inventoryStatus

	};
	util.each(subrecordFieldsToSet, function(value, fieldId){

		invDetailSubrecord.setSublistValue({

			sublistId: 'inventoryassignment',

			fieldId: fieldId,

			line: 0,

			value: value

		});

		log.debug(funcName + fieldId, invDetailSubrecord.getSublistValue({ sublistId: 'inventoryassignment', fieldId: fieldId, line: 0 }));

	});

invDetailSubrecord.setSublistText({ sublistId: 'inventoryassignment', fieldId: 'receiptinventorynumber', //Serial/Lot Number line: 0, text: lotNumber }); }

Shanty says:

March 11, 2020 at 7:20 am

Hi Marty,

Thanks for your answer. I just want to make sure if your answer can use for sublist subrecord? I need to fill the inventory detail for all items in Item Fulfillment/shipment page.

And i read in your comment before that inventory details can’t edit in client script.

Thank you

Marty Zigman says:

March 15, 2020 at 6:52 pm

Hello Shanty,

I believe you should be able to get control client-side. Make sure that you have the right data. Here is how you get to the inventory detail record:

rec.getCurrentSublistSubrecord({ sublistId: ‘item’, fieldId: ‘inventorydetail’ })

Marty

John Fenton says:

August 11, 2021 at 8:06 am

Marty been following you for years hoping you can help!

I have custom “item number” fields for things like version and firmware since NS doesn’t have version control. I want users to enter that info on the inventory detail when receiving or assembling. Is it possible to script the inventory detail to allow users to enter that info in the native Inventory detail screen? The only thing I have found to work is setting on custom fields on the transaction line and an after-submit script to update the Lot Number after saving the receipt.

Marty Zigman says:

August 14, 2021 at 5:44 am

Hello John,

Yes, you can get some control over the client scripting operation of the inventory detail record. I should probably write an article specifically on the client-side script patterns on inventory detail records. But we haven’t tried to modify the popup screen via script. I suspect we could ‘hack’ at it. Possibly consider this article to help with other code patterns:
https://blog.prolecto.com/2018/12/08/learn-suitescript-2-0-pattern-for-netsuite-item-receipts-with-lot-serial-numbers/

Marty

Christopher says:

December 16, 2021 at 11:44 am

Hi Marty,

Thanks for this SS1 script. I rewrote it in SS2 but I get this error: “Your search contains a reference to join for which you do not have a permission: InventoryNumber”

Any idea what permission I need?

P.S. In attempt to discover the permission I tried a search of type search.Type.INVENTORY_NUMBER and got an error saying I needed Lists > Items but after adding that and retrying the original join-ed search I still get the same error.

P.P.S. Here’s the essence of my SS2 version:
const searchObj = search.create({
type: search.Type.INVENTORY_DETAIL,
filters: [
search.createFilter({
name: ‘internalid’,
operator: search.Operator.IS,
values: inventoryToEquipment.invDetailId
})
],
columns: [
search.createColumn({
name: ‘internalid’,
join: search.Type.INVENTORY_NUMBER
})
]
});

How to Search for NetSuite Inventory Detail Records

Background

SuiteScript Search Pattern to Find Inventory Detail Record InternalIDs

Come Work with Us

Marty Zigman

About Marty Zigman

27 thoughts on “How to Search for NetSuite Inventory Detail Records”

Leave a Reply

NetSuite Accelerator Templates

These applications are available to all active Prolecto Resources clients without license charge.

Seeking Conversation?

Have a discussion with our founder, Marty Zigman.

Prolecto Methods

Unlock NetSuite's power through purposeful conversations, software adaptation, capability utilization, gap closure, alignment, implementation planning, configuration, training/testing, and go-live support.

Talk to Certified NetSuite Experts

Are you looking to gain a deeper understanding of our services? Speak with our team of certified NetSuite experts and uncover how we can address your requirements and surpass your expectations.