Invalid object name 'WO010032'

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.