Duplicate Transactions on same employee

[Mbreaith]

Hi! 

Employees are receiving duplication errors on their own expense reports because the transaction amounts are within a certain percentage. Is it possible to have the audit rule to only flag when it's a true duplicate: vendor name, amount and transaction date. Excluding the expense type. Is that possible?

Kind Regards, 

Mary 

[cjmarimo · Accepted solution]

Hello @Mbreaith,

Duplicate detection rules are primarily designed to compare:

• Expense Type
• Transaction Date
• Amount

If any of these criteria do not match, the transaction is generally not considered a duplicate. In addition, Vendor Name is not part of the standard duplicate detection criteria.

The Duplicate Transaction Variance option is specifically based on (Duplicate Transaction Variance | SAP Help Portal😞

• The same Expense Type
• The same Transaction Date
• The same Amount, or an amount within a configured variance percentage
• Expenses submitted by the same employee

Audit Rule - Duplicate Transaction Check

Therefore, it is not possible to replace the "Expense Type" criterion with "Vendor Name" using the standard Duplicate Transaction Check or Duplicate Transaction Variance functionality.

[Mbreaith]

Thank you! 
How would I update it to be an exact match on the amount and not within a percentage range?

Kind Regards, 

Mary 

[cjmarimo]

Helo @Mbreaith ,

Unfortunately, the standard Duplicate Transaction Variance audit rule is designed to work with a percentage variance and does not support an exact amount match. SAP Concur states that all variances are percentage-based and that the Equal operator should not be used with this condition.