I used this procedure to reset all of the IM to be from scratch using the existing item numbers. If you follow this procedure, but then export IM1, remove the invalid entries and then reinitialize IM1 and import IM1 it should give you all of the items you need but not the stuff you don't. Be awar though, if you need any historical cost data you should not do this. Or atleast copy the data to another company for lookup. When you are done, you can then do a physical count to get the quantities correct.
To start from scratch in Inventory, the best option is to create a new company. Print out the IM setup options from the original company. Then I would SVDATA t the GL to the new company and then activate inventory for the new company and create the files. Enter the IM Options, but just close the rest of the setup screens because you can copy those masterfiles. While in that new company, at file/run type in SVTRNA and it will ask you which company you want to copy from. This would be your original company. Select inventory management as the application and click on proceed and you will get a screen that will have options of what to copy. You can copy the items, product lines, warehouse files etc. Just no data. That means that they are truly starting over without having to re-enter all the masterfile info. Once you have the new company files copied, you can then do SVDATA and copy those files from the new company back to the original company and it will relace the data in the orginal company. Then I would rebuild sorts for Inventory,Sales Order, Purchase Order or any module that is linked to Inventory Management
Thnks in advance to all users out there who continually answer all of our questions. Although I try to answer some questions, I usually am asking.