ISTech Support Forum - How to delete Items no longer used?

Welcome, Guest. Please Login.

	05/16/24 at 21:56:55 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Items

‹ Previous topic | Next topic ›

Pages: 1

How to delete Items no longer used? (Read 1769 times)

heinzc Browser Hello Posts: 7 Gender:	How to delete Items no longer used? 05/29/03 at 08:48:03 We have a lot of items that we no longer use. How do we delete those? What is the safest and fastest way (like I said: we have a lot of them!!)?
Back to top	Heinz Camenzind IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: How to delete Items no longer used? Reply #1 - 05/29/03 at 08:56:12 Go to IN-B, enter the Item Number and press <Enter>, so that you have the Item info on the screen. Then press <F4>. Note that if the Item is on a SO, WO, PO, on hand, etc., you can't delete it.
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

heinzc Browser Hello Posts: 7 Gender:	Re: How to delete Items no longer used? Reply #2 - 05/29/03 at 09:02:28 Can items with history (SO, PO, WO, etc.) also not be deleted through Maintain Database?
Back to top	Heinz Camenzind IP Logged

Lynn_Pantic

Administrator

evolution (n) -
gradual change to a
different form

Posts: 5681

Re: How to delete Items no longer used?
Reply #3 - 05/29/03 at 09:12:05

They can but you need to be careful because it may cause problems later on some reports. At least make sure they are not in BOM and Routing files. Purge Closed Sales Orders (Not Invoices but the "skeletons" of the closed orders from the Open Sales Order file) too.

If you do choose to delete them in Maintain Database, you need to be sure you delete them in all 3 master files - BKICMSTR, MTICMSTR and BKICLOC

Lynn Pantic
IS Tech Support
lynn@istechsupport.com

IP Logged

heinzc Browser Hello Posts: 7 Gender:	Re: How to delete Items no longer used? Reply #4 - 05/30/03 at 13:50:21 How about deleting all of the items including all of their lot, serial, WO, PO, SO-history? Can that be done without any problems?
Back to top	Heinz Camenzind IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: How to delete Items no longer used? Reply #5 - 05/30/03 at 15:50:58 Heinz, WHY in the world would you want to get rid of items with all that history? Kinda like burning down a library building isn't it?
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

heinzc

Browser

Hello

Posts: 7
Gender: male

Re: How to delete Items no longer used?
Reply #6 - 06/02/03 at 10:36:53

We are not burning down the library. We are keeping all the information in one company.
But we started a new company, and after we set this up in DBA, we decided to start from scratch with our entire inventor and mfg control (new part # system and so on).
We already have to many accounting entries to delete the new company and start over. We just want to delete all items and their records.

I hope that makes more sense now.

Heinz Camenzind

IP Logged

Lynn_Pantic

Administrator

evolution (n) -
gradual change to a
different form

Posts: 5681

Re: How to delete Items no longer used?
Reply #7 - 06/02/03 at 11:40:30

Deleting ALL is much easier than selectively deleting some. UT-K-A Clear Data will allow you to clear out all the inventory data. Just make sure you have a backup first. Or maybe make yet a third company that is a copy of the new company and play around with the Clear Data program to be sure it does what you want it to.

Lynn Pantic
IS Tech Support
lynn@istechsupport.com

IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: How to delete Items no longer used? Reply #8 - 06/02/03 at 12:09:33 I agree with Lynn. Selectively deleting by it's very defintion would be based upon a set of criteria (or if>then statements). THAT is best done at the SQL level. But if you just want to wholesale delete then UT-K-A is the way to go.
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Items

‹ Previous topic | Next topic ›