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.

/*
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. ‎…

Blog Syndicated with Ian Grieve’s Permission