Invalid object name 'WO010032'

Fixing [SQL Server]Invalid object name 'WO010032'. after removing the Dynamics GP Manufacturing Module

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:, 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.