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

How to detect duplicate invoice number within certain time period?

There is one audit rule option as is "Is this Invoice duplicate" for duplication checking for invoice number with Exception Code DUPINV.


It works good for most cases when we need to check duplicate invoice number before submission.

But here is one exception. It cannot check with the parameter of checking time period range. It will check all invoices for that vendor.


Is there any possible solution for us to narrow the time range?


Our vendor would reset their invoice number range every year. So there is possibility for us to receive difference invoices for different fiscal years with same invoice number.


We tried to add condition, such as only check Invoice date after YYYY/MM/DD, but it does not work. It still check all invoices.


We would appreciate if anyone can share some solution for this case.