Microsoft Dynamics GP Workflow Approval SQL Views: Purchase Requisitions

This post is part of the Microsoft Dynamics GP Workflow Approval SQL Views series and contains a SQL view to return the workflow approval status of purchase requisitions.

-- drop view if it exists

IF OBJECT_ID(N'uv_AZRCRV_POReqApprovalStatus', N'V') IS NOT NULL

    DROP VIEW uv_AZRCRV_POReqApprovalStatus

GO

-- create view

CREATE VIEW uv_AZRCRV_POReqApprovalStatus AS

/*
Created by Ian Grieve of...

Continue Reading azurecurve’s Article on their blog

Microsoft Dynamics GP Workflow Approval SQL Views: Purchase Requisitions

This post is part of the Microsoft Dynamics GP Workflow Approval SQL Views series and contains a SQL view to return the workflow approval status of purchase requisitions. — drop view if it exists‎…

Blog Syndicated with azurecurve’s Permission