Skip to Content
0
May 24, 2016 at 09:40 AM

Purchase Quotation is mandatory for Every Purchase Order?

22 Views

Hi Friends

Purchase Quotation is mandatory for Every Purchase Order?

I have this query but i need Exception for One vendor "V00004" how to modify this query please help me out

If @object_type='22' and @transaction_type='A'

BEGIN

If Exists (Select T0.DocEntry from [dbo].[OPOR] T0 Inner Join POR1 T1 On T0.DocEntry=T1.DocEntry

Where T0.DocEntry = @list_of_cols_val_tab_del and T1.BaseEntry is null )

BEGIN

Select @error = -1,

@error_message = 'Purchase Order without Purchase Quotation Cannot Be Added '

End

End

Regards

Reddy