Sunday, July 7, 2019

Display User's Date and Time on a Printed Picking Ticket

Scenario:

Client created New Transaction Body Field called "Date Printed"

  • Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New
  • Type = Free Form Text 
  • Store Value = False 
  • Validation & Defaulting Default Value = to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')
  • Click Save

Recommendation:

The reason why 'sysdate' uses a different timezone is because sysdate takes the time of the NetSuite server. It does not take the time that users have set up in Home > Set Preferences > Time Zone field.

Since the NetSuite server is in Pacific Time, it displays the 'sysdate' value in Pacific Time as well. This is actually by design. If user need to change the value to use own Time Zone, user need to create a formula in order to compute for the correct time based on the sysdate value.

to_char(sysdate+19/24,'DD-MON-YYYY HH24:MI:SS')

Note: 19 is the hour difference between Sydney time and Pacific Time, so this needs to be manually changed at times to account for different timezones.

No comments:

Post a Comment