web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Batch job is running i...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Batch job is running in local time but the financial date is posting as a future date

(0) ShareShare
ReportReport
Posted on by Brians8 52

Hello,

I have a batch job to invoice all delivered SO's to run at 11:45 PM local time (Arizona) and this job is ending by 11:47 PM local time, however my financial posting date is being forward dated. Why is the job getting a future date on this posting? Even though the job is running "today" in the local time zone, is there a master setup that is controlling the posting date that I am not aware of? 

For example. The batch job was ran at 11:45 PM Arizona time on 5/18 to invoice all shipped orders, yet the financial posting date is 5/19. 

How can I run the job as close to midnight local time as possible and get the correct posting date? 

Thank you,

Brian.

I have the same question (0)
  • Suggested answer
    Sumit Loya Profile Picture
    Sumit Loya 2,230 on at

    Hi Brian,

    The Posted date and time updated as system date time. So you can check the date and time of system.

    Also, check what is the preferred time zone kept for you. The system may store the date and time as 18-May but due to preferred time zone being different, system may adjust the display of the posted date time according to the time zone set for user.

  • Brians8 Profile Picture
    Brians8 52 on at

    Thank you Sumit, however none of us know where this system date time is accessible from. This was my guess as to what was causing my posting issue. How do we get the batch job to post using the local time/date instead of system time. Each facility should post transactions for the date in which they create them. All feedback is welcome.

    thanks all.

    Brian.

  • Suggested answer
    Sumit Loya Profile Picture
    Sumit Loya 2,230 on at

    Hi Brian,

    The posting date is set by the code in LedgerJournalCheckPost class but I dont suggest you make a change to standard logic because that is the base for all journals posted manually or through batch or any other way and Posting date time is also an important field for financial audits.

    May I request you to paste a screen shot of the posting date and time field from a posted journal here? As Arizona time zone is behind UTC in all probability the date stored will be next day only.

    The way system works is that it stores date in UTC time and while displaying it adjusts the dates as per the settings on the User setup for each user.

  • Brians8 Profile Picture
    Brians8 52 on at

    The user session for our batch job was not set up in local time. I had thought that another admin had checked this previously but had not. Once the user sessions time zone was updated to the appropriate time zone the financial posting date was reflected as wanted. 

    Thanks for the assistance all. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans