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
Dyn365GP26 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore an Environment to a Point in Time
Dyn365GP25 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Environment
Dyn365GP24 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
Dyn365GP23 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company
