Skip to Content
0
May 07, 2018 at 11:33 PM

Post Transaction Notification Update is not working

2414 Views

HI Experts,

I have to update an UDF in the GRPO on change of the Bin location in the Item Master

I used the logic in the Post Transaction notification but does not seem to work. Any help will be greatly appreciated. This is very urgent.

IF @object_type = '31' and @transaction_type in ( 'A','U') BEGIN

DECLARE @WHSCODE NVARCHAR(10)

DECLARE @ITEMCODE NVARCHAR(100)

SET @WHSCODE = (SELECT WHSCODE FROM OITW WHERE OITW.WhsCode = @list_of_key_cols_tab_del )

SET @ITEMCODE = (SELECT ITEMCODE FROM OITW WHERE OITW.ITEMCODE = @list_of_cols_val_tab_del)

UPDATE PDN1 SET PDN1.U_Bin_Loc = OITW.U_STKBINS FROM PDN1 INNER JOIN OITW ON OITW.ItemCode = PDN1.ItemCode WHERE OITW.ITEMCODE=@ITEMCODE AND OITW.WHSCODE= @WHSCODE

END

Any help will be greatly appreciated