I am using Web Services of GP 2010 to get Batch using ID/Key. It thorows exception and when I look at DynamicsWebServicesExceptionsConsole it shows An ISO 4217 Currency Code must be three characters long; your value is
Batch.Read18_MoneyAmount(Boolean isNullable, Boolean checkType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderBatch.Read26_Batch(Boolean isNullable, Boolean checkType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderBatch.Read27_Batch()
Upon googling I saw https://support.microsoft.com/en-us/kb/924546 KB. I see currencies having duplicate ISO currency codes but they are for AUD and Z-AUD currency. What am I supposed to do fix my error?
*This post is locked for comments
Which machine needed the re-start?
Good news that it works. Just a follow on question for you to complete the case notes.
Interestingly, the issue is resolved now. Machine restart did the trick, I guess.
Hi Bill,
select CURNCYID, CURRNIDX, ISOCURRC from DYNAMICS..MC40200
CURNCYID CURRNIDX ISOCURRC
Z-AUD 1000 ZAU
Z-C$ 1001 ZCD
Z-DM 1002 DKK
Z-NZD 1003 ZNZ
Z-SA 1004 ZAR
Z-SGD 1005 ZSG
Z-UK 1006 ZGB
Z-US$ 1007 ZUS
HKD 1008 HKD
AUD 1009 AUD
USD 1010 USD
SGD 1011 SGD
NZD 1012 NZD
select FUNLCURR, FUNCRIDX from MC40000
FUNLCURR FUNCRIDX
AUD 1009
Above query output does not show any duplicate Currency Code.
Thanks,
Sai
If memory servers correctly, you have to have a 'unique three' digit code for each currency, regardless of the fact that one is Z-AUD and the other is AUD.
Which one you use, make the correct ISO, the other, chose 3 digits (not already used)
Let us know if that resolves.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156