ANS-0524 · INVENTORY & ITEM MANAGEMENT

How to Access the ‘islotitem’ Field in NetSuite?

Understanding the 'islotitem' field's availability for item records in NetSuite, including direct access and search methods.

Short answer

The 'islotitem' field is a checkbox on NetSuite item records, indicating if an item is lot-numbered. While it can be accessed directly on a loaded record object, it is also commonly retrieved using search functions like nlapiLookupField to efficiently query item properties without loading the full record.

Scenario

Users often need to determine if a specific item in NetSuite is configured as a lot-numbered item. The challenge arises in correctly identifying and accessing the 'islotitem' field, which indicates this property, within scripts or custom workflows.

Solution

The 'islotitem' field is a standard checkbox field available on NetSuite item records. While it can be accessed directly on a loaded record object, it is also commonly retrieved through search mechanisms.To access the 'islotitem' field:

  1. Direct Access on a Loaded Record

    If an item record object is already loaded, the 'islotitem' field can be accessed directly like any other field.

  2. Using Search Functions

    For scenarios where the item record is not loaded, or for efficient querying, search functions can be utilized. For example, nlapiLookupField performs a search to retrieve the field value.

nlapiLookupField('item', itemId, 'islotitem')

Expert NetSuite Support

Need help with this NetSuite issue?

Inventory & Item Management consulting and configuration support

Talk to a consultant