Skip to Content
0
Former Member
Sep 24, 2014 at 09:35 AM

how to get Approver name as per order from user_addr table

32 Views


hi,

i have done Smartform and its working fine. but the problem is i getting List of approver ID and date from cdhdr table through PR number.

and i am passing the ID to user_addr Table for getting Approver Name. But it is not Picking name as per Approved order.

i.e Level of approval is 5.

Approval1 ID --- z012215

Approval2 ID --- Z007711

bcoz of Upper limit and Lower limit it Picking ID as

Approval1 --- Z007711

Approval2 --- z012215

how i can solve this issue can any help to solve this issue.

thanks

S.Kavitha