Matt Storlie has been using CaseWare IDEA on and off during his career for 15 years, and at Wipfli for three years. I have a very good feeling that with IDEA we can achieve lots of automation in our Audit processes.On Record: Matt Storlie, Manager of Forensic & Litigation & Risk Advisory Services Please share your comments and suggestions. Please watch my below video to get complete understanding on how IDEA Macro enabled me to generate those 16 Reports in just 6-8 minutes. SAP Tables - EKKO, EKPO, BSIK, PA0002, PA0006, PA0009, LFA1 and LFBK. In order to generate these 16 reports we need data from 8 SAP Tables. Test 16 - Vendors with Nil Balance with more than 5 Lakhs transactions Test 15 - Vendors with Single PO with value above Rs. Test 14 - Same Material Procured from Diff Vendors at Different Price Test 13 - Material Procured from same Vendor at Diff. Test 12 - Same Material Procured from Diff Vendors with Diff Price on Same Day Test 11 - Multiple PO for Value Split by Diff Users on Same Day for same Material Test 10 - Multiple PO for Value Split by Same User on Same Day for same Material Test 9 - Purchase Orders created on Public Holidays Test 8 - PO created without GR based Invoice Verification Check Test 7 - PO created without a Release Strategy Test 6 - PO and Contract Created without Purchase Req Test 5 - PO and Contract Pending for Release for more than 90 Days Test 4 - PO Details of Vendors having same Bank Account Test 3 - Same Vendor having Multiple Master Data with PO Details Test 2 - More than One Vendor having same Bank Account Test 1 - Employee and Vendor having same Bank Account Details of these 16 Reports are as below. In this article, I am going to explain how I could create a Macro in Caseware IDEA to generate 16 different Analytics Reports relating to Procurement audit. They can get analytical reports generated within minutes. Using Caseware IDEA Data Analytics, we can achieve this very easily and with Macro functionality of Caseware IDEA, users don't need to be expert in IDEA as well. With so much of data getting generated in SAP ERP or for that matter any other ERP System related to Procurement related transactions, it is next to impossible for Auditors to analyze these humongous data and draw some conclusions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |