Reg:Validation on Purchase Request-Draft[ Approved]
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')
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',
Please let me know the solution