Skip to main content
Answer

Time Zone setting for SOOrder OrderDate field

  • November 30, 2022
  • 4 replies
  • 306 views
xkylewrightx
Varsity III
Forum|alt.badge.img

Hello-

We are having an issue with the OrderDate field on SOOrder. When you create a new order, it automatically populates with the ‘current date’ - however there appears to be a timezone discrepancy / bug.

Order created on 11/29/22 at 10:53 PM:

OrderDate field automatically populates with date 11/30/2022:

Both the timezone of the user, and the timezone of the site in ‘Site Preferences > Login Time Zone’ are configured to be Eastern Time:

 

 

Does anybody know how to set the timezone the system uses to fill the OrderDate field?

The wrong date is resulting in discrepancies in our reporting numbers.

 

Thank you!!

Best answer by aaghaei

If the CreatedDate value is correct then you can;

Set the PXDefault value of the OrderDate to CreatedDate or

Add a RowInserting EventHandler to set the OrderDate to to UtcDate

Kyle Wright CSW, Inc. | www.cswgraphics.com

    4 replies

    Manikanta Dhulipudi
    Captain II
    Forum|alt.badge.img+15

    Hi @xkylewrightx 

    In one of my ticket, I see this response from Acumatica.

    May be it will help you.

    https://help-2022r2.acumatica.com/Help?ScreenId=ShowWiki&pageid=9821cff9-4970-4153-a0f8-dbf5758133a7

    Acumatica Functional Consultant & Customer Experience Supervisor
    Chris Hackett
    xkylewrightx
    Varsity III
    Forum|alt.badge.img
    • xkylewrightx
    • Author
    • Varsity III
    • November 30, 2022

    @manikantad18

    Thank you - The API only mimics the UI. 

    You can change the date manually in either case, as you have linked, however the system is still using the wrong time zone to set the default value.

    I don’t think remembering, or coding, to set the date manually on every order after 9 or 10 PM is a good solution

     

    Kyle Wright CSW, Inc. | www.cswgraphics.com
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • January 18, 2023

    Hi @xkylewrightx were you able to find a solution? Thank you!

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    aaghaei
    Captain II
    Forum|alt.badge.img+10
    • aaghaei
    • Captain II
    • Answer
    • January 19, 2023

    If the CreatedDate value is correct then you can;

    Set the PXDefault value of the OrderDate to CreatedDate or

    Add a RowInserting EventHandler to set the OrderDate to to UtcDate

    Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved