ANS-1240 · ACCOUNTING & FINANCIAL CONFIGURATION
How Does NetSuite Calculate Days Overdue with Timezone Differences?
NetSuite's 'Days Overdue' calculation uses the server's PST timezone, requiring scheduled process adjustments for accuracy.
Short answer
NetSuite's 'Days Overdue' calculation is based on the server's PST timezone. This means that for users in other timezones, such as EST, a script or search running at midnight might incorrectly calculate the current date as yesterday. To prevent discrepancies, schedule processes to run after 3 AM EST.
Scenario
Users may observe discrepancies in the 'Days Overdue' field for transactions, particularly when running scheduled scripts or searches. This issue arises because the calculation relies on the NetSuite server's timezone, which is PST. For example, a script scheduled to run at midnight EST will interpret the current date as the previous day due to the three-hour time difference.
Solution
The 'Days Overdue' field in NetSuite is calculated using the formula:
Days Overdue is current date - Due DateThe 'current date' component of this calculation is determined by the NetSuite server's timezone, which is Pacific Standard Time (PST). Consequently, if a script or search is scheduled to run at midnight in a different timezone, such as Eastern Standard Time (EST), the system will interpret the 'current date' as the previous day due to the three-hour time difference.
To prevent these discrepancies and ensure accurate 'Days Overdue' calculations, it is recommended to schedule any relevant scripts or searches to run after 3 AM EST if the user's primary location is in the EST timezone.
Expert NetSuite Support
Need help with this NetSuite issue?
Accounting & Financial Configuration consulting and configuration support