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.