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…