Some clients require the two-letter country code in front of their VAT number, i.e. DE xxxxxxxxx. Entering this in client details throws an error for EC sales list. How?

Hi hertranslations What error are you receiving on the EC sales list?

When I run the report and export it to Excel ready to upload to HMRC, if I've added in the country code to the client's details so it shows on the client's invoice, the VAT number is report as invalid, as the digits and country code need to be separate. This is what I get:

Country code          VAT No.

DE                             DE897420583

So then I have to go through and manually remove the extra DE to be able to submit the return.

This is what I need:

Country code          VAT No.

DE                             [removed]

But if I don't add the DE to the VAT number in the client's details, then it doesn't show on the client's invoice.

Hi hertranslations The product is working as designed however we'll pass your comments on to our developers for their consideration.

Oh that's a shame. Is there a way that I could edit the fields in my invoice template perhaps so that instead of just <BillingAddress>, you have the indivdual fields? Is <country code> a field? If so, I could break the address down into separate fields and add in the country code that way...

Hi, hertranslations. there is an option of using a custom field. You can have up to 3 custom fields on an invoice. To turn this feature on go to the cog in the top right>account and settings>sales>sales form content>custom fields>put a tick by the box and name the field and save. You will then have that box on the form, you do have to manually enter the information each time on the invoice it will not auto-populate. On most reports in QuickBooks, you can customise and add in columns such as your custom fields. Any Q's just reply back to this thread:smiling_face_with_smiling_eyes:-Emma