We would like to block duplicate entries from being posted into our database especially the BP ref no field in the AP invoice.
I have read through a post which shows the procedure of doing this through an approval procedure. However, is there another way to prevent duplicate entries like this from adding into the database such that it blocks the user if he has duplicated this field rather than sending an apprval procedure? One way of doing this is by creating an SBO_SP_TransactionNotification which blocks the transaction from adding. Would someone be having a sample code for this?
Thanks & Regards,
Asif