Skip to Content
0
Jan 13, 2012 at 10:00 AM

SAP B1

41 Views

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'