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

The user is trying to import supplier invoices using Microsoft excel template. However error appears when selecting Save Data To button.

SAP Business ByDesign

1. Go to Supplier Invoicing work center.
2. Go to Invoice Entry view.
3. Click in New button and choose Import from Microsoft Excel.
4. In the upload Excel template, navigate to SAP Business ByDesign tab.
5. Logon into the system.
6. Fill the required details.
7. Click in Save Data To button

System throws the error message "The remote Server returned an error: (500) Internal Server Error."

The possible causes for the error are:

Cause 1: In the template, it was filled the mandatory or the required fields and this leads to an error messages.

Cause 2: The accepted format was not followed for any of the fields. Usually the error occurs due to the data inconsistency entered in the excel template.

Cause 3: Different kind of suppliers were used in the same Excel file.

Resolution for Causes 1 and 2: While importing the supplier invoices using Microsoft excel template, please fill the mandatory and required fields to make the upload successful.

The mandatory fields are:

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 to enter the below required fields:

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.

Resolution for Cause 3: Separate Excel templates should be created for each kind of Supplier. The kinds of Suppliers are:

• Domestic Supplier
• EU Supplier
• Non-EU Supplier

Also consider the below points:

• Please download the template each time you have to upload the invoices
• 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
• Do not add new sheets to the template.
• 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 , How To