How to Use Microsoft Word mail merge to create a Dynamics GP import macro

Hi folks as promised in the previous article, here are the steps to use Microsoft's Word mail merge to create an import macro for Dynamics GP. The below will work for any repetative task in Dynamics GP.

Before starting this you will need an excel spread sheet with the values you wish to update. See below example of content.


Segmentid Number description

Segment1 100 Administrator

Segment2 100 Manager

Segment3 100 Tickets

Segment4 100 revenue



Open the window you wish to update. In this case Tools setup financial segment

Then go to Tools Macro Record

Give the macro a name e.g. Segment.

Save macro (the macro is now recording and all your key strokes will be recorded).

Enter one set of data you wish to update e.g. Segment ID , number and description.

Then select save.

Then go to Tools  macro  stop record

Go to where you saved the macro (.mac file) and right click and open Macro with word. You should have text similar to below example.

# DEXVERSION=10.0.193.0 2 2

ActivateWindow dictionary 'default' form 'GL_Segment_Maintenance' window 'GL_Segment_Maintenance'

MoveTo field 'Segment ID'

TypeTo field 'Segment ID' , '100'

MoveTo field Description

TypeTo field ' Description ' , 'Administration'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

ActivateWindow dictionary 'default' form sheLL window sheLL



Now in the word document goto mailings and start the mail merge wizard.



Select directory as document type and got to next starting document



Select current document as starting document and go to next select recipients.



Use an existing list and the browse option to browse out to your spread sheet with the values you wish to update.



Do not go to the next stage of the wizard.



Highlight the value between the ‘’ on the type to line of the script. In the above example this would be the value 100, make sure you highlight just the value and not the’’ either side.



Now go to the insert merge field option from the tool bar, it should give you the column headers from your spread sheet (in this case we want number).



The field should now look like this '«Number»'

In the script.



Now repeat the process with the other type to fields in the script you wish to update e.g. description



TypeTo field Description , '«description»’



Now go next , next next in the wizard and save to a new document. You should end up with a script similar to below.



# DEXVERSION=10.0.193.0 2 2

ActivateWindow dictionary 'default' form 'GL_Segment_Maintenance' window 'GL_Segment_Maintenance'

MoveTo field 'Segment ID'

TypeTo field 'Segment ID' , '100'

MoveTo field Description

TypeTo field Description , 'Administrator’

MoveTo field 'Save Button'

ClickHit field 'Save Button'

ActivateWindow dictionary 'default' form sheLL window sheLL # DEXVERSION=10.0.193.0 2 2

ActivateWindow dictionary 'default' form 'GL_Segment_Maintenance' window 'GL_Segment_Maintenance'

MoveTo field 'Segment ID'

TypeTo field 'Segment ID' , '100'

MoveTo field Description

TypeTo field Description , 'Manager’

MoveTo field 'Save Button'

ClickHit field 'Save Button'

ActivateWindow dictionary 'default' form sheLL window sheLL # DEXVERSION=10.0.193.0 2 2

ActivateWindow dictionary 'default' form 'GL_Segment_Maintenance' window 'GL_Segment_Maintenance'

MoveTo field 'Segment ID'

TypeTo field 'Segment ID' , '100'

MoveTo field Description

TypeTo field Description , 'Tickets’

MoveTo field 'Save Button'

ClickHit field 'Save Button'

ActivateWindow dictionary 'default' form sheLL window sheLL # DEXVERSION=10.0.193.0 2 2

ActivateWindow dictionary 'default' form 'GL_Segment_Maintenance' window 'GL_Segment_Maintenance'

MoveTo field 'Segment ID'

TypeTo field 'Segment ID' , '100'

MoveTo field Description

TypeTo field Description , 'revenue’

MoveTo field 'Save Button'

ClickHit field 'Save Button'

ActivateWindow dictionary 'default' form sheLL window sheLL



Before this script will work we need to remove the repeated line DEXVERSION=10.0.193.0 2 2

This should only appear once at the start of the script so the script now looks like the below.



# DEXVERSION=10.0.193.0 2 2

ActivateWindow dictionary 'default' form 'GL_Segment_Maintenance' window 'GL_Segment_Maintenance'

MoveTo field 'Segment ID'

TypeTo field 'Segment ID' , '100'

MoveTo field Description

TypeTo field Description , 'Administrator’

MoveTo field 'Save Button'

ClickHit field 'Save Button'

ActivateWindow dictionary 'default' form sheLL window sheLL #

ActivateWindow dictionary 'default' form 'GL_Segment_Maintenance' window 'GL_Segment_Maintenance'

MoveTo field 'Segment ID'

TypeTo field 'Segment ID' , '100'

MoveTo field Description

TypeTo field Description , 'Manager’

MoveTo field 'Save Button'

ClickHit field 'Save Button'

ActivateWindow dictionary 'default' form sheLL window sheLL #

ActivateWindow dictionary 'default' form 'GL_Segment_Maintenance' window 'GL_Segment_Maintenance'

MoveTo field 'Segment ID'

TypeTo field 'Segment ID' , '100'

MoveTo field Description

TypeTo field Description , 'Tickets’

MoveTo field 'Save Button'

ClickHit field 'Save Button'

ActivateWindow dictionary 'default' form sheLL window sheLL #

ActivateWindow dictionary 'default' form 'GL_Segment_Maintenance' window 'GL_Segment_Maintenance'

MoveTo field 'Segment ID'

TypeTo field 'Segment ID' , '100'

MoveTo field Description

TypeTo field Description , 'revenue’

MoveTo field 'Save Button'

ClickHit field 'Save Button'

ActivateWindow dictionary 'default' form sheLL window sheLL



Now save this document as a .mac file



Go into dynamics, Open the window you wish to update. In this case Tools setup financial segment



Then go to Tools Macro Play and select the .mac file you just created.

The macro should now run and update the data for you

Country codes in Dynamics GP Input macro (VAT Reporting Requirement)

Hi folks


We have had a couple of enquiries on the help desk recently about setting up country codes for Dynamics GP as there are now extra reporting restrictions in place for VAT when trading in Europe.

Unfortunately you cannot import the country codes into Dynamics GP using integration manager, however do not despair, it can be done quite simply with a macro. The advantage of doing this is that you can ensure the country codes are the same in each company.

You can simply record yourself entering one country code, save the macro, then use words mail merge function to rewrite the macro multiple times with all the appropriate codes. Save as a new macro and run (I’ll cover this in detail in another blog).

Alternatively you can use the Dynamics GP macro I prepared earlier in best Blue Peter fashion.

Simply copy out the code below and paste into a notepad document. Then save the note pad document with a .mac extension rather than .txt. You can then pick this up as a macro in Dynamics GP.

You will need to have the ‘VAT Country Code Maintenance window’ open and this macro was written on version 10. The path is tools>>setup>>company>>countrycodes.

The Macro can be run from tools>>macro>>play.

Any questions please contact the helpdesk@touchstone.co.uk  or myself andrew.hall@touchstone.co.uk

MACRO:

# DEXVERSION=10.0.324.0 2 2

CheckActiveWin dictionary 'default' form 'VAT_Country_Code_Maintenance' window 'VAT Country Code Maintenance'

TypeTo field 'Country Code' , 'AF'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'AFGHANISTAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AX'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ÅLAND ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AL'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ALBANIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'DZ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ALGERIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AS'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'AMERICAN SAMOA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AD'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ANDORRA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ANGOLA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AI'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ANGUILLA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AQ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ANTARCTICA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ANTIGUA AND BARBUDA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ARGENTINA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ARMENIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AW'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ARUBA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AU'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'AUSTRALIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AT'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'AUSTRIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AZ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'AZERBAIJAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BS'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BAHAMAS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BH'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BAHRAIN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BD'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BANGLADESH'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BB'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BARBADOS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BY'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BELARUS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BELGIUM'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BZ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BELIZE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BJ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BENIN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BERMUDA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BT'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BHUTAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BOLIVIA, PLURINATIONAL STATE OF'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BOSNIA AND HERZEGOVINA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BW'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BOTSWANA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BV'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BOUVET ISLAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BRAZIL'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'IO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BRITISH INDIAN OCEAN TERRITORY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BRUNEI DARUSSALAM'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BULGARIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BF'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BURKINA FASO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BI'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'BURUNDI'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KH'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CAMBODIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CAMEROON'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CANADA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CV'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CAPE VERDE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KY'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CAYMAN ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CF'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CENTRAL AFRICAN REPUBLIC'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TD'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CHAD'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CL'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CHILE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CHINA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CX'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CHRISTMAS ISLAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CC'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'COCOS (KEELING) ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'COLOMBIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'COMOROS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CONGO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CD'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CONGO, THE DEMOCRATIC REPUBLIC OF THE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CK'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'COOK ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'COSTA RICA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CI'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CÔTE D IVOIRE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'HR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CROATIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CU'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CUBA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CY'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CYPRUS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CZ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'CZECH REPUBLIC'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'DK'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'DENMARK'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'DJ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'DJIBOUTI'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'DM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'DOMINICA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'DO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'DOMINICAN REPUBLIC'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'EC'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ECUADOR'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'EG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'EGYPT'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SV'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'EL SALVADOR'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GQ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'EQUATORIAL GUINEA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'ER'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ERITREA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'EE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ESTONIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'ET'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ETHIOPIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'FK'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'FALKLAND ISLANDS (MALVINAS)'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'FO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'FAROE ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'FJ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'FIJI'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'FI'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'FINLAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'FR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'FRANCE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GF'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'FRENCH GUIANA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PF'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'FRENCH POLYNESIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TF'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'FRENCH SOUTHERN TERRITORIES'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GABON'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GAMBIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GEORGIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'DE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GERMANY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GH'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GHANA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GI'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GIBRALTAR'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GREECE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GL'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GREENLAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GD'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GRENADA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GP'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GUADELOUPE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GU'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GUAM'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GT'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GUATEMALA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GUERNSEY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GUINEA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GW'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GUINEA-BISSAU'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GY'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'GUYANA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'HT'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'HAITI'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'HM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'HEARD ISLAND AND MCDONALD ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'HN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'HONDURAS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'HK'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'HONG KONG'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'HU'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'HUNGARY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'IS'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ICELAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'IN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'INDIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'ID'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'INDONESIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'IR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'IRAN, ISLAMIC REPUBLIC OF'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'IQ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'IRAQ'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'IE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'IRELAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'IM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ISLE OF MAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'IL'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ISRAEL'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'IT'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ITALY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'JM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'JAMAICA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'JP'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'JAPAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'JE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'JERSEY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'JO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'JORDAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KZ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'KAZAKHSTAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'KENYA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KI'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'KIRIBATI'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KP'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'KOREA, DEMOCRATIC PEOPLES REPUBLIC OF'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'KOREA, REPUBLIC OF'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KW'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'KUWAIT'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'KYRGYZSTAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'LAO PEOPLES DEMOCRATIC REPUBLIC'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LV'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'LATVIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LB'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'LEBANON'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LS'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'LESOTHO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'LIBERIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LY'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'LIBYAN ARAB JAMAHIRIYA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LI'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'LIECHTENSTEIN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LT'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'LITHUANIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LU'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'LUXEMBOURG'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MACAO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MK'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MADAGASCAR'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MW'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MALAWI'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MY'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MALAYSIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MV'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MALDIVES'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'ML'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MALI'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MT'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MALTA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MH'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MARSHALL ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MQ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MARTINIQUE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MAURITANIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MU'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MAURITIUS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'YT'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MAYOTTE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MX'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MEXICO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'FM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MICRONESIA, FEDERATED STATES OF'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MD'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MOLDOVA, REPUBLIC OF'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MC'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MONACO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MONGOLIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'ME'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MONTENEGRO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MS'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MONTSERRAT'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MOROCCO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MZ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MOZAMBIQUE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'MYANMAR'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NAMIBIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NAURU'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NP'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NEPAL'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NL'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NETHERLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NETHERLANDS ANTILLES'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NC'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NEW CALEDONIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NZ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NEW ZEALAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NI'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NICARAGUA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NIGER'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NIGERIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NU'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NIUE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NF'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NORFOLK ISLAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MP'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NORTHERN MARIANA ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'NO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'NORWAY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'OM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'OMAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PK'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PAKISTAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PW'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PALAU'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PS'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PALESTINIAN TERRITORY, OCCUPIED'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PANAMA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PAPUA NEW GUINEA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PY'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PARAGUAY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PERU'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PH'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PHILIPPINES'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PITCAIRN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PL'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'POLAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PT'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PORTUGAL'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'PUERTO RICO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'QA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'QATAR'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'RE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'RÉUNION'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'RO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ROMANIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'RU'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'RUSSIAN FEDERATION'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'RW'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'RWANDA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'BL'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAINT BARTHÉLEMY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SH'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAINT HELENA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'KN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAINT KITTS AND NEVIS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LC'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAINT LUCIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'MF'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAINT MARTIN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'PM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAINT PIERRE AND MIQUELON'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'VC'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAINT VINCENT AND THE GRENADINES'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'WS'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAMOA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAN MARINO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'ST'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAO TOME AND PRINCIPE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SAUDI ARABIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SENEGAL'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'RS'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SERBIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SC'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SEYCHELLES'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SL'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SIERRA LEONE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SINGAPORE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SK'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SLOVAKIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SI'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SLOVENIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SB'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SOLOMON ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SOMALIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'ZA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SOUTH AFRICA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GS'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'ES'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SPAIN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'LK'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SRI LANKA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SD'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SUDAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SURINAME'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SJ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SVALBARD AND JAN MAYEN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SZ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SWAZILAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SWEDEN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'CH'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SWITZERLAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'SY'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'SYRIAN ARAB REPUBLIC'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TW'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TAIWAN, PROVINCE OF CHINA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TJ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TAJIKISTAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TZ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TANZANIA, UNITED REPUBLIC OF'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TH'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'THAILAND'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TL'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TIMOR-LESTE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TOGO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TK'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TOKELAU'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TO'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TONGA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TT'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TRINIDAD AND TOBAGO'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TUNISIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TR'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TURKEY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TURKMENISTAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TC'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TURKS AND CAICOS ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'TV'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'TUVALU'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'UG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'UGANDA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'UA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'UKRAINE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'AE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'UNITED ARAB EMIRATES'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'GB'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'UNITED KINGDOM'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'US'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'UNITED STATES'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'UM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'UNITED STATES MINOR OUTLYING ISLANDS'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'UY'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'URUGUAY'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'UZ'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'UZBEKISTAN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'VU'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'VANUATU'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'VA'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'VATICAN CITY STATE (HOLY SEE)'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'VE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'VENEZUELA, BOLIVARIAN REPUBLIC OF'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'VN'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'VIET NAM'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'VG'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'VIRGIN ISLANDS, BRITISH'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'VI'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'VIRGIN ISLANDS, U.S.'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'WF'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'WALLIS AND FUTUNA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'EH'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'WESTERN SAHARA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'YE'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'YEMEN'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'ZM'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ZAMBIA'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

TypeTo field 'Country Code' , 'ZW'

MoveTo field 'Country Code Description'

TypeTo field 'Country Code Description' , 'ZIMBABWE'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

Integrating to Dynamics (GP) The Basics

Its only Monday and I have already been asked by two clients about integer values in tables and the best way to integrate to them without using Integration Manager. Add to this the couple of calls I had last week on the same subject I thought it would be worthy of a blog article.


The first question that gets asked is “what is the best way of integrating?”.

Well that depends on what you’re integrating. If you’re integrating static data (addresses, debtors, accounts) then SSIS and other such tools are fine. However if you are integrating transactional data I would suggest it is best to use a tool that will use the business logic of Dynamics (GP) and thus prevent you pumping rubbish into the system. These tools will usually use eConnect to access that business logic, tools like Scribe, Integration Manager and Smartconnect can all use eConnect.

The next question tends to be “what tables do I need to integrate to?”

Well there are several ways of finding this out and a combination of them will provide you with the best results.

• Install the SDK from additional products on your Dynamics (GP) CD. This gives excellent help on integrations and will advise you on tables and the values required for integer fields etc.

• Use the Direct to table import. Open the window in which you would normally enter the information manually, then in that window select Tools > Integrate > Table Import. This will then display a list of tables that this window accesses and therefore would be updated if you entered information.

• Resource descriptions. These can be found under Tools > Resource descriptions > table definitions. Here you can find all the tables within Dynamics (GP) and their structure. It will also show you their physical name (The one used in SQL) and their display name as well as their technical name (Usually the one used in error messages).

Using a combination of these you should be able to get all the info you need. This is a very basic look at integrations and does not cover all the options, it is more of a pointer in the right direction.

And always integrate into a test database first when you’re developing your integration.

How to Create SQL Scripts in Integration Manager without hardcoding the database

Here is a handy bit of code. Have you ever wanted to run a sql script in Integration manager after the task completes but you don't want to hard code the company database so you can use it against multiple companies?

Well here is the code to do this (in version 10), in the script window within Integration manager start off by setting the ADODB connection.

set MyCon = CreateObject("ADODB.Connection")

Then use the connection string to bring back the inter company ID

MyCon.Connectionstring = "database=" + GPConnection.GPConnInterCompanyID

Open your connection

GPConnection.Open(MyCon)


You can then construct your SQL statement, the below is an update statement

updatecommand = "update PM00200 "
updatecommand = updatecommand & " set PHNUMBR1 = 'xxxxx',"
updatecommand = updatecommand & " PHNUMBR2 = 'xxxxx',"
updatecommand = updatecommand & " PHONE3 = 'xxxx',"
updatecommand = updatecommand & " FAXNUMBR = 'xxxx'"

Then close the record set and exercute the command

recset = MyCon.Execute(updatecommand )

This becomes a very powerful tool when you combine it with before scripts which will enable you to fill out blank fields with place holders etc and then remove the place holders after the integration completes.

Integration Manager Dynamics (GP) V10 not pulling through fields

Hi folks , this one has cropped up in several support cases this week.

In version 10 Integration manager data is sometimes not being pulled through. This is usually when the destination field is down several sub levels in destination mapping.

A good example of this is the email field that is held under internet settings when integrating a debtor or creditor record.

We have found that although it is already mapped you just need to go into destination mapping and re add the source field. it will now bring through the data.

This is not immediately obvious when troubleshooting as the source field appears correctly mapped to start with.

If you have any questions please contact helpdesk@touchstone.co.uk

Dynamics (GP) eConnect, web services and ISO Currency codes

When you set up econnect to use with web services you need to have all the ISO codes for your individual currencies in Dynamics (GP) populated.

These are setup on the currency maintenance window in Dynamics (GP).

There are two internationally recognised codes for each currency. An alphabetic and a numeric code. Please be aware you need to use the alphabetic code as the web services will not pass/recognise the numeric ones.

The below ISO website has the list of internationally recognised codes.

http://www.iso.org/iso/support/faqs/faqs_widely_used_standards/widely_used_standards_other/currency_codes/currency_codes_list-1.htm


If you have any questions contact helpdesk@touchstone.co.uk

Integration Manager and Windows 7

For those of you who like to keep up with the latest releases of Microsoft operating systems , you may be contemplating a move to Windows 7.

As Mentioned in earlier posts this is compatible with version 10 of Dynamics (GP) however not all third parties and other modules have been tested at this time. One of the most notable of these is Integration Manager. Currently this has not been tested with version 10 and is unsupported on the windows 7 platform.

If the Situation changes we will let you know.

If in doubt about supported operating systems please log a call with our helpdesk

helpdesk@touchstone.co.uk