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