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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Values in report differs when run twice,please suggest?

(0) ShareShare
ReportReport
Posted on by

Hi,

We have our AOS server and DB servers on different time zones.

Because of that ,when a record is created there is a gap of 2.5 hrs between AX and DB values.

When we are running a report,first time it was taking the record from AX and when run for second time,its taking records from DB for the same query.

For Ex:

rec1 is created at  7 PM and in db it will be stored as 4.30 PM
rec2 is is created at  10 PM and in db it will be stored as 7.30 PM
when report is run for time range 7 PM to 8 PM

for 1st time it gives 1st rec1
when run second time it gives rec2
after we set to default and run again it will give me 1st rec1

we always want to display rec1 in the report.

Is there any way to do this.

Thanks in Advance,

Neeharika

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Praveen Profile Picture
    1,201 on at

    Are you using the UTC format, so that system knows the timezone you are in and data is saved appropriately in the database.

  • Community Member Profile Picture
    on at

    Hi Praveen.

    Yes,we are using utc format only.

    Are you saying while saving in the db,the record will take the AX server timezone?

    Thanks in Advance,

    Neeharika

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

News and Announcements

Season of Giving Solutions is Here!

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans