Regrading draft and document in Purchase order

[Former Member]

Hi Experts,

   After the document draft is created and approval. The draft is approved  i need to remain in the purchase order list but not showing .

How to make this . For eg : PO 419 is created as draft not able to see in the purchase order list. if i need i am able to see through document draft report. But customer wants to show in the same purchase order list. How can i do this.

Please suggest me

[Former Member]

You can create query from Draft Table (ODRF) and Link to OWDD to get the status for approval.

[Former Member]

Hi

It is not possible. After you approve the document it is not Draft any more and you cant see it in the

purchase order list .

you can create query for the client to replace the document draft report

shachar

[Former Member]

thanks for replying

What query i have to write

[Former Member]

HI

The basic query is:

SELECT * FROM ODRF T0 WHERE T0.[ObjType] =22

You can select the fields you want to display

shachar