Increase efficiency over 90% with Dynamics GP 2010

Several Touchstone clients were part of the Dynamics GP 2010 TAPs program. Central YMCA (a Touchstone Client) have completed a case study for Microsoft with their experiences of 2010.


In the case study central YMCA have seen a 90% increase in efficiency using Dynamics GP 2010.

You can down load the case study from:

http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?casestudyid=4000006953

Paul Smith from Central YMCA will be presenting at our Dynamics GP 2010 UK launch event at the London Chamber of Commerce on the 19th of May. There will also be presentations from Errol Schoenfish, Director Product Management, Microsoft Dynamics GP.

If your interested in Dynamics GP 2010 come along (you don’t have to be a Touchstone client). You can sign up below. Its a lot easier to get to than Thames Valley Park in Reading (Microsoft Campus), you could say its a more efficient use of your time and you will be able to see what efficiencies you could gain through dynamics GP 2010

www.touchstone.co.uk/gp2010launch

Dynamics GP 2010 has now been released

Dynamics GP 2010 has now been officially released by Microsoft. To find out more about this latest feature rich version of Dynamics GP come along to our Dynamics GP 2010 launch event on the 19th of May at the London Chamber of commerce.


www.touchstone.co.uk/gp2010launch

Returning Ole Notes File names in Dynamics GP

Hi folks


Here is another tip from our tame Dex developer Jon, which I have written up as an article for us mere mortals. The below article should help you if you need to bring back an image from the OLE notes folder in Dynamics GP.

To start with you need to know how OLE notes get their file names. Well the file name is the hexadecimal version of the note index held in the Dynamics GP notes master table (SY03900).

Therefore to reference the file you are going to need to convert decimals to hexidecimals. The below function will allow you to do this.

udfConvertBase10NumberToAnyBase function:

CREATE FUNCTION udfConvertBase10NumberToAnyBase

( @iNumber INT,

@iNewBase INT,

@bitUppercaseOnly BIT = 0,

@bitNoNumbers BIT = 0) --1 to use only alphas

RETURNS VARCHAR(120)

AS

BEGIN

DECLARE @vUppers VARCHAR(26)

DECLARE @vLowers VARCHAR(26)

DECLARE @vNumbers VARCHAR(10)



SELECT @vUppers = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'

SELECT @vLowers = 'abcdefghijklmnopqrstuvwxyz'

SELECT @vNumbers= '0123456789'



DECLARE @vCharactersInBase VARCHAR(62) --Max possible of 10 digits, 26 upper, 26 lower

SELECT @vCharactersInBase = @vUppers --all options allow this



IF @bitNoNumbers = 0

BEGIN

SELECT @vCharactersInBase = @vNumbers + @vCharactersInBase

END



IF @bitUppercaseOnly = 0

BEGIN

SELECT @vCharactersInBase = @vCharactersInBase + @vLowers

END



--If caller requests a "base" size > number of characters in conversion-characters-set, return error

IF LEN(@vCharactersInBase) < @iNewBase

BEGIN

RETURN 'udfConvertBase10NumberToAnyBase - ERROR: Requested Base-size greater than available characters in @vCharactersInBase'

END



DECLARE @vNewNumber VARCHAR(120)

SELECT @vNewNumber = ''





-- Algorithm for generating equivalant number in the new "base":

-- 1) The orignial (base-10) number is continually divided by the new base until the product

-- of the old number divided by the base is zero (meaning the number is finally smaller than the new base).

-- 2) On each cycle (loop iteration), the remainder is added to the number, which is each digit of the new base.

WHILE @iNumber <> 0

BEGIN

SELECT @vNewNumber = SUBSTRING(@vCharactersInBase, (@iNumber % @iNewBase) + 1, 1) + @vNewNumber

SELECT @iNumber = @iNumber / @iNewBase

END --While



RETURN @vNewNumber



END –Procedure



So now we have a function that can convert the decimal to hexidecimal to obtain the file name.

To be able to use this we then need to include this function in a script

See Below:



Select noteindx, right(‘00000000’ + dbo.udfConvertBase10NumberToAnyBase(noteindx, 16, 0,0), 8) as filename from SY03900

You can now bring back the OLE note file.

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

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