Delete 800 inventory items - quick and dirty

[barbola]

Is there a quick and dirty way of deleting over 800 inventory items that were set up but were never used?

thanks.

 

[macleod1021]

If they were NEVER used before, then you could delete them from the IV00101 - IV00116 tables. They won't be in all of the tables, but those are the ones you need to check in. However, keep in mind that if you delete them directly from the table, there may be add-ins or other processes that may be affected. I don't recommend you do it this way. If you decide to move forward with a delete like this, make sure you back up your entire database before doing it in case something gets hosed. Also, run check links after the delete to check for errors.

 

[barbola]

Yes for sure I will backup. I tested it in the test company, and all seems to work fine.

thanks.

 

[jazgeek]

don't forget to remove them from the iv00102 table or a check links will just bring them back again.

run a reconcile after you're finished removing them

a safer way would be to update the items to be discontinued and then run the year end routine to remove discontinued items.



-----------
and they wonder why they call it Great Pains!

jaz

 

[barbola]

You mean discontinued items get removed when year-end routine is run? I think our year-end runner has been missing this step in all our companies. grrrr

Yes, I found I need to do IV00101 thru IV00108. The other tables (and some in between) have no records.

They are not discontinued items, they were set up with bad item numbers and were never used. Here is an example of one of the item numbers they tried to set up:

PWAS-3/8" x 1/4" LENGTH WITH ADD'L ROD

nice, eh?

 

[macleod1021]

Ouch. I see why you want to get rid of that.

As far as the tables, each implementation will use a different subset of those tables based on their company settings. I listed them all just to make sure none was listed because as Jaz said, if you miss the critical ones, a check links will readd them .

 

[jazgeek]

on year end, you have to actually check box the remove discontinued items box. and they'll only remove if there are no quantities on hand and are not on any open transaction. You should be safe as there's no transaction against the parts, otherwise you may have to remove history on them as well.


-----------
and they wonder why they call it Great Pains!

jaz

 

[barbola]

I will have to make note of this for next year-end...and make sure our discontinued items are actually marked discontinued.

My deleting and integration worked beautifully by the way.

thanks