How to get approver with SO in PLD

[Former Member]

Hi expert

I have an approvel procedure on sales order.

I would like to get approver in PLD, but how to get them?

I know the data save in OWDD/WDD1 table, and I can use

Alt key to pull the all table, but I don't know how to join them well. Have any body meet the sam problem? Any body have the solution?

Glen

[Former Member · Accepted solution]

Hi,

Please follow the below mentioned steps:

1. make a UDF on the title level of the marketing document

2. make a query like this:

SELECT T3.U_NAME FROM OWDD T0, ORDR T1, WDD1 T2 INNER JOIN

OUSR T3 ON T2.UserID = T3.INTERNAL_K

WHERE T1.DocEntry= T0.DocEntry and T2.WddCode=T0.WddCode

and T1.DocNum=$[$8.1.0]

3.link the query to the UDF;

4.add a data field in the print template to make the UDF visible.

+But,please note that for multi approver scenario,the system does have

the limitation here that when in these cases, you can display only one

approver or you have to create several UDF to display the whole

information.

Regards,

Abhinav Banerjee

SAP Business One Forums Team

Edited by: Abhinav Banerjee on Nov 22, 2008 2:49 AM

[Former Member]

Hi Glen,

It will be difficult or even not possible to get it for the PLD. The problem is: link between two tables are only one side. You can not find any fields in SO to link to the approval.

Probably by user query is you alternative.

Thanks,

Gordon