Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
ClarityTeam 7/28/2015 8:30:24 PM

Web Services ISO Code error (usually attributed to duplicate ISO codes, but have none)

An ISO 4217 Currency Code must be three characters long; your value is

The above error is what I'm getting in trying to pull SalesOrders between start and end timestamps. The exception shows up in the exception view as 'There was an error in the XML document at (1, 766).' but after opening it and drilling into the inner exception you see the currency code note.

Searching the error message in Google will yield the following MS article about duplicate ISO codes, which GP itself allows but Web Services doesn't allow.

Now, I went into Tools > Setup > System > Currency and checked each code, writing it out as I went and looked for duplicates, found none.

I checked [DYNAMICS].[dbo].[MC40200], which really just shows the list I saw in the UI, verified no duplicates.

I checked [BRICK].[dbo].[MC40000] and the only entry was my Z-US$ and it had the matching index id, etc from MC40200. All looks good there.

I'm stuck now as I don't have any other reported reason why I should be getting this error.

Version: GP 2013
Section: Web Services

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables