SAP Knowledge Base Article - Public

2756813 - Unable to Upload List Price From Microsoft Excel

Symptom

You are trying to upload list price using Microsoft Excel and system shows an error message.

Error: The remote server returned an error. (500) internal server error
Total number of records Saved: 0

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Product Portfolio work center
  2. Go to the List Prices view
  3. Select New and List Prices from Microsoft Excel
  4. Fill the mandatory details
  5. Select Save Data To
  6. Error occurs

Cause

The error occurs while uploading list price because some of the suppliers specified in the excel are in blocked status (and not active).

Resolution

You have to ensure that the suppliers used in the List Price excel is active and you can do so from the below steps;

  1. Go to the Supplier Base work center
  2. Go to the Suppliers view
  3. Select the relevant Supplier
  4. Select Change Status and Active

Keywords

The remote server returned an error. (500) internal server error; List price upload error; 500) internal server error , KBA , AP-PMD-PPS , Procurement Price Specification , Problem

Product

SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Business ByDesign 1902 ; SAP Business ByDesign 1905