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).
- Go to the Product and Service Portfolio work center.
- Select the Discount Lists view.
- Select a discount list ABC.
- Click Download button.
- 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