In Automation Anywhere, we create bots to carry out each task. For this project, we will be creating a Parent bot that will carry out all of the steps. It will invoke a Child bot to create SOs.
As the name indicates, a Parent bot is like the main workflow in UiPath. We will have one main workflow that will then call the other child workflows.
Here is a SO creation sequence diagram with the Parent and Child sequences:
As you can see in the diagram, we start by opening and reading the Excel file in the Parent bot. The data is read and stored in a data table variable. We then loop through each record in the data table and create the SOs by invoking the Child CreateSalesOrder bot. The Child bot returns the generated SO number to the Parent bot.
The Parent bot takes this SO number and updates the corresponding row for the SO in the Excel sheet. Once all the data in the Excel sheet has been processed successfully, the Excel file is moved to the Processed...