GP2010 SP3
A VAT number of 123456SH should be valid according to the www.hmrc.gov.uk/.../country-codes.htm
GP validation on the Debtor Intrastat Setup window is failing this and asking for a correct VAT number to be entered.
I'm guessing the regular expression used for the validation is compiled into the dex code and not held in SQL tables anywhere I can get at?
If not can I use GP visual studio add in to intercept the validation on save to override that error by using my own regular expression check on that field. How would I set about doing that do you think?
Could I look for that dialog message and force the value into the field underneath, but that doesn't get me into a saveable sate, is there a flag somewhere I can set to say the form validated or switch off validation for that field entirely, replacing it with my own?
I have a table of euro regular expressions for the format checking we use on our website already to hand!
Tim.
*This post is locked for comments