Invalid object name 'WO010032'
Fixing [SQL Server]Invalid object name 'WO010032'. after removing the Dynamics GP Manufacturing Module
![Invalid object name 'WO010032'](/content/images/size/w2000/2023/09/HeroMissingTrigger.jpg)
Invalid object after removing manufacturing module from GP
Having uninstalled the manufacturing module of Dynamics GP, following the instructions on this page, as shown below: https://learn.microsoft.com/en-us/troubleshoot/dynamics/gp/how-to-uninstall-manufacturing-if-it-is-installed-accidentally, a problem occurred.
Error adjusting stock, object not found
When attempting to perform a stock adjustment, it caused the error below:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'WO010032'
The first thing that sprung to mind was that there must be a trigger trying to reference the table WO010032, a table that had been dropped from the database as part of the clean up. This later turned out to be true.
Performing a search with Redgate SQL search for WO010032 turned up a trigger referencing this object.
The trigger can be seen on the table IV30300 in gp.
The trigger is not referenced by the script in the article above, so I don't know if the removal scripts are out of date or this is an extra trigger created by a another product on this particular instance database.
Solving the issue
The resolution was to disable that trigger, then dropped it.
DROP TRIGGER [mfg_update_IV30300]
I hope this helps someone else out.
![](https://timwappat.info/content/images/2023/09/How-to-uninstall-manufacturing-11-1.jpg)
![](https://timwappat.info/content/images/2023/09/How-to-uninstall-manufacturing-12-1.jpg)
![](https://timwappat.info/content/images/2023/09/How-to-uninstall-manufacturing-13-1.jpg)
![](https://timwappat.info/content/images/2023/09/How-to-uninstall-manufacturing-14-1.jpg)