Validate Project Code in Receipt From Production
IF @transaction_type IN (N'A', N'U') AND (@Object_type = N'59')
BEGIN
Declare @entry int
declare @receveqty float
declare @receveqty1 float
set @entry= (select distinct BaseEntry from IGN1 where DocEntry=@list_of_cols_val_tab_del and BaseType=202)
if Exists
(SELECT T0.Project from IGN1 T0
where
T0.DocEntry = @entry)
BEGIN
SELECT @Error = 5, @error_message = 'Project Code is missing !'
END
END
