How do I trigger a User Defined Object in PostTransactionNotice

[cois-00143]

Hi Experts,

I have created a UDO and linked UDT's to it. The example below shows and extract of the lines table:

I have created the following script in PostTransactionNotice to update an external table with changes to the status. Running the query on it's own works perfectly, but it does not trigger in PostTransactionNotice.
Do I need to change something for the PostTransactionNotice to read the Objecttype?
IF @object_TYPE = 'MRMSCC' and @transaction_type = 'U'
BEGIN
Update [MRM_CC].[dbo].[ServiceCallInformation]
set ItemStatus = UF.U_ScStatus
From
(select Code,LineID,U_ScStatus from [SAP_CCR].[dbo].[@_MRMCSCLN]
where U_ScStatus = 'Closed') UF
where Id = UF.LineId
and UF.Code = @List_of_cols_val_tab_del
END

[jimmy_michel]

Hi,

I'd like to share an example of a query for postransactionnotice I have ever made on April 18, 2012 ago.

/* customized date setting in UDF day name, dd-mmm-yyyy */
-- result example : Wednesday, 18-May-2012
If @object_type = '67' and @transaction_type in ('A','U')

Begin

declare @day as varchar(30)
declare @date1 as varchar(30)
declare @Hari59 as nvarchar(30)
set @day = (SELECT distinct
case
when DATENAME(dw, (T0.[DocDate])) = 'Monday' then cast('Monday' as nvarchar(20))
when DATENAME(dw, (T0.[DocDate])) = 'Tuesday' then cast('Tuesday' as nvarchar(20))
when DATENAME(dw, (T0.[DocDate])) = 'Wednesday' then cast('Wednesday' as nvarchar(20))
when DATENAME(dw, (T0.[DocDate])) = 'Thursday' then cast('Thursday' as nvarchar(20))
when DATENAME(dw, (T0.[DocDate])) = 'Friday' then cast('Friday' as nvarchar(20))
when DATENAME(dw, (T0.[DocDate])) = 'Saturday' then cast('Saturday' as nvarchar(20))
when DATENAME(dw, (T0.[DocDate])) = 'Sunday' then cast('Sunday' as nvarchar(20))
end from OWTR t0 where t0.Docentry = @List_of_cols_val_tab_del)
set @date1 = (select distinct
cast(day(a.[DocDate]) as nvarchar(20))+'-'+case
when month(a.docdate) = '1' then cast('Jan' as nvarchar(20))
when month(a.docdate) = '2' then cast('Feb' as nvarchar(20))
when month(a.docdate) = '3' then cast('Mar' as nvarchar(20))
when month(a.docdate) = '4' then cast('Apr' as nvarchar(20))
when month(a.docdate) = '5' then cast('May' as nvarchar(20))
when month(a.docdate) = '6' then cast('Jun' as nvarchar(20))
when month(a.docdate) = '7' then cast('Jul' as nvarchar(20))
when month(a.docdate) = '8' then cast('Aug' as nvarchar(20))
when month(a.docdate) = '9' then cast('Sep' as nvarchar(20))
when month(a.docdate) = '10' then cast('Oct' as nvarchar(20))
when month(a.docdate) = '11' then cast('Nov' as nvarchar(20))
when month(a.docdate) = '12' then cast('Dec' as nvarchar(20))
end+'-'+ cast(year(a.[DocDate]) as nvarchar(20))
FROM Owtr a WHERE a.docentry = @List_of_cols_val_tab_del)

update OWTR
set U_SI_HARI_TGL_KIRIM = (@day+','+' '+@date1)
where @object_type = '67'
and DocEntry = @List_of_cols_val_tab_del

end

so, the postransactionnotice works when I add or update the transfer document. So, you must make sure that you use a valid document to update the custom tables.

if not, it won't works.

Rgds,

Jimmy