I have a stored Procedure (code below) which helps in blocking the invoice if the unit price is not fulfilled.But there are some Template BOMs (Table OITT) in the system which needs to be exempt from this rule.I am not able to add exception here to this code.
Can someone please help me in getting it done.
IF (@object_type = N'13' AND @transaction_type in (N'A', N'U') )
IF EXISTS (SELECT T1.DocEntry FROM OINV T0 inner join INV1 T1 on T0.DocEntry = T1.DocEntry INNER JOIN
WHERE (T1.PriceBefDi IS NULL OR T1.PriceBefDi = 0 and ) AND T0.DocEntry = @list_of_cols_val_tab_del)
Set @error =1
set @error_message = 'Unit Price cannot be blank'
Thanks & Best Regards