Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Data Validation Process
This bot determines whether the data is present on the ERP database and validates it
Top Benefits
- Data Validation
- Connected to ERP database and fetch in Excel
Tasks
- Read and validate Excel files to get AP record details
- Database connection establishment to Microsoft SQL server
- Data validation
- Run macro
- Delete Cells, Find, Get Multiple Cells, Get Single Cells
This bot inputs data validation records and fetches the data from the ERP database. It then determines whether the data is present on the ERP database or not, with presence being marked by a green dot, and no presence being marked by a red dot.