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!