get the final approved date for creating SO
I have using the approved module in sbo. I want to create query to run a report regarding the so approved situation.
In addtion ,I could created some approved templete including 2or 3 stage.
I write the statment as follow:
select T1.updatedate,T1.wddcode,T0.*,T1.*,T1.updatedate,T3.docnum,T3.numatcard,itemcode,quantity,canceled from owdd T0 join wdd1 T1 on T0.wddcode = T1.wddcode join rdr1 T2 on T0.docentry = T2.docentry join ordr T3 on T2.docentry = T3.docentry where isdraft='N' and T3.[CANCELED] = 'N'
Please give me some hint.