cancel
Showing results forĀ 
Search instead forĀ 
Did you mean:Ā 
Mbreaith
Occasional Member - Level 1

Duplicate Transactions on same employee

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 

3 REPLIES 3
cjmarimo
Super User
Super User

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 CheckAudit 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.



āœ”ļøHope this helps! Let me know if you have any questionsāœ”ļø

  Best Regards,

  CJ

Mbreaith
Occasional Member - Level 1

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

 

Kind Regards, 

Mary 

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.
 


āœ”ļøHope this helps! Let me know if you have any questionsāœ”ļø

  Best Regards,

  CJ