Hurry hurry hurry Dynamics GP 2010 UK launch event filling up fast.

Just a quick reminder our Dynamics GP 2010 UK launch event is on the 19th May at the London chamber of commerce. There has been a huge amount of interest in this event so sign up below and find out what Dynamics GP 2010 is all about.


Follow the below link to find out more

www.touchstone.co.uk/gp2010launch

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'

SQL script to find PM transactions with missing apply details in Dynamics GP

Hi Folks


Every now and then you get posting interruptions in Dynamics GP at exactly the wrong time. Normally the Batch recovery routine under tools>routines>Batch Recovery, picks these up. However sometimes this is not the case and you then need to determine what state your data is in within the Dynamics GP product.

The below script is designed to help in these circumstances. It is run against the Dynamics GP company database and is designed to find those payables transactions with missing apply details.

I would recommend running this script if you have found a PM transaction with missing apply details to ascertain the extent of the problem.

If you do have a posting interruption or if you find that you do have missing apply info please contact the helpdesk@touchstone.co.uk and we can investigate further.

If you have any questions about the script etc please feel free to contact me andrew.hall@touchstone.co.uk

Here is the script:

/* Before running this query go to query on the menu bar and select results in text */

/* This query is designed to find open transactions that have missing apply info Open & the info is

in history

The first part of the script selects transactions from

the PM20000 which have apply info in the PM10200 */

select b.VCHRNMBR, b.VENDORID

into #temp1

from PM10200 a, PM20000 b

where b.DOCNUMBR = a.APTODCNM

and a.VENDORID = b.VENDORID

go

/* The second part of the script selects transactions from

the PM20000 which should have apply info but they did not appear in the

results of the first script */

select VCHRNMBR, VENDORID

into #temp2

from PM20000

where DOCAMNT >CURTRXAM

and CURTRXAM>'0.00000'

and VCHRNMBR NOT IN

(select VCHRNMBR

from #temp1)

order by VENDORID

go

/* The third part of the script selects transactions from

the results of the second script which have apply info in the

PM30300 History table */

select a.VCHRNMBR, a.VENDORID

into #temp3

from #temp2 a, PM30300 b

where a.VENDORID = b.VENDORID

and a.VCHRNMBR = b.VCHRNMBR

go

/* The Fourth part of the script selects transactions from

the PM20000 that do not appear in the results of the third part or the first part

( open apply info and History apply info) */

select VCHRNMBR, VENDORID, DOCNUMBR

into #temp4

from PM20000

where DOCAMNT >CURTRXAM

and CURTRXAM>'0.00000'

and VCHRNMBR NOT IN

(select VCHRNMBR

from #temp3)

and VCHRNMBR NOT IN

(select VCHRNMBR

from #temp1)

order by VENDORID

go

/* This part of the script displays the results*/

print 'Transactions from PM20000 missing apply info in PM10200 & PM30300'

select * from #temp4

go

Year End comes before 2010 (year end procedures)

If you read the blogs at the moment they are all full of the wonders of 2010, however here in the UK a lot of us will be experiencing our year ends in April before 2010 is released.

Therefore I thought I would devote a little time towards some practical advice for year end.

Once you have got year end out of the way you may then want to turn your sights to Dynamics GP 2010, and if that’s the case may I suggest that you might like to come along to our Dynamics GP 2010 launch event on May the 19th, follow the below link to sign up:

www.touchstone.co.uk/gp2010launch

Back to Year End

The below is a simple checklist you can follow to complete year end, you may notice we are rather fond of doing backups.

1. Do a back up! (told you)

2. Make sure you have enough free disk space on the server. It will need to be a least the size of the GL20000 table but double that would be preferable (It’s going to move all the closed years transactions from the Open table to the History Table so it will need some room).

3. Make sure you run the year end close for all other modules first before the GL (Once you have done the GL you cannot go back and do the others).

Complete year end for each module in the following order:

Inventory

Receivables Management

Payables Management

Fixed Assets

General Ledger

4. Post your final adjusting entries for GL.

5. Print account list to verify posting type (Reports-Financial-Accounts-All Accounts). Incorrectly marked account types is one of the major causes of year end problems. You can also check the posting types using smartlists and the accounts option under Financial.

http://intouchdynamicsgp.blogspot.com/2009/09/no-1-cause-of-year-end-issues.html

If the account's balance is brought forward at the end of year, it should be set up as a Balance Sheet Posting Type.

If the account's balance will be closed to a retained earnings account at the end of the year, it should be set up as a Profit and Loss Posting Type.

6. Close the last period of the financial year.

7. Run the file maintenance routines on financial series i.e. Check links.

8. Make sure Maintain History for Accounts and Transactions is marked in Setup>>Financial>>General Ledger . (If you want to keep history records.)

9. Do a second backup !

10. Print a final detailed Trial Balance, Reports>>Financial>>Trial Balance (I would send this one to file and keep it somewhere safe).

11. Print final Financial Statements.

12. Setup a new fiscal year (Setup>>Company>>Financial Periods)

13. Make sure the Retained earnings account is populated(Routines>>Financial>>Year end closing).

14. Using the Year-End Closing window, enter the starting journal entry number that will be used as the first journal entry number in the new year or accept the default.

15. Close the year, use the Close Year button in the Year-End Closing window .

If the progress window seems to hang at 50%, don't reboot. As long as your hard drive is processing, let it continue. Also make sure you do not click it twice, if you do it we close the next year as well.

16. Close any periods for the new year you do not want people posting to.

17. Adjust budget figures for the new year (remembering to budget for your upgrade to 2010) and print financial statements.

18. Do a third and final backup!

19. Put your feet up and have a well deserved cup of tea

And that is that

Dynamics GP 2010 UK launch Event

On May the 19th we are having our Dynamics GP 2010 UK launch event.


This will be held at the London Chamber of Commerce.

As well as an introduction to the benefits, new features and functionality, we will be hearing from one of our clients that took part in the early adopters program from Microsoft on their experiences with Dynamics GP 2010.
Microsoft will also be presenting at the event and our consultants that assisted Microsoft in the early adopters program will be on hand to quiz about their findings.
The helpdesk will also be there and we will be happy to talk about the results of our in-house testing with Dynamics GP 2010.

To sign up or for more info follow the below link:



Register today to ensure your place: www.touchstone.co.uk/gp2010launch

How to edit VBA when the client only has customization site licence

Well you learn something new every day and today our tame Dex developer is sat next to me in the office (some say he writes code in his sleep, others say he has dexterity tattooed on his heart, all we know is, he is called Jon) so picking up all sorts of things.


This one however is really simple and very useful. Often we will develop modifications for clients on our systems then import these using customization maintenance onto the client systems. This means that the client does not need to have modifier etc, just the customization site licence to run the mods.

However if the VBA on the mods need editing you need to export it back out onto your system to do this then re import it.

Well here is a simple tip. Export the modification out into a package file. Then open the package file up with notepad.

In the VBA code add in the word STOP. This command will tell the VBA to debug.

Re import the package file then open the screen or run the report. The STOP in the VBA code will then open the VBA window and allow you to edit the VBA.

Next handy tip DONT CLOSE THE VBA WINDOW if you do you will have to go through all this again to open the window so leave it open till you have finished and remember to remove the STOP from the code.

Comparing tables In Dynamics (GP)

While we are on the subject of SQL tables, we often need to find records that are in one table but not another. This usually happens after there has been some kind of interruption during a posting process.

This can be done fairly easily with a nested SQL query.

The first thing you need to do is determine which tables you need to look in (Take a look at our previous article on Integration Basics). It is also worth remembering the process flow through Dynamics( GP) (Work>Open>History).

Work tables will start with a 1 after the two alphabetic characters that represent the module/series.

Open tables start with a 2

And you guessed it, history tables start with a 3.

Keys tables etc. start with a 0.

Once you have determined which tables you need to determine which field value you are going to compare. As a rule of thumb, its best to use primary key constraints. You can determine the primary key by using sp_helpindex TABLENAME (Replace TABLENAME with the table i.e. GL10000).

Also it worth remembering that vouchernumber is a unique reference in payables and document number is a unique reference in receivables.

Journal number is unique in GL but only for that year as it is possible to start again with journal numbers after year end in Dynamics (GP) if you so require.

So we now have our tables and which field we are going to compare.

Now we create a nested SQL query

Select VCHRNMBR from PM20000


where VCHRNMBR not in


( Select VCHRNMBR from PM30200)


go

The above statement will return all the records from the PM20000 where they are not in the PM30200. If you wanted to return records in both just drop the not from the statement.

It gets slightly more complex if you are comparing to the master keys table as the Vouchernumber is the control number in this table so I would select into a temp table first and change the field name during the process to match that of the other table. The temptable can be called anything you like as long as it is unique and starts with a # to designate it as a temp table. Mine is #TCLCONTROLNUMB. The temp table will remain in existence as long as the query window is open. Once you close the query the temp table is removed.

Select VCHRNMBR as CNTRLNUM into #TCLCONTROLNUMB from PM20000


go


Select CNTRLNUM from #TCLCONTROLNUMB


where CNTRLNUM not in


(Select CNTRLNUM from PM00400)


go