Script to Update Purchasing Unit of Measure in Microsoft Dynamics GP
While I am a big advocate of making changes to data via the front end or using an officially supported integration tool, there are times when a SQL script is the quicker way of making a small update.
I recently needed to update the purchasing unit of measure on 60,000 inventory items. The below SQL script was created to make this update:
/*
Created by Ian Grieve of azurecurve|Ramblings of an IT...
Continue Reading azurecurve’s Article on their blog
Script to Update Purchasing Unit of Measure in Microsoft Dynamics GP
While I am a big advocate of making changes to data via the front end or using an officially supported integration tool, there are times when a SQL script is the quicker way of making a small update.
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
Dyn365GP29 September 2023SQL Scripts for Microsoft Dynamics GP: Extract Payables Transactions from All Companies
Dyn365GP29 September 2023In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Put-aways Using a Batch Job- Dyn365GP28 September 2023SQL Scripts for Microsoft Dynamics GP: View for Payables Transactions Extract
- Dyn365GP28 September 2023How To Install Microsoft SQL Server 2022: Available Editions
