If a new EU customer is set up in Sage, and the VAT Number is left blank, a Sales Invoice or Credit Note can still be posted to the account.
If a user subsequently adds the VAT number to the Customer Details, the VIES return reports an error with the VAT Number as it was not entered at the time of the original transaction. The error message points the user to customer code but does not reference a specific transaction.
The VIES return needs to pick up the current corrected VAT numbers of the clients otherwise transactions are being omitted which leads to incorrect Revenue reporting.