SAP Knowledge Base Article - Public

2190717 - 500 Internal Server Error Appears While Uploading Supplier Invoice From Microsoft Excel


You are trying to import the supplier invoices using Microsoft excel template, however error appears when you select Save Data To button.

Error: The remote Server returned an error: (500) Internal Server Error.


SAP Business ByDesign

Reproducing the Issue

  1. Go to the Supplier Invoicing work center
  2. Go to the Invoice Entry view
  3. Select the New button and choose the Import from Microsoft Excel
  4. In the upload excel template, navigate to SAP Business ByDesign tab and logon into the system
  5. Fill the required details and select the Save Data To button
  6. System throws an error message


In the template, you have not filled the mandatory or the required fields and this leads to an error messages or you would have not followed the accepted format for any of the fields. Usually the error occurs due to the data inconsistency entered in the excel template.


While importing the supplier invoices using Microsoft excel template, please fill the mandatory and required fields to make the upload successful.

Mandatory Fields:

  1. Buying Company: Enter the Company ID
  2. Type Code: Choose Invoice or Credit Memo
  3. Supplier ID: Enter Supplier ID
  4. Document Date: Enter Date format in DD/MM/YYYY
  5. Currency: Select the currency from the selection
  6. Invoice Entry: Select Gross / Net

Apart from these mandatory fields, make sure you enter the below required fields also;

  1. Receipt Date: Enter Date format in DD/MM/YYYY
  2. Document Date: Enter Date format in DD/MM/YYYY
  3. Posting Date: Enter Date format in DD/MM/YYYY
  4. Bill From and Bill To
  5. Ship-From and Ship-To location
  6. Data Entry: Make sure whether you want to Post or Save the uploaded Invoice
  7. In the Supplier Invoice line item section; Enter Item Type. Invoice Item or Credit Memo Item etc.
  8. Enter the Product ID & Description
  9. Enter Product Type
  10. Enter Product Category field
  11. Tax Code, Tax Country
  12. Enter Quantity, Unit
  13. Based on the Invoice Entry selection (Net/Gross) enter Net Price, Net Value
  14. Enter account assignment details like, G/L Account, Service Order, Customer Contract, Cost center, Individual Material, Project Task ID, Sales Order etc.
  15. Make sure to enter the Ship-From and Ship-To location at item line

 Also consider the below points

1.Please download the template each time you have to upload the invoices

2.To find if every thing is fine with details you entered , for first line/row please enter the data in each cell one after the other manually and in the fields which have a drop down choose using Drop down for  one item .Then if this error appears you will  have to cross check each field you entered to correct them and then you can  accordingly fill up all other lines  by copy pasting the details  in the same format

3.Do not add new sheets to the template.

4.Create Manual document using the same details as that of the excel template and click on check button in the invoice and you shall see errors if any, then you can change accordingly template details.


Error Appears While Uploading Supplier Invoices,  Supplier invoice Excel template,  Supplier invoice excel upload,purchase order upload , KBA , error appears while uploading supplier i , supplier invoice excel template , supplier invoice excel upload , supplier invoice excel error , AP-SIP-SIV , Supplier Invoice , Product Enhancement


SAP Business ByDesign all versions