Approved by Name in Template

[Former Member]

Hello,

I'm working on SAP B1 2007B PL:04.

Now I want to print the name of the person who is approving an A/P Invoice.

How will I make the A/P template?

Rgds

Subrata

Edited by: Paul Finneran on Sep 9, 2008 10:21 AM

[vijay_kumar1 · Accepted solution]

Dear Subrata,

In order to display the authorizer name in the print out, please do the following

1. Create a udf in header level of marketing document

2. Define a formatted search for the above udf using this query

SELECT T3.U_NAME FROM OWDD T0, OINV 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=$ OPCH.DocNum

3. Add a data field in the A/P Invoice template and select the above udf which

will display the name of the authorizer.

Regards,

Vijay kumar