Finance | Project Operations, Human Resources, ...

Accounts Payable Duplicate invoice check across multiple organisations

(0) Share

Report

Posted on by ReganMitchell

105

Hey guys,

Currently we have a duplicate invoice check being performed which is picking up duplicate Accounts Payable invoices based on Supplier and Invoice Number. The issue is that suppliers can send invoices to a different organisation within our D365 F&O which bypasses the Duplicate check.

Can you advise how we can set up the duplicate check to be global across all organisations? For what it counts we have one shared list of suppliers.

Cheers,

Regan

I have the same question (0)

All responses (6)

Answers (0)

ReganMitchell 105 on at

Like (0)

Report

RE: Accounts Payable Duplicate invoice check across multiple organisations

Thanks Ramit and Billur. I have suggested it as an idea here experience.dynamics.com/.../

Was this reply helpful? Yes No
BillurSamdancioglu 18,685 Most Valuable Professional on at

Like (2)

Report

RE: Accounts Payable Duplicate invoice check across multiple organisations

Hi,

You can use Ideas portal for that purpose to offer a solution but as Ramit mentioned this is by design.

Was this reply helpful? Yes No
ReganMitchell 105 on at

Like (1)

Report

RE: Accounts Payable Duplicate invoice check across multiple organisations

Thanks, Ramit. I was hoping for a way to resolve this without customisation as I thought it to be a pretty standard problem that Microsoft would have considered.

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,795 Most Valuable Professional on at

Like (0)

Report

RE: Accounts Payable Duplicate invoice check across multiple organisations

Ahh! Now I understood the problem statement.

I think this needs a small customization as current solution is as per the design.

Was this reply helpful? Yes No
ReganMitchell 105 on at

Like (0)

Report
RE: Accounts Payable Duplicate invoice check across multiple organisations

Thanks Ramit, I understand that it is entity specific and it is currently active for all legal entities (current set to reject duplicates, see below). The issue comes down to when the same invoice is received in 2 different legal entities.

For example;

Supplier 00001 sends invoice ABC123 to entity TEST1

TEST1 processes the invoice with no issues.

Supplier 00001 re-sends invoice ABC123 to entity TEST1

TEST1 deletes the invoice as it is flagged as a duplicate.

Supplier 00001 then re-sends invoice ABC123 to entity TEST2

TEST2 processes the invoice because it is not flagged as duplicate since it has only been processed in entity TEST1 and this is the first time it is being processed in TEST2 legal entity

Step 6 above is where the issue lies and we need it to flag as a duplicate given the invoice for this supplier has already been processed by another legal entity.

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,795 Most Valuable Professional on at

Like (1)

Report

RE: Accounts Payable Duplicate invoice check across multiple organisations

Ap parameter is LE specific, you can use data entity by using copy into legal entity function to copy the parameter to all LE.

Was this reply helpful? Yes No