SAP Knowledge Base Article - Public

2994967 - Error When Updating Price/Discount List via Microsoft Excel Add-In

Symptom

You are trying to upload an excel file to update a price/discount list, but faces an error.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Product and Service Portfolio work center.
  2. Select the Discount Lists view.
  3. Select the Discount List.
  4. Download the Microsoft Excel file.
  5. Try to send the data in the Microsoft Excel file.

You face an error.

Cause

The excel upload does not work for custom price list/discount list when it contains a Standard Header table with a Custom Item table.

The system is designed to support the following:

  1. Standard Header + Standard Item table
  2. Custom Header + Standard Item table
  3. Custom Header + Custom Item table

Resolution

This is the expect system behavior.

If you would like to proceed with the custom item table, please create a custom header table and assigned this to the price list/discount list.

See Also

SAP ByDesign Price Determination using Extension Fields.

Keywords

Price List, Discount List, Excel, Upload, Update, Error, Standard, Custom , KBA , AP-PRC-PC , Calculation , How To

Product

SAP Business ByDesign all versions