On a monthly basis, the Finance team performs an analysis to identify instances where value of work done for Contracts / PO is exceeding the Contract value including taxes and accordingly reversing the accruals for the same.
Challenges
- Manual collection of 64 departments call out data in excel.
- Additional efforts to compare data in SAP and call-out sheets to prepare the final sheet.
- No validation to ensure data is correct in system and final sheet. It is a manual activity.
- JV Posting is manual activity and having dependency on multiple teams.
- Whole process takes 2-3 days to complete
Our Innovations and Solutions
- Fully integrated with SAP System
- Process Orchestration and deployment happens on SAP IRPA Factory which is cloud based solution
- SAP IRPA provides end to end automation of process
- All department data collection done using email where bot reads all the attachments and store data in SAP using BAPI
- BOT also takes care of all data validation such as Contract, PO, WBS and Vendor Details while storing data in SAP
- BOT also check for any variance in data by comparing data with Service Entry Sheet and add the difference amount in SAP
- BOT creates final excel template to post JV in SAP BADI program
- BOT also post the JV in SAP using GUI based screen automation
Challenges
- 40% productivity gain due to fully automated process
- Completely scalable technology that grows with the business
- Reduced process execution time from 2-3 days to 2-3 hour
