Finance Demo ScriptAudit workbench.docx

1、Finance Demo Script Audit workbench Microsoft Dynamics AX 2012 R2 Audit workbench January 2013Version 1.0.0ContentsIntroductionThis document examines the new audit workbench functionality included in Microsoft Dynamics AX 2012. The primary objective of this demo script is to provide the user with an

2、 overview of the new audit rules, policies and cases and how it can improve operational effectiveness by detecting fraud early and reduce the costs associated with auditing.This document and its included script:Demonstrates the ability to define common audit rules, such as random sampling of expense

3、 reports, purchase orders, and vendor invoices.Explains how to create flexible audit policies, allowing you to define specific audit rules which can be applied to one or more legal entities in your organization.Upon completion of the audit policy, violations are grouped into audit cases, allowing au

4、ditors to research and record all findings regarding violations.AudienceThe script in this document should be used to demonstrate the value of Microsoft Dynamics AX 2012 to a business decision maker (BDM). The executives that you present to will find value in this script if they are challenged with:

5、 Maintaining strong continuous controls on expenditures in their organizationExpensive, non-repeatable, time consuming auditsThis script targets CFOs, Controllers, and Internal auditors who need to create strong process controls which effectively detect fraud early and to which action can be taken q

6、uickly to eliminate fraud and stop the problem. Scenario This script focuses on the following processes:Policy rule types: Manage which documents are to be audited as well as the query type used to audit those documents. Audit policies: Assign policies to specific legal entities in an organization,

7、schedule the policies as well as define specific audit rule criteria.Audit cases: View, research and record all findings regarding audit violations Problems this Demo AddressesThis script focuses on solving issues around time consuming manual audits by providing rich user defined audit rules that ca

8、n be scheduled to run automatically. Additionally any violations found are automatically grouped into audit cases allowing for ease of maintenance and tracking. Key Pains or business imperativesEffectively manage audit costs of critical business processesManual audit queries are time consuming and e

9、xpensiveEffectively track and record audit violationsDemo Preset Configuration:This script was written to work with the Microsoft Dynamics AX 2012 R2 RTM Virtual Machine (VM), released in December 2012. Make sure that the VM is up and running and that you have logged on. The script addresses key pai

10、n points and challenges that different roles might face. However the demo can be completed as the system administrator.Domain: CONTOSOUser: AdministratorPassword: password1OverviewMicrosoft Dynamics AX 2012 introduces the Audit Workbench which is a fully automated auditing solution which can be used

11、 detect fraud early and strengthen internal processes and controls. The following provides a list of demonstrations covered in this script: Policy rule typesAudit policiesAudit cases Demo 1: Policy rule typesScenario and BackgroundIn Microsoft Dynamics 2012 you can define audit rules types which wil

12、l allow you to audit expense reports, vendor purchase order or vendor invoices. Six different query types can be used to define the policy rules: Conditional, aggregate, sampling, duplicate, list search and keyword. In this scenario Sara, Contosos CFO is reviewing several draft travel budgets for th

13、e next fiscal year and has noticed some significant increases in hotel lodging year over year. Sara wants to gather some more data around why Contoso is spending more on hotels to determine if they need to negotiate better rates with corporate hotel chains, or change Contosos expense policies regard

14、ing where and how much employees can spend per night at a hotel. In addition, Sara wants to make sure that the increases are not attributed to internal fraud. Sara tells Ken that she wants Contoso to start auditing high dollar hotel expenses on expense reports so they better understand who is incurr

15、ing those charges, where they are occurring and for what events. In addition she tells Ken she wants to understand if any employees are attempting to defraud Contoso by entering expense lines multiple times across different expense reports. Ken logs into Dynamics AX and creates 2 policy rule types,

16、one to check for duplicate expense lines and then other a policy rule type that will allow Contoso to aggregate amounts across expense reports based on a set of conditions. 1.Open Compliance and internal controls Setup Audit Policy rule type 2.Click New to add a rule type.3.Enter High dollar hotel i

17、n the Rule name field. 4.In the Query name field select Expense report line.5.In the Query type field select Aggregate.6.In the Legal entity field select Legal entity.7.In the Document date reference field select Modified date and time.8.Click New to add another rule type.9.Enter Duplicate in the Ru

18、le name field. 10.In the Query name field select Expense report line.11.In the Query type field select Duplicate.12.In the Legal entity field select Legal entity.13.In the Document date reference field select Modified date and time.Additional policy rule types can be created in this form such as a r

19、andom sample of purchase orders over a certain amount, and queries for specific words existing on expense reports and so on. End of Demo Scenario 1Demo 2: Create Audit policyAudit policies allow you to run a collection of audit rules against one or more legal entities in your organization. The audit

20、 rule criteria can be set per audit policy and each policy can be scheduled to execute once or on a recurring basis. Now that Ken has created the High Dollar Hotel policy rule type he can include that in an Audit policy rule for Contosos US legal entities and further specify the criteria for the rul

21、e. 1.Open Compliance and internal controls Common Policies Audit policies2.On the Action Pane, click Policy.3.In the Name field type, Contoso USA policy4.Expand the Policy organizations FastTab and select Contoso Entertainment System USA, Contoso Consulting USA and Contoso Retail USA and click the A

22、dd button. .5.Next expand the Policy rules FastTab6.Select the Duplicate rule type and click the Create policy rule button.7.In the Audit policy rule form enter 90 in the Additional days to evaluate for duplicates field.8.Next click the Select button. 9.Select the Group tab and select the Add button

23、.10.Enter in the following criteria in the field column:NameExpense categoryTransaction dateTransaction amount11.Click OK to close form.12.Click OK to close form.This rule will consider any expense line which has the same employee, expense category, transaction date and transaction amounts as a dupl

24、icate. 13.Next select the High dollar hotel rule type and click the Create policy rule button.14.In the Audit policy rule form click the Select button. 15.Select the Range tab and set the Criteria field on the Expense category field to Hotel.16.Select the Aggregate tab and click Add.17.Select Transa

25、ction amount for the Field.18.In the Aggregate Function field select Sum. 19.Select the Group by tab and click Add.20.Select Employee as the field.21.Click Add.22.Select Expense category as the field.23.Select the Having tab and click Add.24.Select Transaction amount as the field.25.Select Sum as th

26、e AggregateFunction.26.Enter 2000 as the Criteria.27.Click OK to close form.28.Click OK to close form.29.In the Audit policy form select the Additional options button on the Action pane. 30.Enter 1/1/2013 in the Starting date field31.Enter 1/31/2013 in the Ending date field.32.Select the Batch butto

27、n.33.In the Audit policy batch processing form select the OK button. Upon clicking the OK button the Infolog form should open with a message indicating that the Audit policy batch processing job has been added to the batch queue. End of Demo Script 2Demo 3: View Audit casesUpon completion of the aud

28、it policy batch job if any expense reports were found in violation of any of the audit rules contained in an audit policy one or more audit cases will automatically be created. 34.Open Compliance and internal controls Common Audit Audit cases.In the Audit cases list page you should see an audit case

29、 created with a Description of Audit High dollar hotel and an audit case created with a Description of Duplicate35.Double click on the High dollar hotel audit case to open the details.36.Expand the Associations FastTab.In the Associations grid you should see one or more expense reports that contain

30、hotel charges that create a combined total greater than $2000. 37.Select one of the expense reports in the grid and select the Details button.38.In the Expense report form you are able to view more details regarding the expense report including the hotel charges. Additional note regarding research o

31、n the expense reports that are attached to the audit case can be captured in the Case log section of the audit case. End of Demo scriptConclusionThis demonstration has guided you through automating the audit process by:Creating policy rule typesoIndicate the documents you wish to auditoSelect which

32、of the six query types you want to useExecuting flexible audit policiesoCreate rich user-defined audit rules per policyoExecute the policy against one or more legal entities in your organizationoSchedule the audit policy to execute once or on a recurring basisoDocuments containing audit violations automatically attached to audit