This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.
This script returns a list of work status assemblies and the quantity required for the assembly.
CREATE VIEW uv_AZRCRV_AssembleQuantityRequired AS
/*
Created by Ian Grieve of azurecurve | Ramblings...
Continue Reading Ian Grieve’s Article on their blog
SQL Scripts for Microsoft Dynamics GP: Assembly Transaction Quantities Required
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP. This script returns a list of work status assemblies and the quantity required for the assembly.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
Dyn365GP26 July 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Enable Sustainability Features for Integrations with APIs
Dyn365GP26 July 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Manage Subscription Billing and Revenue and Expense Recognition
Dyn365GP25 July 2024New Functionality In Microsoft Power Automate 2024 Wave 1: Scale Faster with Power Automate Process Mining Thin Client App
Dyn365GP25 July 2024New Functionality In Microsoft Power Automate 2024 Wave 1: Use the New Desktop Flow Running Timeout Property