Skip to Content
0
Former Member
Jul 11, 2008 at 10:43 AM

help in SBO_SP_TransactionNotification

14 Views

hai ,

I alter the procedure like

IF @transaction_type IN (N'A', N'U') AND (@Object_type IN ('22'))

BEGIN

if exists (select count(*) from opor where cardcode=(select o.cardcode from opor o where o.docentry =@list_of_cols_val_tab_del ))

BEGIN

SET @error = 10

SET @error_message = N'cardcode is repeated'

END

END

If the vendor already do an purchase order then the vendor don't allow to make purchase order.So I add the above code in the SBO_SP_TransactionNotification procedure.

But the purchase order does not allow me to save for the vendor who doesn't make the purchase order or who already make purchase order.It give the error what i give in the procedure.

can anyone help me.It is urgent.

Regards,

Ramya.s

Edited by: Ramya sukumar on Jul 11, 2008 12:44 PM