Interesting issue i've discovered. We use Stitch data to sync Netsuite data to Redshift. I've come across a scenario where I have lines on a Sales Order that get updated to committed when Inventory lands in the warehouse, but the header level

lastModified

timestamp is not updated for the sales order transaction when the line commitment updates. Does this sound correct? Looks like Stitch uses the

lastModified

field to do delta syncs, and these updates then get missed.

Yes, this is external to a Sales Order edit; could be due to a number of other transactions and is based on commit settings

Agreed, you are not actually updating the sales order so the last modified date does not change.

any ideas if a sync tool is relying on last modified?

the line item history may have date in it?

that still won’t tell you about commitments

the line item history does have a value there showing the commitment changed

oh!

but nothing on the line

line system notes - if you can perform a search of the line system notes on commit change, then you can sync that info

I think thats as close are you are going to get

ya... that doesnt help me a ton if i cant rely on the 'quantitycommitted` column on the transaction itself