Caseware IDEA Procurement Analytics 21 Reports скачать в хорошем качестве

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