Automating SAP Sales Order Return Creation from Multiple Excel Files

Help Studio
1

I have problem when I want to automate SAP Sale Order Return from multiple Excel Files.

Source Data:

  • A folder contains numerous individual Excel files.
  • Each Excel file represents a unique billing document (e.g., invoice).
  • Each Excel file contains multiple line items associated with that billing document.

The image shows a folder containing multiple Microsoft Excel files named with a "Bill" prefix, all modified on 12/03/2025 at 11:45 AM. (Captioned by AI)
The image shows a folder containing multiple Microsoft Excel files named with a "Bill" prefix, all modified on 12/03/2025 at 11:45 AM. (Captioned by AI)700×633 47.7 KB

Bill_In_Excel
Bill_In_Excel669×104 3.33 KB

Process

  • Each Excel files, a corresponding Sales Order Return (SOR) must be manually created in SAP.
  • This involves manually extracting the billing number and line item data from the Excel file.
  • Manual data entry of the extracted data into SAP to create the SOR.

The image shows a SAP screen for creating a sales document with a billing document number entered and various search criteria options. (Captioned by AI)
The image shows a SAP screen for creating a sales document with a billing document number entered and various search criteria options. (Captioned by AI)1058×902 47.7 KB

Pls. help me how to do it with UiPath activities.

2

Use For Each File in a folder activity to loop through the files

Then Use Excel Application activity to open the files one by one

Within Excel activity - Use For Each Excel Row activity to loop through each line items

Update the SAP within the excel row loop

This image is a flowchart of a robotic process automation sequence that iterates through Excel files in a folder, processes each row, and displays a message box for each row. (Captioned by AI)
This image is a flowchart of a robotic process automation sequence that iterates through Excel files in a folder, processes each row, and displays a message box for each row. (Captioned by AI)1440×1205 58.1 KB

3

Dear Sharazkm32,

Thank you for your efforts in attempting to resolve my issue. While your proposed solution did not address the problem, I appreciate your time and support.

4

Could you please share more details like

What improvements to be done in the solution or where you are stuck?