Sage 100

trying to delete WH codes - about 40 or so of them. If there is nothing on the Stock Status, but items still show up with 0's (so there is a record/relationship in IM_ItemWarehouse) isn't there some way to still get these cleaned up? I have the Sage article, which basically says go into each inventory item and remove the WH codes. This would take years for this company so I'm hoping there is a better/quicker option. They don't really care about inventory history but it won't even let me purge 2011 (even though we are in 2013).

http://www.dsdinc.com/enhancement/warehousecompany-merge-utility/

If there's a better option I've not found it. Had a customer want to remove about half a dozen and it was all DFDM as described in the Sage KB.

I have done this by exporting all IM_ItemWarehouse records, re-initializing the file and then importing only the desired records back using a bunch of skips in the vi job. Last time was on 4.3 though, not sure if there are any new restrictions on the data files.

thanks everyone, will probably give Bernie's solution a shot

Let me know how this goes Eric. I have a client in a similar situation. I will probably need to deal with this at year end as well.

Has anyone used the DSD utility with successful resolution of this type of situation? I didn't know it existed...sounds useful.

I'll keep you posted - I should be testing this tonight or tomorrow night

You might be able to write a script to remove record based on some criteria

Update - had to use the providex.dde trick where you open up the fields for VI imports - typically that IM_Item_Warehouse import only allows reorder point info, so you have to get the rest of the fields to show up (QtyonHand, QtyonPO, etc.). But everything seemed to work ok - reinitialized IM_ItemWarehouse, cleaned up the file from 16K records to 9.5K, ran the import, tested some items and they look ok. We'll know tomorrow morning if I'll need to restore from backup:)