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
More About This Author
Array
Dyn365GP2023.03.20Continia Certified: Continia Document Capture Professional User
Dyn365GP2023.03.20New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Removed Functionality
Dyn365GP2023.03.19ClassicPress Plugins Available From azurecurve | Development in 2023: BBCode
Dyn365GP2023.03.18ClassicPress Plugins Available From azurecurve | Development in 2023: Avatars