Identify duplicate invoices using Audit workbench policies in Microsoft dynamics 365 finance and operations: Part-1

In today’s blog post, we will discuss a highly significant and often overlooked feature in D365 that can provide a significant level of control for various types of documents.

By leveraging audit policies, you gain the ability to evaluate expense reports, vendor invoices, and purchase orders, ensuring their compliance with policy rules that you define. These policy rules are executed in batch mode according to a specified schedule. Each policy rule is associated with a specific rule type, and only one rule of each type can be active at a given time.

Audit policies are employed to identify non-compliant expense reports, purchase orders, and vendor invoices based on predefined business rules, which are configured as audit policy rules. When executing an audit policy, all related policy rules are processed simultaneously in batch mode.

Each policy rule focuses on a specific set of documents, selecting those that fall within a designated document selection date range and meet the specified criteria. For example, one rule might target expense reports with meal expenses exceeding $50.00, while another rule could concentrate on vendor invoices payable to a particular vendor. Whenever a document within the selected set fails to meet the criteria of a policy rule, a violation is generated. These violations act as records indicating that a specific document, such as invoice 12345, does not adhere to the corresponding policy rule.

We have different types of queries available in this module but today we will talk about “Duplicate” query option with one specific scenario.

Scenario: USMF AP clerks are posting lot of invoices on day-to-day basis, now while posting these invoices due to typing mistake sometimes same invoice is entered twice with minor difference e.g. “Test888” and Test 888” both are same but in system both are posted