SAP Knowledge Base Article - Public

3288062 - Extension Field is Missing From Price/Discount List Excel Upload

Symptom

You are trying to upload/update a price/discount list and noticed that an extension field is missing.

Environment

SAP Business ByDesign

Reproducing the Issue

In this example we will use Discount Lists ABC(ABC represents the name of the custom discount list which contain the extension field) that has extension field XYZ(XYZ represents the ID of the extension field).

  1. Go to the Product and Service Portfolio work center.
  2. Select the Discount Lists view.
  3. Select a discount list ABC.
  4. Click Download button.
  5. Open the Microsoft Excel file. 

Here you noticed that the file does not contain the extension field XYZ.

Cause

The reason the extension field is not showing in the Excel file is because it is field of type Long Text and currently price list/discount list Excel upload functionality does not support this data type.

Resolution

This is the current system behavior.

Please use the Migration of Discount Lists to upload the discount lists.

See Also

2938699 - Unable to Upload Price List Via Excel
2994967 - Error When Updating Price/Discount List via Microsoft Excel Add-In
2877953 - Excel Upload of Custom Price List with extension field does not work
2774043 - Upload of Currency Price Lists is Failing

Keywords

Extension Field, Missing, Price List, Discount List, Excel, Upload, Migration, Custom, Data Type, Long Text , KBA , AP-PRC-PC , Calculation , How To

Product

SAP Business ByDesign all versions