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
More About This Author
Array
- 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
- Dyn365GP22 April 2024Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (May-Jul 2024) from MADIC dynamics