Skip to Content
0
Former Member
Apr 21, 2010 at 05:45 AM

SBO_SP_TransactionNotification for duplicate business partner

465 Views

I want to use SBO_SP_TransactionNotification for validating duplicate business partners.I want to restrict user from adding business partner having same name i.e. duplicate cardname. So I want a query which searhes the ocrd table using cardname as condition.

IF @transaction_type = 'A' AND @object_type = '20'  
BEGIN
if exists(Select CardName FROM OCRD WHERE CardName= @list_of_cols_val_tab_del  )
begin
	SELECT @error=1,@error_message='Duplicate business partner'
end
END

@list_of_cols_val_tab_del gives docentry. I want a parameter which gives CardName.