Restrict duplicate invoice number irrespective of Operating Unit using form personalization

Hi All,

We need to restrict/show error when user enters the same invoice number if it exists for the same supplier irrespective of OU.

OU might be different but the invoice number should not be the same for the same supplier.

I have added form personalization as below, so that once the Invoice number in entered and press tab, then the cursor will move to Invoice amount field, and then it will validate the invoice number whether it exists or not.

Error message is shown as expected. Screenshot shown below:

Issue is - It is allowing to close the error and input the invoice amount and other fields and if we SAVE, it is allowing to SAVE