This notice is intended for customers who use SuiteAnalytics Connect. The date_last_modified column will be permanently removed from the transaction_lines table. This change is targeted to occur when your account is upgraded to NetSuite 2021.2.
Note: This removal will apply only to the schema available through the NetSuite.com data source.
What Is Changing?
As of 2021.2, the date_last_modified column will be permanently removed from the transaction_line table. In previous releases, the Connect Browser has included a description that this column may return inaccurate values and that you should use the date_last_modified_gmt column instead. Note that the date_last_modified_gmt column returns results in the Coordinated Universal Time (Greenwich Mean Time). You should consider the time zone when you review your queries.
Note: This change will be effective when your account is upgraded to the 2021.2 release. However, the Connect Browser is not upgraded at the same time. The column will still be visible in the Connect Browser, but it will not return any results. The date_last_modified column will no longer appear in the transaction_lines table when the 2021.2 Connect Browser is released at a later date.
Required Actions
You should check your existing queries and make any adjustments before this column is permanently removed.
For more information about the tables and columns available in the Connect Schema, see Connect Schema (SuiteAnswers ID 92461).
If you have any questions, please contact your NetSuite Account Manager.