A Microsoft Dynamics GP 2010 end user wants to create a new Item Class and run an update script in SQL to change the class ID for a bunch of items to this new class ID.
That's doable. But, the difficult part is making sure that the changes within the new class are rolled down to the items within that class.
Has anyone out there created any sort of SQL script that will automatically roll down changes from an item class to its items?
Is there a third-party solution that would conduct this?