SAP Knowledge Base Article - Public

2423217 - Unable to Upload a Price List using Excel due to the Error: "The remote Server Returned an error: (500) internal Server Error".

Symptom

You are not able to upload a price list using excel due to the error: "The remote Server Returned an error: (500) internal Server Error".

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Open your Excel Template with the saved data of the price list.
  2. Log on to the system using the respective credentials.
  3. Click on the Save Data To button.

The following error occurs: The remote Server Returned an error: (500) internal Server Error.

Cause

A value maintained in the excel template is incorrect or not valid.

Example:

  • The value for the amount in the line items is maintained as “#N/A” / "-", which is an invalid value for the field Amount.
  • The template does not accept the symbol "$".
  • The decimal separator in the Amount field is "," instead of ".". For Example: "10,00", when it should be "10.00".
  • You maintained the Description for a value of a drop down field instead of the code list value. For example: for the Unit of Measure you maintained the Unit Symbol or Unit Description in the template instead of the Unit defined in the fine tuning activity Quantities and Units of Measure.
  • The value maintained in a field is longer than the maximum permitted length 

Resolution

A valid value must be entered in all fields in the Excel Template, not exceeding the maximum permitted length of the field. For instance: an Amount has to be a valid number such as 0.00.

For some fields such as Product ID or Product Type, the Look Up function in the Excel Template can be used to find the valid values for this field. Additionally, if no symbol, such as "$" is in the template.
For code list values such as the Unit of Measure or Distribution Channel, the error can be avoided by using the Lookup function in your excel template.

Once the values are corrected, the price list can be uploaded with no errors.

See Also

KBA 2614379 - Error Faced During Price List Upload

Keywords

Price List; 500 error; upload; excel; Add-In; internal server error, Server Returned an error , KBA , AP-PMD-SPL , Sales Price List , LOD-CRM-PRC , C4C Pricing , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions