How do I check/view order execution time or key in time on a particular date in NAVISION 2015
Once I suggested MS to put a "Created Time"-field into table 45:G/L Register. The suggestion disappeared (I guess) as the site was closed.
Now a new site has been created, at I made a new suggestion on that issue: https://experience.dynamics.com/ideas/idea/?ideaid=164ec58f-78e2-e811-b96f-0003ff68d6f3
You may vote for it...
A better option would be to have a date time field. It's aleady a datetime in the database. Then you don't have to care so much about time zones.
Sorry for SPAM, but what can I do if I need to care so much about time zones.
E.g. we have 2 orders - 1 for US and 1 for EU.. We have 1 field DateTime and order from both may come with same, but different time.
Erik, how do you advice to handle case like this?
Well as long as the time zone settings for the clients and server is correct, then the SQL Server will store data-time fields internally in the UTC zone.
So when you enter an order in the US at 9am EST, then the same datatime field will be seen as 15:00 CET. Internally as 14:00 UTC.
We have a simular request from a customer, that works in more than one time-zone. And the solutuion for this customer was a TIME-field to allways store and show the local time for an incident. Something concerning deadlines.
Which one is the more usable is this case, I don't know.But - as Erik mentions - a DATETIME is always stored as UTC, regaredless of time-zones and DST's.