Home > Default > Approver & approval date from Requisition & PO Approval workflow tables

Approver & approval date from Requisition & PO Approval workflow tables

November 30Hits:0
Advertisement
Dear All,
My req is to create a report that calculates the lead time taken by a Purchase Requisition to be converted into a PO and released. In the output they want the APPROVER NAME, DATE APPROVED against the REQUISITION NUMBER (EBAN-BANFN) and also they want APPROVER NAME, DATE APPROVED against the Purchase Order (so all in all 2 fields of approvers & 2 fields of approval dates). But the thing is they want these APPROVER NAME, DATE APPROVED from the Requisition Approval Workflow tables.
Please update the table & fields that will have the Approver and date approved from workflow corresponding to the Purchase Requisition Number and Purchase Order. or What is the link between the "Approver, approval date & Purchase Requisition Number" and "Approver, approval date & Purchase Order".
Thanks in advance. The solution will be rewarded the points.
Warm Regards,
Farooq.

Answers

We have HR/Payroll and Purchasing working fine for 6 years with the following schedule settings. 0.1 seems too frequent:
A. Schedule one concurrent request to process deferred activities:
1. Item Type :
2. Min Threshold :
3. Max Threshold :
4. Process Deferred : Yes
5. Process Timeout : No
6. Process Stuck : No
(Once every five minutes)
B. Schedule one concurrent request to process timeout activities:
1. Item Type :
2. Min Threshold :
3. Max Threshold :
4. Process Deferred : No
5. Process Timeout : Yes
6. Process Stuck : No
(Once every six hours)
C. Run for stuck activities periodically
1. Item Type :
2. Min Threshold :
3. Max Threshold :
4. Process Deferred : No
5. Process Timeout : No
6. Process Stuck : Yes
(Once every day)
D. Run forall three activities periodically
1. Item Type :
2. Min Threshold :
3. Max Threshold :
4. Process Deferred : Yes
5. Process Timeout : Yes
6. Process Stuck : Yes
(Once every day)
By the way, we also have Synchronize WF Local Tables run once every 24 hours
Hope this helps.
Edited by: DBA115102 on Feb 1, 2011 10:41 AM

Read other 6 answers

Tags:

Related Articles

  • Approver & approval date from Requisition & PO Approval workflow tablesNovember 30

    Dear All, My req is to create a report that calculates the lead time taken by a Purchase Requisition to be converted into a PO and released. In the output they want the APPROVER NAME, DATE APPROVED against the REQUISITION NUMBER (EBAN-BANFN) and also

  • Difference between Due Date for All Tasks and Duration per task in an approval workflowOctober 11

    Hello, I'm starting to read up and learn about approval workflows in Designer 2010.  I am confused by the fields "Due Date for all Tasks" and the "Duration per task".  I understand that the Due date for all Tasks is the date that all o

  • Approval workflow of purchase requisitions after EhP4November 30

    Hi all, After implementing a new support package installation (Ehp4), there are some purchase requisitions that get their approval workflow started again even after purchase order has been created. Is there someone that could give me some help on thi

  • Column based on Approval Workflow completion dateNovember 30

    Would anyone know of a way to create a column that will display the completion date of an approval workflow than ran on a specific file in another library? Thank YouIt could be a simple single line of column The workflow on other file must update thi

  • Add Approved Date to 2010 Approval workflowNovember 30

    Hello I have copied the globally reusable workflow Approval - SharePoint 2010 and will apply it to a document library. However, this approval workflow does not have an approval date column (only in the history list). We really need to have a date in

  • Last approver of purchase requisition linked to workflowNovember 30

    Hi Guys, Im writting a report to display retrospectively the usernames of the last approvers of a company's purchase requisitions for auditing purposes. After searching the forum I found a way to do this: 1) use SAP_WAPI_WORKITEMS_TO_OBJECT to retrie

  • Setting up Sharepoint 2013 approval workflows depending on field valueOctober 11

    Dear Microsoft Support, I am still relatively new to Sharepoint-Infopath and would need help with setting up workflows for a requisition form I am creating. I have designed and created a form using Infopath 2013 and have successfully created the link

  • Building approval workflow that spans two systemNovember 30

    Hi, We are on oracle apps 11i. There is a requirement to build a workflow that spans oracle purchasing and another procurement system for PR. After purchase requisition is handled in the system it should be forwarded to the other procurement system.

  • Approve Workflow from OAFNovember 30

    All, Can we approve / reject/ reassign the workflow notifications from OAF custom page. Before approving the notifications users wants to key in some data and save it in staging tables and then approve notification. I am planning to create a custom p

  • Approval workflow in SharePoint foundation 2010October 11

    Hello Experts, I'm using SharePoint foundation 2010. Can someone help me understand the procedure for creating the approval workflow for a doc library using the SharePoint designer 2010. It would be great if you can guide me the step by step procedur

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.817 s.