How To Create Invoice with same number by adding validation as creation date

Summary:

Hi Team,

We have a business requirement where they want to invoice with number which already in use with same supplier and site details. Is there is any possible to way to achieve by adding more validation during invoice creation like creation date or any column which make the unique combination and invoice will not get rejected as duplicate invoice.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):