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".
Reproducing the Issue
- Open your Excel Template with the saved data of the price list.
- Log on to the system using the respective credentials.
- Click on the Save Data To button.
The following error occurs: "The remote Server Returned an error: (500) internal Server Error".
A value maintained in the excel template is incorrect or not valid e.g. the value for the amount in the line items is maintained as “#N/A”, which is an invalid value for the field Amount.
You need to ensure that you enter a valid value in all fields in the Exel Template. E.g. an Amount has to be a valid number such as 0,00. For some fields such as Product ID or Product Type you can use the Look Up function in the Excel Template to find the valid values for this field.
Once you corrected the values you will be able to upload the price list accordingly.
KBA , SRD-CC , Cross Components , How To