Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 11-24-2009 09:37:49

imre
Member
Registered: 08-24-2007
Posts: 13

EU VAT Irish Vat numbers are failing

Hi Folks,

We are trying to set up Europacart with EU Vat rules.
We have managed to get the VAT exemption rules to work ok for the following.
(All these numbers were found via google searches)

BE0464034340 - works on Europacart   - Belgium
DE175019865 - GOOD!  German
GB 743325838 - GOOD! British

Irish numbers seem to fail:

IE 9513874E - fails on Europacart - but is valid on EC checker
IE6398832A  - fails on Europacart - but is valid on EC checker
EIRE VAT Number: IE 9992005B (Fails in Europa cart - but is valid on EC site)

Error seen on cart:
The tax exemption number you entered is invalid. Please enter a different number or process your order without entering a tax exemption number.

We have used this european site to check that the Irish Vat numbers are valid.
Vat checking website: http://ec.europa.eu/taxation_customs/vies/vieshome.do

Anything we can do to get this working?

Thanks

Last edited by imre (11-24-2009 09:53:05)

Offline

 

#2 11-30-2009 06:53:23

imre
Member
Registered: 08-24-2007
Posts: 13

Re: EU VAT Irish Vat numbers are failing

Hi Folks,

Is there anyway we can try to solve this?

Thanks,

Offline

 

#3 01-06-2010 11:17:27

forefront
Member
Registered: 03-29-2004
Posts: 190

Re: EU VAT Irish Vat numbers are failing

We also get the same error.

A checkout using an Ireland address and the valid EU VAT # of

IE8201240K

(or 8201240K)

...says it is invalid.

It isn't:

http://ec.europa.eu/taxation_customs/vies/vieshome.do

Getting this whenever we enter ANY EU VAT #

Bug in software or setting we missed?

Offline

 

#4 01-06-2010 12:28:44

forefront
Member
Registered: 03-29-2004
Posts: 190

Re: EU VAT Irish Vat numbers are failing

Seems that Ireland and Austria fail, too:

Ireland IE9645454r
Austria ATU57925669


These work:

Italy IT03790270270
Estonia EE101260244
Greece EL128612299

Offline

 

#5 01-06-2010 13:58:47

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19721
Website

Re: EU VAT Irish Vat numbers are failing

We use http://ec.europa.eu/taxation_customs/vies/viesquer.do to do the lookup.  The program is stripping out everything after the alpha prefix so the alpha characters on the end of those numbers is being wiped out.  We weren't aware anything but an alpha prefix was valid when coding the integration.  With that said, we'll issue an update with the following change in it.

In /private/apps/ecom/ECOM_Checkout/ECOM_Checkout.php replace:

Code:

// +--
// | Get the number into a good format.
// +--

$taxexemptnum = preg_replace('/[\s]+/','',$taxexemptnum);
$taxexemptnum = preg_replace('/[^A-Z0-9]/','',$taxexemptnum);

if ($this->debug) {$this->debugger("covalidateeutaxnum: Modified EUVAT tax exemption number.  New number '{$taxexemptnum}'.");}

// +--
// | Get the country code and user account out of the number.
// +--

$taxexemptnum_cc = preg_replace('/[0-9]/','',$taxexemptnum);
$taxexemptnum_ua = preg_replace('/[A-Z]/','',$taxexemptnum);

With:

Code:

// +--
// | Get the number into a good format.
// +--

$taxexemptnum = preg_replace('/[\s]+/','',$taxexemptnum);
$taxexemptnum = preg_replace('/[^A-Za-z0-9]/','',$taxexemptnum);

if ($this->debug) {$this->debugger("covalidateeutaxnum: Modified EUVAT tax exemption number.  New number '{$taxexemptnum}'.");}

// +--
// | Get the country code and user account out of the number.
// +--

$taxexemptnum_cc = @substr($taxexemptnum, 0, 2);
$taxexemptnum_ua = @substr($taxexemptnum, 2);

Nick Hendler

Offline

 

#6 01-29-2013 01:54:27

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 869

Re: EU VAT Irish Vat numbers are failing

I have just made this mod to a new CCP8 installation as Irish customer reported a problem. Can it be added as a standard instalI?

Thanks
Simon


Simon

Offline

 

#7 01-29-2013 08:36:35

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19721
Website

Re: EU VAT Irish Vat numbers are failing

We're making this change in version 8 in the next update (actually a bit different of a change, but the same idea).  We've noticed the EU is now using alpha-numeric strings instead of pure numeric strings (excluding the country code).


Nick Hendler

Offline

 

Board footer