SAP Knowledge Base Article - Public

2778758 - How to Paste Product's information in a Sales Quote or Sales Orders

Symptom

You are trying to paste a table using the Paste option in the Products facet inside a Sales Quote or a Sales Order.

PasteOption_SalesQO.png

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Open the system Fiori.
  2. Go to the Sales work center.
  3. Go to the Sales Quotes view.
  4. Open a sales quote.
  5. Go to the Products facet.
  6. Click on the Paste icon (highlighted in the first screenshot).
    RESULT: You will see a line that says "Paste supported data, such as Excel..."
  7. Make a table in excel which has the same columns order than the ones displayed in the system.

    CopyExcelTable.png
  8. Copy the excel row where you maintained the products information.
  9. Paste the information in the line "Paste supported data, such as Excel...".
    RESULT: The data is not uploaded correctly. I.e., the price and the quantity do not have the same value.

    PasteExcelTable.png

Cause

You have to pass for each entry field in a column in the XLS.

Even if some fields (i.e. the Quantity) have one label, it has 2 entry fields: one for the quantity and one for the quantity unit. Hence, you need to create to different columns in your excel.

Resolution

You need to maintain a field for each entry.

FieldEachEntry.png

Keywords

sales quote, sales order, product, excel, copy, paste, quantity, price, , KBA , LOD-CRM-PRO , Products , LOD-LE-CQP-CO , Lean Sales Orders , LOD-LE-CQP , Customer Quote Processing , How To

Product

SAP Cloud for Customer add-ins all versions