Microsoft Dynamics GP Workflow Approval SQL Views: Purchase Orders

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 orders.

-- drop view if it exists

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

    DROP VIEW uv_AZRCRV_POPOrderApprovalStatus

GO

-- create view

CREATE VIEW uv_AZRCRV_POPOrderApprovalStatus AS

/*
Created by Ian Grieve of...

Continue Reading azurecurve’s Article on their blog

Microsoft Dynamics GP Workflow Approval SQL Views: Purchase Orders

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 orders. — drop view if it exists IF O‎…

Blog Syndicated with azurecurve’s Permission