SQL Scripts for Microsoft Dynamics GP: Get Items Showing Quantities By Type

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 items at each location and the different quantities on each quantity type (such as on hold, allocation and on different types of open transactions).

/*
Created by Ian...

Continue Reading azurecurve’s Article on their blog

SQL Scripts for Microsoft Dynamics GP: Get Items Showing Quantities By Type

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 azurecurve’s Permission