This question has been flagged
1 Reply
7489 Views

What would be the best way to implement a "duplicate check" when users are recording a supplier invoice?

The aim would be to avoid accountants entering the same invoice twice, based on the supplier invoice number.

It shouldn't prevent them from entering the invoice - just warn them that an existing invoice is already in the system with the same number.

constraints prevent duplicate entry, the objective here is just to detect a potential duplicate and warn the user - letting them enter it again if they need to.

Avatar
Discard