What is the difference between transaction.lastmodifieddate and transactionline.linemodifieddate? Is one always updated with the other?

AI generated answer (using internal Slack threads):

The

transaction.lastmodifieddate

and

transactionline.linemodifieddate

are two different fields in NetSuite that serve different purposes. The

transaction.lastmodifieddate

field represents the last date and time when the entire transaction record was modified. This includes any changes to the header or body fields of the transaction. However, it does not necessarily reflect changes to individual line items on the transaction. For example, if a line item's commitment status changes (e.g., from uncommitted to committed), this may not update the

transaction.lastmodifieddate

. On the other hand, the

transactionline.linemodifieddate

field represents the last date and time when a specific line item on the transaction was modified. This field is updated whenever there are changes to the line item, such as changes in quantity, price, or commitment status. So, to answer your question, no, one is not always updated with the other. The

transaction.lastmodifieddate

is updated when the transaction record as a whole is modified, while the

transactionline.linemodifieddate

is updated when a specific line item on the transaction is modified. If you need to track changes to individual line items, you may want to consider using the "Line System Notes Fields" in your saved searches or scripts. This can provide more granular information about changes to line items. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******