Skip to main content
Solved

Time Zone setting for SOOrder OrderDate field

  • November 30, 2022
  • 4 replies
  • 367 views
  • Translate All
xkylewrightx
Semi-Pro I
Forum|alt.badge.img+1

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

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

    4 replies

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

    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

    Translate
    Acumatica Functional Consultant & Customer Experience Supervisor
      xkylewrightx
      Semi-Pro I
      Forum|alt.badge.img+1

      @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

       

      Translate
      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!

      Translate
      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+11
      • 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

      Translate
      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*.
        Terms & ConditionsAccessibility 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