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.