PowerPoint Presentation

The bot logs into SAP and extracts the relevant report.

SAP NetWeaver SAP GUI for Windows 740h-,dReleue I 74m2SM11 • SAP 1993-2015.

x SAP 740 • D Favortf Name A System Descr@tjon • D ShortQ 'AECS [ussttc.„ • D Connec tlAPS2 SID EC6 PS2 Group/Server usstcsnw1ö80.soUt usstcsnW1670.soi_1t itte..

user system yelp SAP New password Clént user Language 950 auditor hfom•øton.

l? Menu Edf Eavortes Extras System Heb SAP Easy Access "Other menu • D Favortes Menu Ofte Cross-Appkatjon Convonents Accountng Human Resources Z Inforrnatøn Systenz Toob Create role e, Ass»gn users _ Documentaton SNET.

2rogram Edt goto System Heb e Display Changes to Vendors General sekctøns vendor Changed On 01.03.2017 Char.#d By Further selectbns @General Data Vendors @convany code Data Convany Code @Purchamg Organtzatøn Data Purchasig Organzaton Group Output control to to to to to Bot Enters T-Code through Text Input Activity.

10 EC€ 9S0 Client Date Wt Edt goto Settngs System Heb e Display Changes to Vendors 14 2000 USD Vendor Changed By SAAVSHIK SAAUSHIK SAAUSHIK SAAUSHIK OPPURSH VPPURSH LROT•CIERE Field Order Recon. Display Name currency account Changes to Vendors porg 2000 2000 2000 0001 1000 1000 lime RFABLOO/AVDIIOR Old value Old value Date Page 17.01.2018 1 OS.OS.2017 'ÆNDOI OS.OS.2017 OS.OS.2017 OS.OS.2017 04.04.2017 SWCDE 04.04.2017 SEDE 04.04.2017 SEDE 22.03.2017 AB 07.03.2017 300030 07.03.2017 300030 07.03.2017 300030 07.03.2017 300030 Conany code data Purchasing Data Catri Addr.Admn code data General data Purchasing Data Catri Addr.Admn code data General data Purchasing Data Nev value New value 152070 Created Created Created Created Created Created.

E' List Ed t Goto Settngs system Heb [X] W Selectøns x Display Changes to Vendors 10 EC€ 950 Client 14 Display Changes to Vendors COCd Erg 2000 2000 lime RFG.BLOO/AVDIIOR Old value Old value Date Page 17.01.2018 1 Date Vendor OS.OS.2017 'ÆYDOI OS.OS.2017 VENDOI os.os.2017 VENDOI OS.OS.2017 04.04.2017 SWCDE 04.04.2017 21:09:24 SEDE 04.04.2017 SWCDE 22.03.2017 AB 07.03.2017 300030 07.03.2017 300030 07.03.2017 300030 07.03.2017 300030 Changed By SAAÜSHIR SAAUSHIK SAAUSHIK SAAUSHIK VPPURSH OPPURSH VPPVRSH LROTv'IERE held Order Recon. Name currency account value New value 152070 code data Purchasing Data Cntrl Addr.Admn code data General data Purchasing Data Cntrl Addr.Admn code data General data Purchasing Data & Save n file... In which should the be saved ? O un converted Spreadsheet text fornzt O HTML Format C) In the cbboard 1000 Created.

Vendor Master Changes Review - Copy x File Copy Home Share Copy path Paste View Move Copy Delete Rename O New item Open • Easy access • Edit Paste shortcut to • to • New folder Clipboard Organize New Properties History Open Select all Select none Invert selection Select t Vendor Master Changes Review - Copy Search Vendor Master Chang... Favontes Desktop Recent places Downloads This PC DesRop Downloads Music Pictures Videos Network Name Vendor Changes Report.xls Type Microsoft Excel 97-2333 Worksheet.

It extracts relevant changes from Service Now Tool.

x service Create New Assigned to me Unassigned All Critical Incidents Map Create Nev Closed All standard Change Standard Change Catalog Open Proposals All Templates CHGüKØ34 = Short description Verulor Vendor X020 Field Plmt VerO Master Chmge Vendor XOIO FQId Pl—tt Vendor Mager Chmge Vendor Fieu Custuner Master Chmge Vendor Fkld Platt Vendor Master Chmge Vendor Field Verulor Master Chmge Vendor DEO Recon. Vendor Master Chmge Vendor Field FIX (Jaw Ck•gxndency' Java 9•rver Ja Server Apg*-y patches 10.2.0.1 to 10.2.0.3 Install new Cisco WMtS to know what it'd to switch to Linux by Akiandra to N«rnal Ncgrnd N«rnal Re.•eted by date 2011 OSOS 03:28-.2S (envty) (enwty) (envty) 201708-14cn-12:2J CAB date 201 r 0309 201 t GO 2011-02-13 user Update Plant Field to 1020 update Plant Vk•ld to ZO 10 to Update Plant Field to AJI VSR to • &'proved ITIL use.

x service Create Ne. Assigned to me Open • unassigned All Critical Incidents Nap Create Ne. Closed All Standard Change Chmge Rquests by (D (D (D (D Numt*r CHCAXXOIS Short description Vendor X020 Verulor Master Chmge Vendor XOLO Fkld Plait Muer ChM8e Vendor STIXKPIANT F ieu Custuner Hager Chmge Vendor WMNORI Field Plan Verulor Master Chmge Vendor SAJMNtX)R Field VSR Vendor DEO Verulor Master Chmge Vendor 3.ü28 Fkld Custort*r FIX (Jaw tkpendency) Java Ancther Java Applkatk•n Serwr chm. Java Server chan. N«mal Ncrrnal • Rejected • Woved • • Assigned to Admin Fred LLddv Requested by date («tvty) (envty) (empty) 201708Æ4cn12:2T CAB date 201' 0309 2017-0910 201705-10 t0200f20 user input Plant Feld to ZON Update Plant Feld to ZOIO Update to plant Field to Uncheck VSR Update C uglyner to IZI ktdin Eh.&ü Lud4v Using Web Interactor Bot interacts with Service Now Tool and filters for relevant changes.

x service Create Ne. Assigned to me Open • unassigned All Critical Incidents Nap Create Ne. Closed All Standard Change Standard Chan" Catalog My Open Proposals All Templates Schedule to > Short descr•tion qarts with Vendor Master Short Master Cha. 1070 Plat* Chat* XOLO (D Ncxrnal Normal Norrnal Norrnal • Requested Requested Rejected • Approved Assigned to Chan E Vendcg Master ST(XKPtANT Fkld Customer Vendu Master kndor WMENORI Fkld Ptmt Vendor Master Field VSR relevant Vendor "aster Change Wndor Field Vend'" Master Wndor W28 Fieu Customer by date 201 2011-oss03:282S 201 r -wosnwn CAB date 201 r.oycn 201102-13 2011-09-10 201705-10 Field to zon punt Field to Custcner to Rant to WI Uncheck VSR Custcgner to.

x service Eater Create New Assigned to me Unassigned All Critical Incidents Map Create New Closed All standard Change Chutge Rquests to An > Short descr•tion garb With Vendor Master Nurrvt*r = Short Field C Help Approval to Extract Wizard Select Element I. Open your browser, application or document and navigate to where you want to extract data from. 2. Press Next in this dialog and hover the mouse cursor over a data source field. 3. Click that field. Back by 201t03-osozm:1S = date 20M 0309 201702-13 201705-07 201705-10 Plant to zon Ugxl*e Plant Fkld to ZOuO Cuquner to Rant Field to SAJI VSR to Using Data Scrapping Tool the bot scrapes the tabular data and stores it in local machine o.

x NumtN (34M 78) Left (313*418) Tn x (170m (ESC) • Careel Sekct&i (F2) • Oday Open • Unassigned All Critical Incidents Nap Create Ne. Closed All Standard Change Change Rquests to Nun&r Short garts with Vendry Master Q Nutr Short Vendor Vendor Master Vendor Vendor ChanF O Vendor Master Wn&r ST (XKPIANI Field customer Vendor Master Change Vendor SAAVENORI Field nant Vendor Master Cha. Venæ•r SAJVENDOR Field VSR Vendor Master Char. Ven&r Fieu Recon. xcouit Vendor Master Change Vendor Ä28 Field Custorner Type Assigr•d to Ctuoz Requested 201 201 t 201 T date 701702-13 2017-05-10 201705-10 I •to loll User input mant Field to Z020 Field to ZOuO Cu-*aner to Imo Mant F-kld to SAJI upd*e Custuner to Using Data Scrapping Tool the bot scrapes the tabular data and stores it in local machine o.

x service Eater Incident Create Ne. Assigned to me - Unassigned All Critical Incidents Map Create New Closed All standard Change Chmge Rqwsts to Nun&r > Short descr•tion garb With Vendor Master Nurrit*r = Short Vendor Mager Vendor Master Chanc Vendor X020 Fidd Vendor Master ChanF Ven&r XOIO Fidd Vend to by Extract table You selected a table cell would you like to enract the data from the whole table? Fieki = date 20170309 201702-13 201705-07 201705-10 Plant F#ld t.Jgxi*e Plant Fkld to ZOuO Custuner to Rant Field to SAJI VSR UgOe Cu-stuner to to Using Data Scrapping Tool the bot scrapes the tabular data and stores it in local machine o.

x service Eater Create Ne. Assigned to me Unassigned All 2017-0 2017-0 Critical Incidents Map 2017-0 2017-0 2017-0 2017-0 2017-0 u Create Ne. Closed All standard Change Chutge Rqwsts to Nun&r A1 > Short description garb with Vendor Master Nurrit*r = Short Field c to Colum Update Unchec Update I-Jgxiat€ by Preview Data Updat Select I Select I Select I Select I Select I Select I Select Search Previev Previev Previev Previev Previev Previev Col CHGOO CHGOO CHC,OO Colum Venda Vend01 Vend01 Vend01 Vendo Venda Venda Colum Norma Norma Norma Norma Norma Norma Norma Extract Wizard Colum Colum Ap Beth AJ Appro•, Zane S Zane S Rejecte Taylor Appro•, Vince E ues Alepnc Reque Annett Colum Certific Chang' Changt Cha Certific Colum David 1 2017-0 2017-0 Ron Ke 2017-0 2017-0 2017 2017-0 Colum 2017-0 Colum = date 201703-09 20170309 201702-13 201705-10 Plant F#ld to zon t.Jgxi*e Plant Fkld to ZOuO Cuquner to Ugxi*e Rant Field to SAJI VSR Ugue Cu-stuner to to Standard Chan" Catalog Open Proposals All Templates o.

x service F-ater 2017-0 Updat€ Chang€ 2017-0 2017-0 Update Create Ne. Assigned to me Ron Ke 2017-0 2017-0 Unchec - Unassigned All Critical Incidents Map Preview Data Chutge Rqwsts > Short G) Updat• Select Select Select Select 1 Select I Select Select Search Previev Previev Previev Previev Previev Colum CHGOO CHGOC CHGOC CHGOO CHGOC CHGOC CHGOO Colum Vendot Vend01 Venda Vend01 Vend01 Venda Vend01 Colum Norma Norma Norma Norma Norma Norma Norma Colum Colum R ues Annett Reque Alejanc Appro•. Vince E Rejecte Taylor Appro•. Zane S Appro•,. Zane S Appros Beth A1 Colum Colum Colum Certific 2017-0 Changf 2017-0 2017-0 Chang€ 2017-0 2017-0 Davidi 2017-0 2017-0 Certific 2017-0 2017-0 Colum Updat€ Update Update Colum by 20110308 ornrs = date 201703-09 20170309 201702-13 201705-10 Plant FÉ4d Ugxå*e Plant Fkld to ZOuO Cuquner to Ugxi*e Rant Field to SAJI VSR Ugue Cu-stuner to to Create Ne. Closed All standard Change Standard Chan" Catalog Open Proposals All Templates o Edit Data Definition Help Maximum of results (O for all) Buk.

x service Fat. n.vipü:.r Create Ne. Assigned to me Open • Unassigned All Critical Incidents Nap Create N e. Closed All Standard Change Standard Chan" Catalog My proposals Open Proposals All Templates Schedule o Chmge Rqwsts to Nun&r Short description garts with Vendry Master Short Vendor Master Vendor X020 Field Type Indicate Next Link E Assigned to Ct»oz Vendor S 1 (XKPIAN Vendor SAAVENORI Vendor Mast SAJIVENIX) Vendor Vendor Mast Field Custorner Is data spanning multiple pages? Identify the element that navigates to the next It could be a 'Neff button or an arrow (not a page number). Press Yes to indicate it. Requested 201 tos-osov.n•.zs 201 T date 20170309 701702-13 201705-10 2017-05-10 I j to roll user input Hant Field to zon to ZOuO Cu-*uner to Uxi*e Hant F-kld to SAJI Upd*e Custuner to.

Vendor Master Changes Review - Copy x File Copy Home Share Cut Copy path Paste View Move Copy Delete Rename ONeWitem• Open • Easy access • Edit Paste shortcut to • Clipboard New folder to • Organize New t Vendor Master Changes Review - Copy Properties History Open Type Microsoft Excel Worksheet Microsoft Excel 97-2Ø3 Worksheet Select all Select none Invert selection Select 16 KB Search Vendor Master Chang.„ Favontes Desktop Recent places Downloads This PC DesRop Downloads Music Pictures Videos OSDisk Network Name SNOW Download.xlsx Vendor Changes Report.xls.

The bot reviews the relevant vendor master compliance rules.

x 1 2 12 14 15 16 18 21 TO ECO 9 NY Client Date 21.12.201-, 21.12.201•. 21.11.201-, 16.11.201-, 16.11.201•, 16.11.20r. 16.11.201-, Display Changes to Vendors Time 11:03:35 Date 17.01.2018 RFKABLWAUDITOR Page Time Vendor Changed E Field NamCoCd porg 01:14:05 A1 AAAA KUNALXUI PaytTerm KUNALKUI Payt Term 21 SRUSRIN1\Automatic PO 10m 5555 New Old value New valu€ Old value ZOOI 21:43:46 TESTSERV SRUSRINBAcknowl. Reqd TESTSERV SRUSRIN1\Aut. GRSet Ret TESTSERV SRUSRlNBAutomatic PO TESTSERV SRUSRINI\ERS.

x c 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 B TO ECO 950 Client 01.03.201€ 01.03.201€ 01.03.201€ 01.03.201t 01.03.201t 01.03.201€ 01.03.201t 01.03.201t 01.03.201t 01.03.201€ 01.10.201! 01.10.201-• 01.10.201± 01.10.201± 01.10.201-• 01.10.201-• 01.10.201-' 01.10.201-' D E Dis la Chan es to Vendors G H ZM02 RCPI RCPI RCPI RCPI RCPI o s Time Created Created created ••• Created ••• created created Created Created Created Created 26 x x x x x Created Created Date 17.01.2018 07:01:29 RATRAPR Cntrl Addr.Admn General data GRAINGEF RATRAPR partner Role GRAINGEFRATRAPR Partner Role GRAINGEFRATRAPR Purchasing Data m-.45:13 ZVENDOR JOSEPHASCntr1 Addr.Admn ZVENDOR JOSEPHASCompany ZM02 W.45:13 ZVENDOR JOSEPHAS General data ZVENDON JOSEPHAS Purchasing Data ZVENDOR JOSEPHASCompany ZM02 02:13:35 AB 01:18:03 AB RAYAPRC' customer RAYAPRC} GR-Based RAYAPRC} ERS RAYAPRC* GR-Based IV RAYAPRC} Aut. GRSet Ret RAYAPRC* ERS RAYAPRC\ Cntrl Addr.Admn RAYAPROCompanv RCCI The bot triggers the execute macro activity to join the reports and apply defined compliance rules.

x c o s 1 29 31 32 39 40 41 43 TO EC69 Client Display Changes to Vendors Time 11:03:35 2 87 STOCK sup Date 17.01.2018 26 03.03.201f 27 05.11.201-. 28 27.07.201± 31.10.201-, 30 14.12.201t 30.10.201-, 29.03.201t 33 01.10.201± 34 29.02.201t 35 03.03.201f 36 05.11.201-, 37 05.11.201-, 38 05.11.201-. 12.02.201f 14.10.201E 02.11.201•, 42 05.11.201-, 13.05.201f 21:27:45 DELPLANT JOSEPHAS Payt Term ZMOI Germs A123 SRUSRINIY p 23:50:58 RD-VEND( DASHRA paytTerms 21 SRUSRlNl\Payt Terms 10:21:53 3Ä8 RATRAPR payt Terms RPOI 1 07:57:22 21 SRUSRIN1\PaytTerm 3m SHARMAA stock Type AA RAYAPRC' Customer ZVENDOR JOSEPHAS Customer DPIANTIC JOSEPHAS customer 10m 10•.57$9 A124 11:10:34 A124 11:13:52 A124 SRUSRINB customer SRUSRINI\ customer SRUSRINI', customer 22:20:09 STOCKPLAASSA Customer PLANTVE GURUJAKF Plant 21 SRUSRIN1\P1ant A124 SRUSRIN1\P1ant 07:36:51 KANE-BE Customer 1 1 1 1 2 2 3 26 47 57 86 87 88 1112 loam The bot triggers the execute macro activity to join the reports and apply defined compliance rules.

Vendor Changes Report.xls - Excel x HOME FILE Cut Paste Delete Format INSERT •S Format Painter Clipboard PAGE LAYOUT FORMULAS DATA REVIEW VIEW Wrap Text DEVELOPER ANALYTICS Number Fill Merge & Center Alignment F G Conditional Formatting • Format as Cell Table • Styles • Styles Insert cens & Find & Fitter • 9-lect • Editing o c Date Time Vendor Changed E Field NamCoCd 2 03.03.201€ 05.11.201-. 3 27.07.201-• 4 31.10.20r, 5 6 14.12.201€ 7 30.10.201-, 8 29.03.201€ 9 01.10.201-• 10 29.02.201f 03.03.201f 11 12 05.11.201-, 13 05.11.201•. 14 05.11.201-, 15 12.02.201€ 14.10.201! 16 17 02.11.201-, 18 05.11.201-. 19 13.05.201f 21:27:45 DELPLANT JOSEPHAS payt Term ZMOI 09:37:51 A123 SRUSRINI\ pOTerms 23:50:58 RD-VEND( DASHRA PaytTerms 21:37:36 21 SRUSRINI\ Payt Terms porg RPOI 1 10:21:53 3008 RATRAPR PaytTerms New vali.n Old value ChangeNumber 1 1 1 1 2 07:57:22 21 SRUSRlNl\PaytTerm 04:58:39 30W)6 SHARMAAStock Type 05:41:33 AA RAYAPRC} Customer ZVENDOR JOSEPHASCustomer 18:57:10 DPLANTIC JOSEPHASCustomer 10:57:59 A124 11:10:34 A124 A124 SRUSRINI\ customer Customer SRUSRlNl\Customer 2 3 26 47 57 86 87 88 2 86 87 22:20:09 STOCKPLA ASSA Customer PLANTVE GURUJAKF Plant 21 SRUSRINI\ Plant 10:50:18 A124 SRUSRINI', Plant 300028 KANEBE Customer 10m STOCK SUP 1112 lcæ *N/A CHG.wmO-33 CHGmm015 The bot triggers the execute macro activity to join the reports and apply defined compliance rules.

Clean_VendorChanges.xisx - Excel x FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW • Wrap Text DEVELOPER ANALYTICS 9, X cut Copy P aste Delete Format 11 05.11.2017 A123 •S Format Painter Clipboard 1 c Font Merge & Center Alignment F G Number Format as Cell Table Styles Styles Insert e Clear • cens cr. Sushil (IN Sort & Find & Filter • 9-lect Editing o ime Vendor Changed E Field NarrCoCd porg New value Old value ChangeNumber 04:58:39 Conditional Formatting • 2 2 3 4 5 6 7 8 9 29.03.2016 13.05.2016 12.05.2016 12.05.2016 12.02.2016 (10.03.2015 110.03.2015 3m006 SHARMAAA o 3m028 KANEBE KUMARVII KUMARMA KUMARMA ASSA RAMANSR RAMANSR JOSEPHAS SRUSRINIVASA 3 W.58•.56 ABCOED 23:04:44 SAJIVENDOR SAJIVENORI STOCKPLANT 11:58:19 X010 X020 21:27:45 DELPLANTVE RD-VENDORI DASHRA USIO ZMOI RPOI 1 lcm SAJI ZOIO Z020 CHGA)30 CHGÄ31 CHG.mm032 CHGÄ035 10 03.03.2016 12 127.07.2015 13 31.10.2017 14 114.12.2016 15 30.10.2017 16 01.10.2015 17 29.02.2016 18 03.03.2016 19 05.11.2017 10:21:53 07:57:22 05:41:33 AA 21 SRUSRINIVASA RATRAPR 21 SRUSRINIVASA RAYAPRCH ZVENDOR 4 JOSEPHAS DPLANTICST JOSEPHAS 10:57:59 A124 SRUSRINIVASA Stock Type Customer Recon. account VSR relevant Plant Customer Plant Plant Payt Terms Payt Terms Payt Terms payt Terms Payt Terms Payt Terms Customer Customer Customer Custom e r x STCEK sup 1 1 1 1 2 2 26 47 57 86 The bot triggers the execute macro activity to join the reports and apply defined compliance rules.

List.xlsx - Excel DEVELOPER ANALYTICS x HOME FILE Copy P aste Delete Format INSERT •S Format Painter Clipboard PAGE LAYOUT Font fx II vendor FORMULAS DATA REVIEW VIEW • Wrap Text Merge & Center Alignment Conditional Format as Cell Formatting • Table Styles Styles Insert e Clear • Number cens cr. Sushil (IN Sort & Find & Filter • 9-lect Editing 1 2 3 4 5 6 7 10 12 13 14 15 16 17 Vendor X020 IX010 ,ChangeNumbe CHGCnm-35 CHGOm-34 STOCKPLANT CHGomCÜ33 SAJIVENORI CHGm32 SAJIVENDOR CHGÆ31 ABCOED CHGom30 Æ28 CHÄ15 The bot triggers the execute macro activity to join the reports and apply defined compliance rules.

Clean_VendorChanges.xisx - Excel x HOME FILE , Cut Copy P aste INSERT FORMULAS DATA REVIEW VIEW • Wrap Text DEVELOPER Insert •S Format Painter PAGE LAYOUT Font 1 c Merge & Center ANALYTICS Number Old value Conditional Formatting Format as Cell Table Styles Styles Delete Format e Clear • cens Sort & Find & Filter • 9•lect Editing o 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 Clipboard 29.03.2016 13.05.2016 12.05.2016 12.05.2016 12.02.2016 10.03.2015 10.03.2015 ime Vendor Changed By Alignment F CoCd USIO G porg 04:58:39 SHARMAAA 3m028 KANEBE W.58•.56 ABCOED 23:04:44 SAJIVENDOR SAJIVENORI STOCKPLANT 11:58:19 X010 X020 KUMARVII KUMARMA KUMARMA ASSA RAMANSR RAMANSR Field Name Stock Type Customer O Recon. VSR relevant Plant Customer Plant Plant New value SAJI ZOIO Z020 3 x Itm STCEK sup ChangeNumber 2 CHGÄ15 CHGÄ30 CHGÄ31 CHGmm032 CHGÄ34 Short desc Vendor M Normal Vendor M Normal vendor M Normal vendor M Normal Vendor M Normal Vendor M Normal vendor M Normal Approval RequestejAssigned f RequesteiCAB da Approved Beth Approved Zane Sulik David Loo Approved Zane Sulik Ron Kette Rejected Taylor FOE Change M Approved Vince Ette Change M Requestel Alejandra Change M Requestei Annette F Certificati The bot triggers the execute macro activity to join the reports and apply defined compliance rules.

SNOW Download .xlsx - Excel x FILE HOME INSERT PAGE LAYOUT Font FORMULAS DATA REVIEW VIEW • Wrap Text DEVELOPER 1 • , Cut Copy P aste •S Format Painter Clipboard ANALYTICS Number Merge & Center c Approval Conditional Formatting Format as Cell Table Styles Styles Insert Delete cens Format e Clear • Alignment Sort & Find & Filter • 9-lect Editing 2 3 4 5 6 7 8 9 10 11 12 14 15 16 18 19 20 21 22 23 Number • Short description Vendor Master Change Vendor Field Customer Vendor Master Change Vendor ABCOAField Recon. account CHÄ32 CHGOm33 CHÄ34 CHÄ35 Vendor Master Change Vendor Field VSR relevant Vendor Master Change Vendor SAJIVENORI Field Plant vendor Master Change vendor STOCKPLANT Field Customer Vendor Master Change Vendor XOIO Field Plant Vendor Master Change Vendor X020 Field Plant Normal Normal Normal Normal Normal Normal Normal Approved Approved Approved Rejected Approved Requested Requested Requested by • Assigned to Requested by Beth Anglin Zane Sulikowski Zane Sulikowski Taylor Fogerty Vince Ettel Alejandra Prenatt Annette Frietas Certification Admin David Loo Ron Kettering Change Manager Change Manager Change Manager Certification Admin 08-05-2017 03:35 05-06-2017 03:34 05-05-2017 03:33 05-05-2017 03:28 10-02-2017 03:27 08-03-2017 03:28 08-03-201702:30 CAB date • User input 10-05-2017 oom Update Customer to 1 07-05-2017 Update Recon. Account 10-05-2017 W:OO uncheck VSR Relevant 10-05-2017 oom Update Plant Field to SAJ 13-02-2017 oom update customer to 09-03-2017 00:00 update Plant Field to zoi 0-03-2017 oo:m Update Plant Field to ZO.

Clean_VendorChanges.xisx - Excel x FILE HOME INSERT PAGE LAYOUT Font FORMULAS 1 • , Cut Copy P aste •S Format Painter Clipboard DATA REVIEW VIEW • Wrap Text DEVELOPER Merge & Center ANALYTICS Number Conditional Formatting Format as Cell Table Styles Styles Insert Delete cens Format e Clear • X Date Alignment F CoCd USIO Sort & Find & Filter • 9•lect • Editing o c Vendor G porg 2 3 4 5 6 7 8 9 11 12 13 14 15 16 17 18 19 20 21 22 23 Date 129.03.2016 13.05.2016 12.05.2016 12.05.2016 12.02.2016 (10.03.2015 10.03.2015 Time 04:58:39 Changed By SHARMAAA 3m028 KANEBE W.58•.56 ABCOED 23:04:44 SAJIVENDOR SAJIVENORI STOCKPLANT 11:58:19 X010 X020 KUMARVII KUMARMA KUMARMA ASSA RAMANSR RAMANSR Field Name Stock Type Customer O Recon. account VSR relevant Plant Customer Plant Plant New value SAJI ZOIO Z020 Old value 3 x STCEK sup ChangeNumber 2 CHGÄ15 CHGÄ30 CHGÄ31 CHG.m0032 CHGÄ35 Short dest Type Vendor M Normal Vendor M Normal vendor M Normal vendor M Normal Vendor M Normal Vendor M Normal vendor M Normal Approval Requestel Assigned 'Requeste'CAB da Approved Beth Approved Zane Sulik David Approved Zane Sulik Ron Kette Rejected Taylor FOE Change M Approved Vince Ette Change M Requestel Alejandra Change M Requestei Annette F Certificati.

Clean_VendorChanges.xisx - Excel x FILE HOME INSERT PAGE LAYOUT Font FORMULAS DATA REVIEW VIEW • Wrap Text DEVELOPER 1 • , Cut Copy P aste •S Format Painter Clipboard Merge & Center p ANALYTICS Number R Conditional Formatting Format as Cell Table Styles Styles Insert Delete cens Format e Clear • Sort & Find & Filter • 9•lect • Editing X •V Short description K L M Alignment o Q 1 2 3 4 5 6 7 8 9 11 12 13 14 15 16 17 18 19 20 21 22 23 Old value x STOCK sup Short descType Approval Requeste.Assjgned Requeste.CAB date 2 CHGm)31 CHGÄ32 CHGÄ33 CHGÄ34 Vendor M Normal Approved Beth Angl Certificati Vendor M Normal Zane Sulik David Vendor M Normal vendor M Normal Vendor M Normal Vendor M Normal vendor M Normal Approved Zane Sulik Ron Kette Rejected Taylor FOE Change M Approved Vince Ette Change M Requeste• Alejandra Change M Requeste• Annette F Certificati.

Now it generates a formatted report with the test results.

x HOME INSERT Record 'v4acr0 PAGE LAYOUT FORMULAS DATA REVIEW Vendor Master Changes Review.xlsm - Excel VIEW DEVELOPER ANALYTICS Map Properties Import STARWizard Document panel Modify cr. Sushil (IN Use Relative References Expansion Packs @..Export Code Visual Macros Basic Add-ins COM Add-Ins Add-Ins c Insert Code Deloitte. Data Extraction Rule Information Design Source Mcxle Run Dialog Controls D Refresh Data XML Automated Controls Testing Tool 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 SAP System-Client ID SAP ERP version I vpe Rule Name Rule Rule Chan es to vendor Master Review The results hst the compliance status of the Vendor Master Cha O based on Request Approval Status, Approval Dates and OOA in the audit penod Shetl @ ct destinauon and press ENTER ot choose Paste.

Input Parameters.xlsx - Excel x FILE HOME INSERT PAGE LAYOUT Font Ol-Jan-18 1234 FORMULAS DATA REVIEW VIEW DEVELOPER Cut P aste •S Format Painter •P/ • Wrap Text Merge & Center Alignment ANALYTICS Number Conditional Formatting Format as Cell Table Styles • Styles Insert Delete Format cens e Clear • Sort & Find & Filter • Editing 2 3 4 5 12 13 14 15 16 17 21 Clipboard Parameter Client Name / Date (SAP system Client-ID SAP ERP version Value ABC EHP7 for SAP ERP 6.0 ct destinauon and press ENTER ot choose Paste.

x HOME INSERT Record Muro PAGE LAYOUT FORMULAS DATA REVIEW Vendor Master Changes Review.xlsm - Excel VIEW DEVELOPER ANALYTICS Map Properties Import STARWizard Document Panel MO dify cr. Sushil (IN Use Relative References Visual Macros Add-ins COM Add-Ins Add-Ins c Insert ABC Expa nsion Packs @..Export View Code Design Source Basic Macro Security Code B Deloitte. Data Extraction Rule Information Mode Run Dialog Controls Refresh Data XML SAP System-Client ID SAP ERP Version Automated Controls Testing Tool 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 I ype Rule Name Rule De Rule Changes to vendor Master Review The results list the compliance status of the Vendor Master Changes based on Request Approval Status, Approval Dates and DOA in the audit penod O Shetl @ ct destination and press ENTER or choose.

Input Parameters.xisx - Excel x FILE HOME INSERT PAGE LAYOUT Font FORMULAS DATA REVIEW VIEW • Wrap Text DEVELOPER • , Cut Copy P aste •S Format Painter Merge & Center Alignment ANALYTICS Number Conditional Formatting Format as Cell Table Styles • Styles Insert Delete cens Format e Clear • sort& Find& Filter • Editing 2 3 4 5 10 12 13 15 16 17 21 Clipboard Parameter I Client Name Extraction Date SAP system Client-ID SAP ERP version Value ABC fx 01-01-2018 Ol-Jan-18 1234 EHP7 for SAP ERP 6.0 ct destination and press ENTER ot choose Paste.

x HOME INSERT Record Mu ro PAGE LAYOUT FORMULAS DATA REVIEW Properties View Code Design McKie Run Dialog Controls Vendor Master Changes Review.xlsm - Excel VIEW DEVELOPER ANALYTICS STARWizard Map p roperties Import Expa nsion Packs @..Export Document Refresh Data Panel XML MO dity SAP System-Client ID SAP ERP Version cr. Sushil (IN Use Relative References Visual Macros Macro Security Basic Add-ins COM Add-Ins Add-Ins 01-01-2018 c Insert Automated Controls Testing Tool 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Code •l I X v-fx B Deloitte. Data Extraction Rule Information ABC 01-jan-18 I ype Rule Name Rule De Rule Changes to vendor Master Review The results list the compliance status of the Vendor Master Changes based on Request Approval Status, Approval Dates and OOA in the audit #riod O Shetl @ ct destination and press ENTER or choose.

Input Parameters.xlsx - Excel x FILE HOME INSERT PAGE LAYOUT Font FORMULAS DATA REVIEW VIEW • Wrap Text DEVELOPER 9 , Cut P aste •S Format Painter Clipboard 1 Parameter 2 ICIient Name 3 pata Date 4 SAP system Client-ID 5 SAP ERP version 12 13 15 16 21 Merge & Center Alignment ANALYTICS Number Conditional Formatt'ng Format as Cell Table Styles Styles Insert Delete Format cens e Clear • Sort & Find & Filter • Editing Value ABC Ol-Jan-18 1234 EHP7 for SAP ERP 6.0 ct destination and press ENTER ot choose Paste.

x HOME INSERT Record PAGE LAYOUT FORMULAS DATA REVIEW Vendor Master Changes Review.xlsm - Excel VIEW DEVELOPER ANALYTICS STARWizard Map P roperties Import cr. Sushil (IN Use Relative References Visual Macros Add-ins COM Add-Ins Add-Ins c Insert ABC Expansion Packs @..Export Design Source Basic Macro Security Code Deloitte. Data Extraction Rule Information Mode Run Dialog Controls Refresh Data XML SAP System-Client ID SAP ERP version Document panel Modify 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Automated Controls Testing Tool 1234 Ol-Jan-18 I vpe Rule Name Rule Rule Chan es to venacr Master Review The results hst the compliance status of the Vendor Master Cha O e.s based on Request Approval Status, Approval Dates and OOA in the audit penod Shetl @ ct destination and press ENTER ot choose Paste.

and Request Compansonxisx • Excel x FILE Paste Delete Format Filter • HOME cut INSERT 1 PAGE LAYOUT Font c Raised FORMULAS Validation DATA Approval Validation REVIEW Alignment VIEW W'ap Text Merge & C entel ANALYTICS Number AutoSum Condit New 3 222222 SAJI Z020 Format Cell Table • Styles • Styles Insert Sort & Find & S Format Painter Clipboard Vendor Cells 2 3 4 5 6 7 8 9 10 11 12 13 15 16 17 18 19 20 21 22 ASCOEO SAJIVENmR STOCXPLANT u X020 Not Av&l'bie CHGÄi5 CHG(m30 CHGtm31 CHGæ32 CHGÄ33 Approver Changed Bv Val idation SHARMAAA KANEBE KIJMARVII KUMARMA KUMARMA RAMANSR RAMANSR Date 29032017 13052017 12 05 2017 12052017 12022017 1003.2017 Field N•me Custorner Recons ucount VSR relev•nt Plant Customer Plant Plant Old 2 sup Request Aomoval 10-092017 0705-2017 10-05-2017 10-05-2017 13-02-2017 09-03-2017 09-03-2017 Approval Status Approved Approved Approved Rejected R equested Requested Editing Request« Beth Anglin Zane Sullkowski Zane Sul'kowski Taylor F %ertv Vince Ettel Alejandra Prenatt Annette Fri etas -1 Assigned to Certification Admin David Loo Ron Change Menuet Change Change Manager Certification Admin.

x FILE HOME INSERT Record Macro PAGE LAYOUT FORMULAS DATA REVIEW Properties View Code Desig n Run Dialog Controls Vendor Master Changes Review.xlsm - Excel VIEW DEVELOPER ANALYTICS STARWizard Map P roperies Import Expansion Packs Export Use Relative References Visual Muros Macro Security Basic Add-Ins COM Add-Ins Add-Ins c Insert ABC Source Refresh Data XML SAP System-Client ID SAP ERP version Document Panel Mo dify 812 2 3 4 5 6 7 8 9 10 11 141 13 14 15 16 17 18 19 20 21 22 23 Code Deloitte. Data Extraction Rule Information I ype Rule Name Vendor 3Æ6 ABCOEO SAJIVENDOR SAJIVENORI STOCKPLANT XOIO X020 Automated Controls Testing Tool 1234 EHP7 for SAP ERP 6.0 Ol-Jan-18 Rule Chan es to venacr Master Review The results hst the compliance status of the Vendor Master Cha based on Request Approval Status, Approval Dates and OOA in the audit penod ChangeNumber Not Aval lable CHGÄIS CHGÄ30 CHGOÆ31 CHGwm32 CHGOOü33 CHGWCW34 CHGC030035 Request Raised Date Validation Approval Validation Approver Validation cr. Sushil (IN Changed BV SHARMAAA KANEBE KUMARVII KUMARMA KUMARMA RAMANSR RAMANSR 291320: 13.05.20 u.%.20: 120520: 120520: 120220: 10.0320: 10.0320: A formatted Report is created clearly highlighting compliant and non compliant cases.

Vendor Master Changes Review - Copy x File Copy Home Share Cut Copy path Paste View Move Copy Delete Rename o New item • Open • Easy access • Edit Paste shortcut to • to • Clipboard Organize New folder New t Vendor bdaster Changes Review - Copy Properties History Open Type Microsoft Excel Worksheet Microsoft Excel 97-2Ø3 Worksheet Microsoft Excel Macro-Enabled Select all Select none Invert selection Select 16 KB 27 KB Search Vendor Master Chang... Favontes Desktop Recent places Downloads This PC Desnop Downloads Music Pictures Videos OSDisk Network Name SNOW Downloadxlsx Vendor Chan#s Report.xls Vendor Master Changes Review.xlsm.

x Test results are mailed to relevant stakeholders for action.

Benefits of Automation.

Intxyx - saqaqarwal@deloittexom - Chtlcx* AS2 Tell me what you want to do — x File New New F mail Items Favorites Int»x 1 Sent Items / Receive Clean Up • Delete _ Junk • Folder S.r•ew Add-ins McAfee Gmail Scan Reply Reply Forward Mote • Move to: ? Team Email Repty & Delete To Manager mne Create New Move Rules Quick steps OneNote Reolv Address Categonze Follow Fitter Email • Up • rind f•Reotv All Forward e. 1M Vendor Master Changes Review Store Add ins Search Current M&dbox (Ctrl All Unread Vendor Master Changes Review Report p Current Midbox • By Date • Newest 17:14 Deleted Items sagagarwal@deloitte.com Conversation History Ckleted Items Drafts Sent Items Junk Email Outt»x RSS Feeds Search Folders Outlook Data File Inmx 1 Drafts Items Deleted Items Junk F -mail RSS Feeds Search Folders Hi team. please fine attached the vendor Master Changes Vendor Master Changes Reviewxlsm 30 KB Hi Team, Please find attached the Vendor Master Chapges Review Report.

Robotic Process Automation in Controls Testing.

Deloitte..