ANS-0029 · SAVED SEARCHES & FORMULAS
What is the Difference Between Line ID and Line Sequence Number in NetSuite?
Learn how NetSuite distinguishes between the visible line number and its internal record ordering, particularly when line items are modified or removed.
Short answer
In NetSuite, 'Line ID' represents the visible line number, which may become non-sequential if line items are deleted. 'Line Sequence Number' is NetSuite's internal ordering, where 0 denotes the mainline and 1 through N represent sublist items, maintaining a consistent internal record order.
Scenario
Users often encounter two distinct identifiers for transaction lines in NetSuite: 'Line ID' and 'Line Sequence Number'. A common point of confusion arises when line items are added, deleted, or reordered, leading to questions about how these identifiers behave and what each represents within the system.
Solution
The 'Line ID' represents the actual line number, which can be non-sequential if a line item is deleted from a transaction. The 'Line Sequence Number' is NetSuite's internal ordering of the record. It is 0 for the mainline and 1 through N for item or sublist lines. For example, if a transaction initially contains itemA, itemB, itemC, and itemD, both the Line ID and Line Sequence Number would initially be 1, 2, 3, 4 respectively. If itemC is deleted from the purchase order, a search would return:
itemA lineID1 lineSequenceNumber1itemB lineID2 lineSequenceNumber2itemD lineID4 lineSequenceNumber3Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support