Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Time zone for local time transactions

Posted on by 95

Hello WW colleagues.

My company is in Japan and HQ is in US.

AX server is shared and each company has its own company code.

I just found time zone of my company is US thus we face some transactions are posted with US time, this is a stupid issue. 

Please kindly advice if changing time zone to Japan can solve this issue.

We have some batch processes and I do hope these will be also affected "properly".

Best regards,

  • RE: Time zone for local time transactions

    Try the parameter "Time zone preference for sales documents" in Account Receivable parameters under Sales defaults tab, if the transaction you're referring is related to Sales order.  I've not used this personally but it appears to relevant to your issue.

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: Time zone for local time transactions

    There isn't (or shoudn't be) any time zone to change. Date/time values are stored in UTC, not in local timezones. They're converted to user's (!!!) timezone when they're displayed in GUI.

  • Hideaki_Horii Profile Picture
    Hideaki_Horii 95 on at
    RE: Time zone for local time transactions

    Hi Martin,

    Thanks for your response.

    There is no code in this topic.

    I just wonder if time zone change can provide Japan time (Not US one) in transactions.

    Best regards,

  • Suggested answer
    Alfasith AX Profile Picture
    Alfasith AX 120 User Group Leader on at
    RE: Time zone for local time transactions

    Hi Hideaki,

    As Martin said, the system will store only UTC values.

    If you want to show your local zone values convert the values in the display by below reference.

    docs.microsoft.com/.../how-to-convert-between-utcdatetime-and-system-datetime

    stoneridgesoftware.com/.../

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: Time zone for local time transactions

    Datetime values are normally stored in UTC and displayed in user's preferred zone. They're not stored on local time zones, therefore saying that "it was posted with US time" and "changing time zone to Japan" doesn't make sense.

    Isn't the field populated by your own code? The fact that you have a problem with the value may suggests that you have a bug in code (and the time isn't stored in UTC by mistake).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans