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