Skip to Content
0
Former Member
Feb 11, 2009 at 06:47 AM

Blocking of duplicate entry

1666 Views

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