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
- Dyn365GP8 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Report Explorer has Additional Outputs in the Czech Version
- Dyn365GP7 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Improvement of Czech Localization Reports
- Dyn365GP7 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Process Czech Bank Statements, Payment Orders More Productively
- Dyn365GP6 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Use a New Role Center for Collection Management