Supplier Creation

Summary

The University onboards 3000 + new suppliers per year. The process is extramely manpower intensive and requires a team of people to manually check and input data into the ERP system. It is a tedious repetitive process that takes a lot of time and effort. There are also different categories of suppliers that require careful checking and input into the system. The Bot automated the vast bulk of this process and significantly reduced the headcount required to manage this process.

Project Role

  • Testing
  • Daily management
  • Code Refactoring
  • Project Upgrade & Expansion
  • Code migration

Process

  • New supplier request is received via Service Now.
  • Supplier information is received in an excel file via FTP transfer.
  • Supplier information is extracted and saved in SQL tables.
  • There is a check of existing suppliers in the ERP system to prevent duplication.
  • Bot checks data & validates it, any exceptions are sent to the finance team for manual handling.
  • Bot begins data entry of supplier information into the ERP system.
  • Bot then checks re-supplier information for information accuracy and then approves the data in the ERP system.
  • Bot sends the information about successful transactions to the client via Service Now.

Benefits

  • Manpower requirements reduced by 3-5 FTE annually leading to huge cost savings.
  • Lead times reduced from 3 weeks to 1-3 days
  • Error rates greatly reduced due to automated handling of data.
  • Greater security of banking information due to elimination of manual data entry.

Stats