SAP Knowledge Base Article - Public

3146505 - Error When Creating New Quote via Microsoft Excel

Symptom

You are facing an error message when you are trying to create a New Quote using the Microsoft Excel template.

Environment

SAP Business ByDesign

Reproducing the Issue

In this example, we will use Sales Quote as the document being created.

  1. Go to the New Business work center.
  2. Select the Sales Quotes view.
  3. Click the New button.
  4. Select Sales Quote from Microsoft Excel.
  5. Fill the template with the expected data.
  6. Send the Excel file.
  7. After some minutes, the system returns the 500 error.

Cause

The number of lines within the template exceeds the recommended threshold of 200 line in a sales document for performance reasons.

Resolution

This is the system expected behavior.

See Also

2891575 - Find the Cause for 500 Error during Excel Upload
2938699 - Unable to Upload Price List Via Excel
1923372 - Limitation on number of Items in CRM documents (Sales orders, Service Orders, Contracts, Quotes...)

SAP Business ByDesign Sizing Assessment Tool

Keywords

Sales Quote, Quote,  Microsoft Excel, Exception, 500 Error, Number, Line , KBA , SRD-CRM-QUO , Quotations , How To

Product

SAP Business ByDesign all versions