SAP Knowledge Base Article - Public

2252742 - Uploading of Supplier Invoice Using Excel Template Fails for a Custom Tax Code.

Symptom

Not able to create Supplier Invoice using Excel Template with Custom Tax Code.

The interface throws error message: The value 'Y*'of the field 'Tax Code X' is invalid

Reproducing the Issue

  1. Go To Supplier Invoicing work center
  2. Go To Invoice Entry view
  3. Select New then Import from Microsoft Excel
  4. Logon in the system using the SAP Add-In
  5. Fill the Supplier Invoice Header and the Supplier Invoice Lines
  6. Select Save Data To
  7. Receive the error: The value 'Y*' of the field 'Tax Code X' is invalid

Cause

The Web Service Runtime does not support Partner created content on a SAP field, passed via Web Service or through Excel Add-in Interface.

Resolution

The current version of SAP Business ByDesign does not support to pass PDI created content on a SAP delivered field via Excel Add-in Interface or through a Web Service.

Workaround, Partner can create a new PDI field on Supplier Invoice Item Node as following:

  1. Create new PDI extension field on the Supplier Invoice (i. e. Name: Partner Tax Code)
  2. Extend the Excel Add-in Interface to also contain this extension field
  3. In Excel template itself, in the field Product Tax Code, enter a SAP delivered Tax Code
  4. For the partner field, enter the PDI created Tax Code. 
  5. On the Supplier Invoice, create an After modify ABSL script, which pushes the PDI extension field data to the SAP field i.e. push the value of the field Partner Tax Code to the SAP field Product Tax Code.

You will be able to enter PDI created tax codes on the Excell Add-in Interface.

Keywords

KBA , SRD-CC , Cross Components , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1711