Skip to Content
0
Former Member
Jul 27, 2010 at 02:47 PM

Warehouse

26 Views

Hi

IF @transaction_type IN (N'A') and @object_type = '112'

BEGIN

UPDATE drf1 SET U_UDF = u_whse

WHERE DOCENTRY = @list_of_cols_val_tab_del

END

In addition to this i want that this should happen only in case of a particular user and only when document is Sales Order.

Thanks