Skip to Content
0
Former Member
Feb 17, 2009 at 10:00 PM

transaction notification syntax

24 Views

Hi all,

I am using the following code:

if @object_type = '142' and (@transaction_type= 'A')

begin

if '_SYS00000000106' = (SELECT T1.[DebPayAcct] FROM OPOR T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T0.[DocNum] = @list_of_key_cols_tab_del )

begin

select @error = -10

select @error_message = 'Invalid Vendor.'

end

end

I want to block purchase orders from being created when the vendor is using a certain system account code, _SYS00000000106 or formatcode 201000000000.

I am new to the transaction notification code and I would appreciate some pointers to make this work.

Thanks!