Project overview

Organizations create POs to procure items from suppliers. Usually, there are lots of POs generated depending on the size of the organization. 

For this project, we are assuming that we are working with a high volume of POs. The list of POs gets updates frequently in an Excel spreadsheet – say, hundreds of new purchase requests every hour. The automation reads the POs from the spreadsheet and loads them into an UiPath Orchestrator queue. 

Once transactions are available, the automation reads those transactions and writes them to the PO application. The PO application auto-generates a PO number, which is updated in the spreadsheet for the corresponding PO by the bot. 

The automation continues to pick and process the transactions from the queue until there are no further transactions to process. Here is the project workflow:

That was an overview of what the automation will do. As we mentioned in the introduction, we will be...