Power Community

Power Community

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

Now lets see how we can setup policy to identify these duplicate invoices.

Note-1: These policies can not be applied to “Invoice journal” , it can only be applied if invoices are posted through “Pending vendor invoice”

Note-2: We should have case category setup with type Audit

Setup policy rule type

Audit work bench > Setup > Policy rule type > New

Create Audit policy

Audit work bench > Setup > Audit policy > New

Setup group criteria

Test policy

Run batch job for the policy

View generated Audit case

Audit work bench > Audit cases

That’s it for this blog. I will be back with next part with more uses cases.

Thank you !!! Keep reading and sharing !!!

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

How to install Power Platform Tools in Visual Studio Code?

The Power Platform extension makes it easy to manage Power Platform environments and allows the developer to create, build...

More Articles Like This

- Advertisement -spot_img