While putting together a dashboard to help streamline obsoleting stale inventory, we discovered an issue where we have inventory showing in a warehouse and bin that do not exist in our current system. After doing some digging in Part Transaction History, it appears this quantity was imported during our conversion from Vantage 6 to Vantage 8 way back in 2008. I assume this warehouse was not carried over as part that transition but the import was completed anyways. These parts do not show up in any reports or in part tracker and are not available to adjust out through Quantity Adjustment. They do however show up in the PartWhse table as an On-Hand Qty and this stops us from inactivating the parts.
Does anybody have any suggestions on how we can get this inventory out of the table so we are able to inactivate the parts?
Part - Warehouse relational data integrity appears to be managed from the client rather than with database relationships (don’t get me started…). DMT and REST don’t know or care about many client side restrictions and will happily do a lot of things that the client would block. If you have users active with DMT, that activity is on the suspect cause list as well.
That means you can probably perform transactions on that warehouse-less data from DMT, like moving it to a legit warehouse so it can be interacted with directly. But keep in mind - A software admin has no greater footgun than tinkering around behind software managed data integrity. Proceed with caution.
I’m wondering if the system will allow you to create the offending warehouse then you could do what you need with the stock before making the warehouse (bins at least) inactive.
