SP Transaction Notification

[Former Member]

Hi all.

I need some help creating a Stored Procedure. My client would like to make it impossible to choose a certain payment term when adding vendors. Can someone please help me with the syntax of such a SP?

Thanks and regards, Runar.

[Former Member · Accepted solution]

should be just a simple IF clause in the "Add Code Here" Part

IF(@object_type='2' AND (@transaction_type='A'))

BEGIN

--do validation here so you need another If clause that set's error to a non 0 value when error condition is met

END

hope it helps,

Matt