Purchase Request Approval

Purchase Request Approval





SELECT pr.Requestid "Requestid",
       pr.Subject "Subject",
       pr.Description "Description",
       longtodate(pr.Requesteddate) "Requesteddate",
       longtodate(pr.Daterequired) "Daterequired",
       longtodate(pr.createddate) "createddate",
       pr.Shipping_details "Shipping_details",
       cri.FIRST_NAME "Created By",
       aau.FIRST_NAME "Requester",
       ti.FIRST_NAME "Technician",
       pd.PRIORITYNAME "Priority",
       std.statusname "Status",
       (aaa.FIRST_NAME) "Approver",
       (pos1.STATUSNAME) "PO Approval Status",
       LONGTODATE(poa1.APPROVAL_DATE) "Approval Date" FROM purchaserequest pr
LEFT JOIN SDUser sdu ON pr.Requestedby=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN SDUser crd ON pr.Createdby=crd.USERID
LEFT JOIN AaaUser cri ON crd.USERID=cri.USER_ID
LEFT JOIN SDUser td ON pr.Technicianid=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN PriorityDefinition pd ON pr.PRIORITYID=pd.PRIORITYID
LEFT JOIN POStatus std ON pr.statusid=std.statusid
LEFT JOIN PRLevelInfo pol ON pr.requestid=pol.requestid
LEFT JOIN PurchaseApprovalDetails poa1 ON pol.LEVELINFOID=poa1.LEVELINFOID
LEFT JOIN AaaUser aaa ON poa1.APPROVERID=aaa.USER_ID
LEFT JOIN levelinfo li ON pol.LEVELINFOID=li.LEVELINFOID
LEFT JOIN POApprovalStatus pos1 ON li.LEVELSTATUSID=pos1.STATUSID
ORDER BY 1
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • Related Articles

                      • Purchase order approval details

                        SELECT po.POCUSTOMID AS "PO Number", max(po.PONAME) AS "PO Name", max(poa.FIRST_NAME) AS "Purchase Requester", longtodate(max(po.DATEORDERED)) AS "Ordered Date", longtodate(max(po.DATEREQUIRED)) AS "Required Date", max(pos.STATUSNAME) AS "PO Status", ...

                      • Request Approval Details

                        This report is used to view the historical details of Approved and Denied approval processes and their individual steps. We can also use this report to display all details for which an approval decision is pending. To make any changes to a query, ...

                      • Purchase Request details

                        Select pr.REQUESTID AS "Request Id", pr.SUBJECT AS "PR Subject", pr.DESCRIPTION AS "Description", LONGTODATE(pr.REQUESTEDDATE) AS "Requested Date", LONGTODATE(pr.DATEREQUIRED) AS "Date Required", LONGTODATE(pr.CREATEDDATE) AS "Created Date", ...

                      • Automatically close request after successive approval reminders.

                        This post describes the use of a python script to close requests after successive approval reminders using Custom Schedules. Use Case: We have an option under the self-service portal in order to send reminders mail for the approvals, what would be ...

                      • How to implement dynamic request approval through custom triggers with configurable CSV file.

                        This is a sample script written in Python to handle Conditional Approvals for Incident \ Service Requests, through Custom Triggers.More information about Conditional Approvals can be  found in the link here One of the advantages of using this script ...

                        Related Products