Reg:Validation on Purchase Request-Draft[ Approved]

[Former Member]

Hi,

When my client add the Purchase Request,it goes for Approval...Fine.

After get Approved,client wants to put the validation on Remarks[HEADER] field that should not be change after Approved,

when end user try to Add the Purchase Request-Draft[Approved] .

I try to run the following query,

but it is apply both for normal draft document and the draft document which was approved by authorized person.

if @object_type ='1470000113' and @transaction_type in ('A')

BEGIN

if exists(

select t1.DocNum  from OPRQ t1 where t1.DocEntry=@list_of_cols_val_tab_del and t1.Comments <>

(select t1.Comments  from ODRF t1 left join OPRQ t2 on t1.DocEntry =t2.draftKey

where t1.DocNum =(select t1.DocNum from OPRQ t1 where t1.DocEntry =@list_of_cols_val_tab_del) AND t1.WddStatus ='Y'

))

select @error =N'121212',

@error_message =N'TEST'

end

Please let me know the solution

[Former Member]

Hi

draft object type is 112

shachar