SAP Knowledge Base Article - Public

3227642 - Service Quotes From Microsoft Excel is not Uploading While Adding Field with Blank Value created from XML Source

Symptom

The following Error(s) occurred while saving data : The remote server returned an error: (500) Internal Server Error. Total Number of Records Saved : 0" while uploading service quote via excel with blank value for the field created from XML Source.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Service Orders -> Service Quotes view.
  2. Select New Service Quote from Microsoft Excel.
  3. Add the values in the excel and add the XML field.
  4. Keep the XML field blank.
  5. Click on Save Data To, you get the errors.

Cause

When we add a field from XML Source, system expects a value to be entered.

Resolution

You need to populate the field with a value, or they can remove the mapping from the XML field and create the quote without a value.

Keywords

upload unsuccessful; Excel extended field; XML source; , KBA , AP-SLO-SO , Sales Order , Problem

Product

SAP Business ByDesign all versions