They say there are only two certainties in life; death and taxes. Well, one other certainty is that time passes and with the passage of time comes change.
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.