start a new inventory file in mas90 (ProvideX DB)

[changneil88]

Hello,

My inventory has so many invalid items, I need to start a clean inventory master file, how can I accomplish this in Mas90? Thanks
CH

 

[Blorf]

The easiest way is using Libray Master, Repair, and reinitialize tables.

You will need to blow away Im1, Im2, Im04, mayby a couple of others.

If you have open purchase orders, or history though, you will get a lot of "Not On File" things on reports.

ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[Omnicef]

When you say invalid items, do you mean that the item number itself is invalid or that the data associated with the item number is invalid? I have gone through a procedure with best before to erase all history for the items but the items were still there preventing a lot of reentry. The wanted to get there costing back on track. That was the only thing invalid for them. I have worked in IM data tables quite a bit and would love to hear ore details.

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.

 

[changneil88]

Invalid items are items without description or price.

 

[Omnicef]

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.

 

[changneil88]

Thanks.