Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
servicemanagement_time_zones_htm
servicemanagement_time_zones_htm
You can store dates and times in Greenwich Mean Time (GMT) so that dates/times can be accurately converted and displayed in the time zone of the location, technician, and user. In addition, time zones can be adjusted for Daylight Savings Time (DST).

Table of Contents

When and how are times converted - an overview

Times are not converted to GMT as soon as you enable the time zone feature in setup. Immediately after you turn on the time zone view feature, the system will attempt to populate certain specific date/time related fields in GMT in the database for new records added. Existing service call, time stamp, and appointment data must be converted after you populate certain tables with time zone values. Existing data must be converted before you add new service calls or appointments.

Service call, time stamp, and appointment get the time zone from location.

...

  • When converting between time zones, if the time becomes 12:00:00 AM, the system will add one one second to the time, for example, 12:00:01.
  • For activities, the system determines the start and end times based on the technician's time zone. This is necessary since, when converting to GMT, the time may span multiple days.
  • For appointments, when checking to see if an appointment conflicts with existing appointments, the system will use the technician's time zone as a guide.

...

  1. Choose Microsoft Dynamics GP > Tools > Setup > Service Management > Module Setup > Service Options. The Service Options window opens.
  2. Mark the check box: Enable Time Zone Views. Choose OK to the following message: You have selected to use Time Zone views. For Time Zone Views to function properly, several tables must be updated with Time Zone data.

About disabling the Time Zone feature

Although we do not recommend disabling the Time Zone feature after it has been enabled, if you do, consider the following:

  1. Make a backup of your data before disabling.
  2. When you unmark the Enable Time Zone Views check box and save the window, a message appears asking you if you want to revert to the time zone of the user's machine. If you select Yes, the system converts times back from GMT to the time zone of the user who turned it off. If you select No, no data is converted and the system re-enables the time zone feature.

...

You must set up a time zone record for each time zone your business deals with. Use the Time zone reference at the end of this chapter as a guide for abbreviations and times.

Note

For new installs, the time zones have already been entered. You should validate the GMT offsets and define the daylight savings time information, if applicable.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Service Management > Lookup Setup > General > Time Zones.
  2. Enter a Time Zone name, for example, CST for Central Standard Time. See Time zone reference for a list of common time zone abbreviations.The GMT Offset values fill automatically based on the time zone selected.
  3. If Daylight Savings Time (DST) applies to this time zone, mark the check box. The remaining fields on the window are enabled.
  4. Complete the remaining fields, as necessary.
    • DST BiasThe amount of hours and/or minutes to adjust the time for daylight savings time. For example, if the time is moved backward one hour in the summer and moved forward one hour in the fall, enter 1 in the Hours portion of the field.
    • DST Start DateUsed to specify the date DST begins. You can include the instance of the day of the week for that month, the day of the week, and the month. For the instance, choose from 1st, 2nd, 3rd, 4th, or Last.
    • DST Start TimeThe time of day DST goes into effect.
    • Standard Start DateUsed to specify when standard time resumes and when DST ends. You can include the instance of the day of the week for that month, the day of the week, and the month. For the instance, choose from 1st, 2nd, 3rd, 4th, or Last.
    • Standard Start TimeThe time of day standard time goes into effect, and DST time ends.
    • DST BiasThe amount of hours and/or minutes to adjust the time for daylight savings time. For example, if the time is moved backward one hour in the summer and moved forward one hour in the fall, enter 1 in the Hours portion of the field.
    • DST Start DateUsed to specify the date DST begins. You can include the instance of the day of the week for that month, the day of the week, and the month. For the instance, choose from 1st, 2nd, 3rd, 4th, or Last.
    • DST Start TimeThe time of day DST goes into effect.
  5. Choose Save. When you save a service call, the time will fill in GMT time. If there is a time zone associated with the location of that service call, that time zone will fill on the service call.

...

You must set up the time zone in the user profile for each user of the system.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Service Management > System Administration > User Profile. The User Pro file window opens.
  2. Select a user.
  3. Select a time zone tag using the lookup in the Time Zone field.
  4. Choose Save.

Repeat these steps for each user in your system.

...

You can assign a time zone for several records within Service Management. We have provided a special utility to make entering time zones easier. But first, you must manually enter a time zone in at least one record, at the highest point of the record hierarchy you choose. This utility assumes the following general record hierarchy:
Image Removed
If you do not use postal code assignments, you can start at the branch level. Therefore, before you run the utility, you should assign a time zone to the branch(s) so that the utility knows where to get the time zone necessary to populate the time zones for the other records. If you do not use branches, you start at the location level, again, assigning a time zone to the location.

Assigning time zones based on whether global filters are used

The Update Time Zone Data utility can only be used if you are using global filters.

If you are using global filters:

  • Assign time zones manually to your branches in Branch Setup (Microsoft Dynamics GP > Tools > Setup > Service Management > Lookup Setup > Branches.) - OR - If based on postal codes, run the Update Branch Time Zone from Postal Codes part of the utility.
  • Either run the Update Time Zone Data utility to update time zones for locations and technicians - OR - assign the time zones manually for each of those records.

If you are not using global filters:

You MUST assign time zone manually in all the records, including branches, locations and technicians.
Note: You cannot use the Update Time Zone Data utility if you are not using global filters.

Update Time Zone Data utility

Using the Update Time Zone Data utility, you can:

  • Update branch time zone values with postal code time zone values (only if postal codes are used).
  • Update location time zone values with branch time zone values.
  • Update technician time zone values with branch time zone values.
  • Update service data (service calls, appointments, and time stamps) time zone values to GMT.
  • Update appointment views, which will be based on the location/technician combination. 
Note

If you want to update branch times zones based on postal codes time zone, you must first mark the Use Postal Code Assignment check box in the Service Options window.

Choose Microsoft Dynamics GP > Tools > Utilities > Service Management > Update Time Zone Data

Note

You must be logged in as "sa" to run this utility.

...

After running the Update Time Zone Data utility to populate the postal codes, branch, location, and technician records, the time zones for additional Service records populate accordingly. For some windows, time zones must be assigned manually from a lookup.

...

Window name:

...

How the Time Zone field populates:

...

Service Class Setup

...

Select a time zone from lookup; this field does not fill automatically.

...

Customer Maintenance

...

Fills automatically based on the time zone of the service class. If no time zone is specified for the service class, the time zone fills based on the branch associated with the customer's location.

...

User Profile

...

Select a time zone from lookup; this field does not fill automatically.

...

Branch Setup

Does not fill automatically unless you run the Update Branch Time Zone from Postal Codes part of the Update Time Zone Data utility; otherwise, you must select a time zone.

Note

You can only select a branch if global filter record editing is enabled in the User Profile window for the current user.

...

Location

...

Fills automatically based on the branch if the Use Global Record Identification option is marked on the Service Options window. If branches are not used or if the conditions above are not met, the time zone fills based on the service class.

...

Technician Setup

...

Fills automatically based the branch associated with this technician. If branches are not used, select a time zone from lookup.

...

Dispatch Board

Fills based on the time zone of the user who is bringing up the dispatch board.

Note

If you change the time zone view to location or technician, for example, the date you entered might change based on the conversion to the location's or technician's time zone.

...

Technician Board

Fills based on the technician selected.

Note

If you change the time zone view to location, for example, the date you entered might change based on the conversion to the location's time zone.

Note

If you change a branch after the time zone feature has been enabled, you must manually change the technician and/or location time zone.

...

Time zone views allow you to view the dates/times in the time zone of location, technician, user, and in GMT (Greenwich Mean Time). This feature has been implemented in several windows. 

Note

Time zone views are just that: views; they do not affect the way dates/times are stored.

Changing the view

The time zone icon appears in the upper right of the appropriate window. To change a view,

...

Click the view that you want. The picture on the icon changes, depending on the view selected.

...

If the time zone view indicator looks like this:

...

The time displays by:

...

Image Removed

...

GMT

...

Image Removed

...

Location

...

Image Removed

...

Technician

...

Image Removed

...

User

The availability of views depends on the window and context. See below for a list of windows and available views.

Service CallGMT, Location (default), Technician, User 

Note

The time zone view icon will not be enabled until a service call is saved.

...

Technician SchedulesGMT, Technician (default), User.

Note

The time zone selected appears in each grid of the technician's schedule.

...

Technician Board - Appointments - Daily ViewGMT, Technician (default), User

Note

The time zone selected appears in the right corner of the Time column heading.

Time StampGMT, Location, Technician, User

Note

When any of the clocks on the window are pressed, the system converts to the time zone selected using the time zone icon.

...

With the time zone feature, the time zone name (for example, CST) will appear next to applicable dates and times fields, as shown in the sample window below. The date and time will be converted from GMT to the time zone selected.

...

The table below shows a list of supported time zones. Information includes common abbreviations, descriptions, and the time differences relative to Greenwich Mean Time (GMT).

...

Code

...

Name

...

Time difference relative to GMT

...

GMT

...

Greenwich Mean Time: Dublin, Edinburgh, London, Lisbon

...

GMT

...

WET

...

Monrovia, Casablanca

...

GMT

...

CVT

...

Azores, Cape Verde Is.

...

GMT minus 01:00

...

AT

...

Mid-Atlantic

...

GMT minus 02:00

...

ART

...

Buenos Aires, Georgetown

...

GMT minus 03:00

...

BRST

...

Brasilia

...

GMT minus 03:00

...

NST

...

Newfoundland

...

GMT minus 03:30

...

AST

...

Atlantic Time (Canada)

...

GMT minus 04:00

...

IND

...

Indiana (east)

...

GMT minus 05:00

...

EST

...

Eastern Standard Time (US and Canada)

...

GMT minus 05:00

...

COT

...

Bogota, Lima

...

GMT minus 05:00

...

CST

...

Central Standard Time (US and Canada)

...

GMT minus 06:00

...

MEX

...

Mexico City, Tegucigalpa

...

GMT minus 06:00

...

SASK

...

Saskatchewan

...

GMT minus 06:00

...

MST

...

Mountain Standard Time (US and Canada)

...

GMT minus 07:00

...

AZ

...

Arizona Time

...

GMT minus 07:00

...

PST

...

Pacific Standard Time (US and Canada), Tijuana

...

GMT minus 08:00

...

AKST

...

Alaska

...

GMT minus 09:00

...

HST

...

Hawaii Standard Time

...

GMT minus 10:00

...

CAT

...

Central Alaska

...

GMT minus 10:00

...

SST

...

Midway Island, Samoa

...

GMT minus 11:00

...

IDLW

...

International Date Line West

...

GMT minus 12:00

...

NZST

...

Wellington, Auckland

...

GMT plus 12:00

...

IDLE

...

International Date Line East

...

GMT plus 12:00

...

FJT

...

Fiji, Kamchatka, Marshal Is.

...

GMT plus 12:00

...

MAGT

...

Magadan, Solomon Is.New Caledonia

...

GMT plus 11:00

...

AEST

...

Hobart

...

GMT plus 10:00

...

ChST

...

Guam, Port Moresby, Vladivostok

...

GMT plus 10:00

...

LIGT

...

Brisbane, Melbourne, Sydney

...

GMT plus 10:00

...

ADE

...

Adelaide

...

GMT plus 09:30

...

DAR

...

Darwin

...

GMT plus 09:30

...

JST

...

Tokyo, Osaka, Sapporo, Seoul, Yakutsk

...

GMT plus 09:00

...

CCT

...

Beijing, Chongqing, Urumqi

...

GMT plus 08:00

...

AWST

...

Hong Kong, Perth, Singapore, Taipei

...

GMT plus 08:00

...

ICT

...

Bangkok, Jakarta, Hanoi

...

GMT plus 07:00

...

ALMT

...

Almaty, Dhaka

...

GMT plus 06:00

...

PKT

...

Islamabad, Karachi, Ekaterinburg, Tashkent

...

GMT plus 05:00

...

AFT

...

Kabul

...

GMT plus 04:30

...

GST

...

Abu Dhabi, Muscat, Tbilisi

...

GMT plus 04:00

...

IRST

...

Tehran

...

GMT plus 03:30

...

BT

...

Baghdad, Kuwait, Nairobi, Riyadh

...

GMT plus 03:00

...

MSK

...

Moscow, St. Petersburg, Kazan, Volgograd

...

GMT plus 03:00

...

EET

...

Eastern European Time

...

GMT plus 02:00

...

ATH

...

Athens, Helsinki, Istanbul

...

GMT plus 02:00

...

CAIR

...

Cairo

...

GMT plus 02:00

...

CAT

...

Harare, Pretoria

...

GMT plus 02:00

...

ISRL

...

Israel

...

GMT plus 02:00

...

CET

...

Paris, Madrid, Amsterdam

...

GMT plus 01:00

...

MET

...

Berlin, Stockholm, Rome, Bern, Brussels, Vienna

...

Scroll ignore



See also: