BeyondERP.Newsletter
Menu

Setup page · Audit workbench

Policy rule type

A setup page where you define policy rule types, each based on a predefined audit query and a query type, that audit policy rules are built from.

Used by
Auditor, Financial controller
Business process
Audit financial transactions
Menu item
AuditPolicyRuleType
Main table
SysPolicySourceDocumentRuleType
Data entity
VendInvoicePolicyRuleTypeEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define policy rule types, each based on a predefined audit query and a query type, that audit policy rules are built from.
What you do hereUse this page to choose the query that defines the documents to audit, the query type, and the fields that identify the legal entity and the document date used for selection.
ExampleFor example, a rule type can use the Expense report line query with the Aggregate query type and the modified date and time as the document date.
Policy rule type page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAnalyze financial performance › Audit financial transactions
Menu pathAudit workbench › Setup › Policy rule type
Used next byAudit policies Microsoft Learn
Related pagesCase grouping criteria Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Policy rule type

Use this page to choose the query that defines the documents to audit, the query type, and the fields that identify the legal entity and the document date used for selection.

Steps from Microsoft

  1. Go to Audit workbench > Setup > Policy rule type.
  2. Select New.
  3. In the Rule name and Description fields, type values.
  4. In the Query name field, select a query.
  5. In the Query type field, select a query type.
  6. In the Legal entity and Document date reference fields, select the fields to use.
  7. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Rule nameThe name of the policy rule type, up to 100 characters.Microsoft Learn Name
DescriptionA user-friendly description of the rule, up to 500 characters.Microsoft Learn Description
Query nameA predefined query whose name begins with AuditPolicy that defines the data reviewed in the audit; new queries cannot be created from the user interface.Microsoft Learn
Document typeRead-only name of the primary table that the query uses, which is the type of document the policy audits.Microsoft Learn
Query typeConditional, Aggregate, Sampling, Duplicate, List search, or Keyword search; it controls the default fields on the query and policy rule pages.Microsoft Learn QueryClassification
Legal entityThe column of the document table that shows the company or legal entity the document belongs to.Microsoft Learn
Document date referenceThe date or date/time field used to select documents by the batch or test date range.Microsoft Learn

Test checklist

  1. Create a rule type with Query name Expense report line, Query type Aggregate, Legal entity and a Document date reference.
  2. Check Document type fills in from the query.
  3. Create a policy rule from it on an audit policy and run Test for a date range.
  4. Try to activate a second rule for the same rule type and check only one can be active.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Policy rule typeOne rule type per audit check, choosing the Query type that matches it (Conditional, Aggregate, Sampling, Duplicate, List search or Keyword search) and a Document date reference that matches how you will set batch date rangesOnly one policy rule can be active at a time per rule type, and the document date field decides which documents fall inside a run's date range.Expecting to build a new query here. Only predefined queries whose names begin with AuditPolicy can be selected; new queries must be created in code.
Solution architect

5Design impact

Can it be undoneReversible: Rule types can be maintained, but the date field and query type set here drive every policy rule built on them, so a change alters what later runs select. Microsoft Learn
If you change it laterOnly one policy rule can be active at a time for each policy rule type, and the date field chosen here decides which documents fall inside a policy run's date range. Microsoft Learn
Technical architect

6Technical

Menu itemAuditPolicyRuleType Checked in Dynamics 365
FormSysPolicySourceDocumentRuleType Checked in Dynamics 365
TableSysPolicySourceDocumentRuleTypeShown as “POLICY SOURCE DOCUMENT RULE TYPE” in Record infoChecked in Dynamics 365
Data entitiesVendInvoicePolicyRuleTypeEntityVendor invoice policy rule types Microsoft data model PayrollPremiumEarningPolicyRuleTypeEntityPayroll premium earning policy rule type Microsoft data model
Who can open itPrivilegesMaintain audit policy rule types AuditPolicyRuleTypeMaintainView audit policy rule types AuditPolicyRuleTypeViewDutiesInquire into audit policies AuditPolicyInquireMaintain audit policies AuditPolicyMaintain
2 security rolesAuditor AuditPolicyManagerFinancial controller LedgerFinancialController
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAuditor AuditPolicyManagerTo use itFinancial controller LedgerFinancialControllerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=AuditPolicyRuleType
Integrate withVendInvoicePolicyRuleTypeEntity data entity Microsoft data model
Data migrationVendInvoicePolicyRuleTypeEntity (Vendor invoice policy rule types): shared by all companies, in Microsoft's default template 120 - Accounts payable.PayrollPremiumEarningPolicyRuleTypeEntity (Payroll premium earning policy rule type): shared by all companies.Load order: Microsoft's default template 120 - Accounts payable loads Vendor invoice policy rule types at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionSysPolicySourceDocumentRuleType columns and relations Microsoft data model
Everyone

8Sources