Caseware IDEA Procurement Analytics 21 Reports

In this video, I am showing power of Caseware IDEA on how we can generate 21 different analytics relating to Purchase transactions using 11 SAP Tables.
Those SAP Tables are LFA1, LFBK, BSIK, EKKO, EKPO, EKBE, EKBZ, EKET, PA0002, PA0006 and PA0009.

21 Analytics Reports are:
Test 1 - Employee and Vendor having same Bank Account
Test 2 - More than One Vendor having same Bank Account
Test 3 - Same Vendor with Multiple Master Data with PO Details
Test 4 - PO Details of Vendors having same Bank Account
Test 5 - PO and Contract Pending for Release for more than 90 Days
Test 6 - PO and Contract Created without Purchase Req
Test 7 - PO created without a Release Strategy
Test 8 - PO created without GR based Invoice Verification Check
Test 9 - Purchase Orders created on Public Holidays
Test 10 - Multiple PO for Value Split by Same User on Same Day for same Material
Test 11 - Multiple PO for Value Split by Diff Users on Same Day for same Material
Test 12 - Same Material Procured from Diff Vendors with Diff Price on Same Day
Test 13 - Material Procured from same Vendor at Diff. Price
Test 14 - Same Material Procured from Diff Vendors at Different Price
Test 15 - Vendors with Single PO with value above Rs. 5 Lakh
Test 16 - Vendors with Nil Balance with above 5 Lakhs Transactions
Test 17 - Material Delivery Pending for more than 90 Days
Test 18 - Excess Materials Delivered against Purchase Order Quantity
Test 19 - Goods Receipt but Invoice Not Receipt
Test 20 - Vendor Aging Analysis in 30, 60, 90, 120, 180, 365 days bracket
Test 21 - PO Vendors and Invoice Vendors are Different