EC Sales list error message

[Phillip]

Hi

I am trying to run the EC sales list for February and I am getting an error message about 2 of the entries. It states that the VAT number is blank, when looking at the detailed error message it then says the VAT number is invalid.

Customer ####01 has an invalid VAT registration number.
Customer ####02 has an invalid VAT registration number

I have run the Customer EC Sales Activity report and found the offending 2 invoices, I have checked the account details and the correct T4 code is used and the VAT number and country locations are correct. I have also checked that the delivery address also shows the VAT number.

Both invoices are dated on the same date, however other invoices also use this date and have been picked up on the EC SL. Other invoices dated a few days earlier and also later have been correctly picked.

Does anyone have any ideas on what may be causing the problem?

I can as a work around submit the EC SL manualy on the HMRC website.

Sage 50 Account pro 2012 : 18.1.0.16

Many thanks
Philip

[brucedenney]

The problem is the VAT registration number that has been entered against the customer in the customer record.

[Phillip]

The problem is the VAT registration number that has been entered against the customer in the customer record.

That was my first thought, however, on checking the VAT number is correct and so is the country code. What is strange though is with one of them has other entries on a different date and they were picked up. Something must have changed, but I can't find it.

[brucedenney]

If you edit the vat number, does sage complain?

Some people mistakenly put the country code in the VAT number and the VAT number should not have a country code in it.

[johngwms]

I am having exactly the same problem.

When submitting a EC Sales list, most sales are correctly processed. A few are not.

Where VAT numbers are reported as blank, I have modified the related customer record to include the VAT number. However, when I rerun the EC Sales List process, it still reports that the VAT number field is blank.

What can I do?

[brucedenney]

In V2012 they introduced VAT numbers on Transactions. These are based on the VAT numbers defaulted on the delivery address or the customer account, so it may be you have a faulty vat number somewhere on a delivery address that needs correcting.

There is no way to edit the vat number son the transactions.

What may be of help are the other set of VAT reports. There are some in the Company Vat return but there are also some in the Customer Reports section. These are slightly different and when one doesn't work the other one does.