ANS-0785 · WEB SERVICES & INTEGRATIONS
How to Track NetSuite Record Modifications with Millisecond Precision
Implement a custom script and field to capture and store precise epoch millisecond timestamps for enhanced record modification tracking.
Short answer
To track NetSuite record modifications with millisecond precision, deploy a custom script that captures the current time as an epoch millisecond value. This value is stored in a dedicated custom field, enabling highly precise searches using "before" or "after" operators, which surpasses the standard second-level precision of native NetSuite date/time fields.
Scenario
NetSuite's native date/time fields typically offer precision down to the second. However, situations may arise where a higher degree of precision, specifically up to the millisecond, is required to accurately track when a record was last modified. This need often arises for integrations or detailed auditing purposes where exact modification times are critical.
Solution
To achieve a higher degree of precision (up to the millisecond) for tracking when a NetSuite record was modified, a custom scripted timestamp solution can be implemented. This solution involves:
Custom Field Creation
A custom field is created on the relevant NetSuite record type. This field is designed to store the modification time as an epoch millisecond value.
Script Deployment
A script is deployed to the particular record in NetSuite. This script is responsible for capturing the current time with millisecond precision and populating the custom field upon record modification. While NetSuite's standard date/time fields typically store precision down to the second, achieving and displaying millisecond precision requires custom scripting and specific formatting in saved searches.
Enhanced Searching
Once the custom field is populated with epoch millisecond values, it can be utilized in NetSuite searches. This allows for filtering records using "before" or "after" operators with a significantly higher degree of precision than native NetSuite date fields.
Expert NetSuite Support
Need help with this NetSuite issue?
Web Services & Integrations consulting and configuration support