Registration Country and Customer Country show number instead of abbreviation of country in excel list exported from EC Sales List.
SAP Business ByDesign All Versions
Reproducing the Issue
Issue can be reproduced with following steps:
- Go to Tax Management work center and EC Sales List view.
- Select tax return XYZ and open it.
- Select View All and go to tab Tax Return.
- Select EC Sales List ABC and select Export--To Microsoft Excel. However, yo see the country as number instead of country abbreviation. For example, it shows 63 in the field of country, instead of IE (for Ireland), which is incorrect.
For all EU countries, the VAT number is generally prefixed with the country code,example for Netherlands the VAT registration number starts with NL for Belgium with BE and so on.
The fields of Country ID in the excel list are derived from this.
In this case, the VAT number is maintained without prefix of country code, but directly starts with digit. So system shows the digit.
Please maintain the VAT Number in Account with prefix of country code as IE for Ireland and so on.
EC Sales List, Country Code , KBA , SRD-FIN-TAX , Tax Management , How To