How does lineuniquekey work when a quote is turned into a sales order? The lineuniquekey changes when the sales order is saved.

AI generated answer (using internal Slack threads):

Based on the conversations, the

lineuniquekey

is a unique identifier for each line in a transaction in NetSuite. It does not change once it is assigned, even when the sales order is saved. However, the ordering of the lines may change if lines are added, inserted, or removed. The

lineuniquekey

is unique across NetSuite, meaning it will not repeat in different transactions such as Journal Entries (JE) or Invoices. When a quote is turned into a sales order, the

lineuniquekey

for each line in the quote is carried over to the sales order. This allows for a consistent way to track each line item as it moves from the quote to the sales order. However, there are some exceptions. For example, tax lines or shipping lines might behave differently. These lines might be recalculated after every save, creating a new line based on the real line data and deleting the old shipping/tax line. This could potentially change the

lineuniquekey

. In terms of mapping data from NetSuite to an external system, using a combination of the transaction internal ID and Line ID could be a more reliable way to keep things unique and updated, as these values are less likely to change. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******