SP Transaction Notification
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 replied
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