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 was created for a client to use in SmartList Builder, and other, reports; it returns the quantity available for items on a location basis.
/*
Created by Ian Grieve of azurecurve |...
Continue Reading Ian Grieve’s Article on their blog
SQL Scripts for Microsoft Dynamics GP: SQL View to Return Quantity Available
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 was created for a client to use in SmartList Builder, and other, reports; it returns the quantity available for items on a location basis.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
Dyn365GP2023.06.05SQL Scripts for Microsoft Dynamics GP: SQL View to Return List of Posted Vendor Document Numbers- Dyn365GP2023.06.05In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Dimension Sets
Dyn365GP2023.06.04ClassicPress Plugins Available From azurecurve | Development in 2023: Maintenance Mode
Dyn365GP2023.06.03ClassicPress Plugins Available From azurecurve | Development in 2023: Loop Injection
