Does anyone know if it's possible to capture a fie...
# suitescript
j
Does anyone know if it's possible to capture a field or record name change with the old and new value in the odbc?
s
If you are using the NetSuite2.com schema, it's possible to query system notes like this: SELECT record, field, oldValue, newValue, context, date FROM systemNote WHERE recordTypeId = -9 AND field = 'ENTITY.SNAME' AND recordId = 123 Which can give you changes to the value of a particular field.