Line Items Sequence Changed in the System for Sales Quote Imported From Excel Template

[SAPSupport]

Hi SAP,
Would you please check this Sales Quote?
This Quote was created via Excel template.
In the excel template, DIGITS-11 was the first product we entered.
The second one is DIGITS.
Please see attached upload template.

The result in Sales Quote is different.
Product DIGITS-11 become the last line in the Sales Quote in SAP.

Thank you and BR

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear customer,

Due to a technical limitation on the Excel integration with ByD, the order of uploaded items cannot be guaranteed when uploading Sales Documents using the Excel Addin.

"The sort sequence applied in the UI is not considered in the exported spreadsheet. The sorted column is not marked in a specific way, however."

As an alternative, you can sort the line items directly in the Sales Quote in the system, once it is created. This can be done either by changing the line number manually or selecting the Up/Down arrows for each line item, and then sorting the list ascending or descending.

For more information, please check the KBA 2833211 - Order of Line Items in Sales Document Does not Match Order In Excel (https://me.sap.com/notes/2833211)

Best Regards,

Marcelo
SAP Product Support