Hi Experts,
Please guide me..
I have fixed a SP Notifications in Purchase Quotation for Project Mandatory and also i have set a approval on Purchase Quotation but SP Notification is not Working.
SP Notification Query is..
If @object_type in ('540000006') and @transaction_type in ('A','U')
BEGIN
If Exists (Select * from dbo.DRF1 T0
Where T0.DocEntry = @list_of_cols_val_tab_del and (T0.Project='' or T0.Project IS NULL)) --And T0.Handwrtten='N' )
BEGIN
Select @error = -1,
@error_message = 'Project Code is mandatory. Please update Project before adding the document.'
End
End
Thanks'