Name of PO Workflow Approver in as dynamics 2012 ?

Finance and Operations/AX Developer Forum
1

Hi All,

did Someone know , how to get the name of approver of PO workflow^in ax dynamics 2012 , i need to use it in SSRS report, i check some table like workflowelementTable , i didn’t found anything !

Plz Help

Many Thanks

Taoufiq

2

Hi,

select firstonly workflowtrackingstatustable
join workflowtrackingtable
where workflowtrackingstatustable .ContextRecId == purchtable.recid
&& workflowtrackingtable.TrackingContext == workflowtrackingcontext::WorkItem
&& workflowtrackingtable.TrackingType == workflowtrackingtype::Approval
&& workflowtrackingtable.WorkflowTrackingStatusTable == workflowtrackingstatustable .recid;
{
approvername = workflowtrackingtable.User;
}

this code might help you to get a PO approver(in the same way you can get the approver name of any order/ journal

by passing the approved record id as context rec id).

3

Thank You Chaitanya.

Taoufiq

4

Hi chatitanya,

When i check the table in "workflowtrackingtable’ w.r.t your code (fetching by purchtable.recid) there are multiple records existing it that table as the status is Approved. and your code is fetching only first record and its difficult to find who is the actual Approver of PO.

Thanks & Regards,

Santhosh