Change Log Entry question

(0) Share

Report

Posted on by mbr

5,126

I enabled the Change Log Entry for certain tables. I don't know why but lately it doesn't seem like the date and time field is accurate. For instance, for today's records whereby I am tracking when sales shipment header (110 table no) table so any changes on a certain field is recorded. Today is 3/12. But the date and time field value in Change Log Entry=3/13/18. I checked the system date in the Nav server and it's today's date. I also checked the system date in the RTC client when I made a change manually on a record in Posted Sales Shipment (check box only) and it's also 3/12/18. SO I am puzzled as to why Date and Time doesn't seem correct. It should say 3/12/18 plus the time.

Thoughts?

*This post is locked for comments

All responses (3)

Answers (1)

mbr 5,126 on at

Like (0)

Report

RE: Change Log Entry question

Hello,

When I goto the Nav Server and check the time zone by going to Date and Time - Change Time Zone, I see Time Zone = UC = 07:00 Arizona. I see the same thing in the sql server by going to the Date And Time - Change Time Zone. Am I missing something?
Verified answer

RobertasR 5,002 on at

Like (0)

Report

RE: Change Log Entry question

It seems the time zone on the SQL server doesn't match the time zone on the middle-tier. As 'Date and Time' on the Change Log is of type DateTime, system stores it in the UTC format.

Robertas
Suggested answer

GDP 272 on at

Like (0)

Report

RE: Change Log Entry question

Hello,

I suggest please check time zone of your RTC system & Server.