Keep up to date with the latest information about Microsfot Dynamics GP through articles from the Perfect Image and azurecurve blog.
Update EU Member Country Code Information
June 19th, 2015 by Ian Grieve
One of the changes is that the European Union has become larger, but the VAT10001 (VAT Country Code MSTR) in Microsoft Dynamics GP which holds the country code information has not been updated.
As the information in this table has a direct impact on clients, I created a script to flag the missing current EU Member states (Croatia, Finland and Hungary):
UPDATE VAT10001 SET ECFLAG = 1 WHERE CCode IN ('HR' --Croatia ,'FI' --Finland ,'HU') --Hungary GO
As always have a good backup of your databases before running the script and check afterwards that everything is good.