ANS-0579 · WEB SERVICES & INTEGRATIONS
How to Ensure Correct tranDate in NetSuite Web Service Requests?
When integrating with NetSuite via web services, accurately setting the transaction date requires careful consideration of time zone offsets to prevent data discrepancies.
Short answer
To ensure accurate transaction dates in NetSuite web service requests, always include the time zone offset in the 'tranDate' field value. This offset should align with your company's time zone preference. If the time zone offset is omitted, NetSuite defaults to the Pacific time zone, which can lead to incorrect date assignments.
Scenario
When submitting data to NetSuite through web service requests, users often need to specify a transaction date using the 'tranDate' field. A common challenge arises when the specified date does not accurately reflect the intended time, potentially leading to discrepancies in transaction records if time zone considerations are overlooked.
Solution
To ensure the 'tranDate' field is correctly interpreted in a NetSuite web service request, it is recommended that the time zone offset is included in the value of the 'tranDate' field. This time zone offset should be based on the time zone preference configured for your company. If the time zone offset is not provided within the 'tranDate' value, NetSuite will default to using the Pacific time zone for processing the request.
Expert NetSuite Support
Need help with this NetSuite issue?
Web Services & Integrations consulting and configuration support