Hello Netsuite folks. has anyone come across a discrepancy in how LAST_MODIFIED_DATE is captured in the TRANSACTIONS vs TRANSACTION_LINES table? I have a customer where these two date/time stamps are 12 hours apart. The example below is for for a new transaction that we saved this morning (at 104259 Central Time).

How about check NetSuite system information, so that we can see which field is updated

I'm not an expert on how things are recorded in the tables, but I do know there is a concept of header and line audit trail. So my guess would be that maybe the transaction was saved at 3:42, but then a header-only field was changed as 15:42.

We did all of this this morning on a test transaction. Created it from scratch and added the line detail at the same time. SQL Query a few minutes later showing a 12-hr difference. The transaction was not updated after the initial creation.

Was it a JE that was approved perhaps? If not, then I don't know. You might have better luck on the Suiteanalytics or SuiteScript channel as the people who deal more with technical stuff are more likely to know that kind of thing.

mystery solved. I've never noticed this additional DATE_LAST_MODIFIED_GMT field before but I guess that's the one to use.