3673962 - Import Sales Orders “Invalid Length” or “Missing/Invalid Data” when using comma (,) as decimal separator in Excel upload in SAP S/4HANA Cloud Public Edition

• The Import Sales Orders app in SAP S/4HANA Cloud inconsistently handles decimal separators.
• Despite user settings using commas (","), the app only reliably accepts points (".") as the decimal separator.
• Importing files with values containing commas fails or results in ignored amounts.
• Intermittent behavior occurs where even point values fail temporarily until the session is refreshed or after approximately one hour.
• Errors appear:

  • “Your file contains missing, invalid, or duplicate data.”

  • “Sales order xxxx contains invalid data.”

  • “Invalid Length.”

• This occurs even though the user’s language or regional settings define the comma (,) as the decimal separator. 

 SAP S/4HANA Cloud Public Edition

1. Access the Import Sales Orders Fiori app.
2. Download the template from the app.
3. In Excel, fill in the Condition Amount with values using a comma (e.g., 123,45).
4. Import the file. -> Error occurs.
5. Change the same value to 123.45 -> Import works successfully.

• The import framework (Excel parsing layer) is hard-coded to interpret the decimal point (.) as the valid decimal separator.

• Excel regional formats using comma (,) are not localized by the import logic.

• In addition, cells formatted as General or Number may cause Excel to auto-convert or misinterpret numeric values, resulting in “Invalid Length” or “Invalid Format.”

1. Always use the decimal point (“.”) in all numeric fields (Condition Amount or Ratio, Price, Quantity, etc.).

2. Format all numeric and date/time fields as “Text” before entering data.

   • A green triangle in the upper-left corner indicates the correct format.

3. If regional Excel settings automatically convert commas:

   • Temporarily switch Excel language/region to English (United States/United Kingdom) before editing.

   • Or use Find and Replace to convert , → . before upload.

4. If the file fails intermittently:

   • Reopen Excel, reapply “Text” formatting, and ensure no auto-formatting formulas remain. 

NOTE

Enhancement Request already submitted encourage votes -> Improvement Request Details - Customer Influence 

• 2977875 - Error "Your file contains missing, invalid, or duplicate data" occurs when using the "Import Sales Orders" app - SAP S/4HANA Cloud Public Edition
• 3536723 - [On-Premise] Error "Your file contains missing, invalid, or duplicate data" occurs when using the "Import Sales Orders" app
•  Import Sales Orders Without Charge Help Portal

import sales orders, decimal separator, inconsistent behavior, SAP S/4HANA Cloud, numeric fields, commas, points, Excel template, import failure, text format, regional settings, condition amount, ratio, price, intermittent issue, Your file contains missing, invalid, or duplicate data, Sales order xxxx contains invalid data, Invalid Length. , KBA , SD-SLS-IMP-SPR-2CL , Sales Document Import from Spreadsheet (Public Cloud) , Problem