SAP Knowledge Base Article - Public

3073795 - Error:The value XXXXX of the field tax code(1) is invalid

Symptom

You are trying to upload supplier invoice via excel/webservices  and you encounter following error: "The value XXXXX of the field withholding tax code(1) is invalid."

 or

"The value XXXXX of the field tax code(1) is invalid."

Here XXXXX refers to custom tax code.

Environment

 SAP Business ByDesign

Reproducing the Issue

  1.  Open the supplier invoice excel
  2.  Log in to  ByDesign  add on
  3.  Enter the details with custom tax code
  4.  Select "save to" on the excel
  5.  Error encountered

Cause

For the field WithholdingTaxationCharacteristicsCode, in the standard excel template, max length is restricted to 4 char and hence user is getting error on trying to save.

You can check this in the following way:

1. Change the extension of template to .zip instead of .xlsx

2. Unzip it, you will get folder with same name

3. Open xmlmaps.xml file

4. Search for WithholdingTaxationCharacteristicsCode, you can see max length is 4.

Same is applicable for tax code as well .

also you would get same errors while uploading supplier invoice via webservices.

Resolution

We do not support PDI/custom withholding tax(nomal tax code) with the name being longer than 4 chars in the standard field.

You must change name of custom tax code to a 4 char (or) contact partner to create extension fields and make use of PDI to populate this value in the excel.

See Also

2190717 - Error Appears While Uploading Supplier Invoices via Microsoft Excel

Keywords

error with custom tax code, excel upload error, The value of the field withholding tax code is invalid, WithholdingTaxationCharacteristicsCode , KBA , withholding tax code is invalid , supplier invoice excel error , custom tax code error , *tax code* *supplier invoice* *excel* , AP-SIP-SIV , Supplier Invoice , Problem

Product

SAP Business ByDesign all versions