ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> DELETING ITEMS
http://www.istechforum.com/YaBB.pl?num=1134578274

Message started by dstary on 12/14/05 at 08:37:54

Title: DELETING ITEMS
Post by dstary on 12/14/05 at 08:37:54

We have several erroneous item number that may have been used once or twice, however, we would like to delete these totally from our system to declutter our database. Please adivise how to do this.

Title: Re: DELETING ITEMS
Post by elizabeth on 01/17/06 at 08:52:42

Did you ever get an answer to this question. We have the same issue and cannot find a way to delete these items. Most of them have been added in error, but since we ran a physical inventory they now have a transaction attached to them. ???

Thanks,
Elizabeth

Title: Re: DELETING ITEMS
Post by Lenette on 01/17/06 at 09:18:43

i found when i ran PR-H i was able to get rid of them, providing they were not on SO, PO, etc.

Title: Re: DELETING ITEMS
Post by dstary on 04/10/06 at 08:19:58

I have not gotten a satisfactory answer to this question.

Title: Re: DELETING ITEMS
Post by wildco on 04/10/06 at 09:37:50

If the items are on SO, there is no way to delete them (unless the SO history with the item on it is purged). Often, if an item has been on a WO or has transaction history it cannot be deleted, again until the relevant history is purged.

Title: Re: DELETING ITEMS
Post by Lynn Pantic on 04/10/06 at 13:51:52

Actually, SO History (Posted Invoices) do not need to be purged, only Closed So from the Open SO file.

Title: Re: DELETING ITEMS
Post by JNAPIER on 04/10/06 at 13:54:57

You must also delete it's BOM as well as any UOH showing in the serial file. These are separate from the actual UOH in inventory.

John

Title: Re: DELETING ITEMS
Post by michaelb on 05/31/06 at 16:08:03

I couldn't find a way to delete an item, so instead I went to:

System Manager, System Maintenance, File Maintenance Programs, Change Item Numbers
(SM-J-L)
and changed the offending items to a new part number of:

XXDONTUSEXX
XXDONTUSE1XX
XXDONTUSE2XX

And so on.

Title: Re: DELETING ITEMS
Post by cmsk on 03/16/07 at 03:14:24

I find it hard to believe there's no answer to this and I need to bump this post to hopefully get one. We have a couple of items that need to be removed. Specifically, duplicate of the same item numbers are showing up. I'm not sure how they were created, but regardless, I need to get rid of them. There must be something wrong with the record, as we can't view the item in IN-A or IN-B. It'll show up on the lookup, but if you select the item, it says that BKICMSTR is locked by another user. Only the original item is able to be viewed. So anyway, short answer on how to remove these records / items please??

Title: Re: DELETING ITEMS
Post by Lynn_Pantic on 03/16/07 at 05:57:41

Maintain Database on BKICMSTR, MTICMSTR and BKICLOC if you are sure there is no history or other related information. In your case, it sounds like the item may not exist in all 3 files but is an orphan record in only one of them.

Title: Re: DELETING ITEMS
Post by cmsk on 03/16/07 at 06:08:27

Lynn_Pantic wrote:

Yes, it/they appears orphaned in BKICMSTR. I can see them, but I still get the locked error message when trying to access them in Maintained Database. I assume the minus (-) button at the bottom is the delete, but that also shows up grayed out.

Title: Re: DELETING ITEMS
Post by GasGiant on 03/16/07 at 06:15:00

Those nasty little orphans!

"Oliver! Oliver! Never before has a boy wanted more!"

"Boy! Boy for sale!"

Just think, if DBA had been built on a relational database you wouldn't have been treated to this medley of old show tunes ;)

Title: Re: DELETING ITEMS
Post by kevind on 03/16/07 at 06:18:55

Your problem is different than what the subject of this thread was.

I had this same problem. I was caused by a bug in an update quite some time ago. It was creating rogue duplicate records in BKICMSTR and MTICMSTR. Since these were just duplicate records in these two tables, and not legitimate items with related records in other files, you use Maintain Database to remove them.

Choose the appropriate BKICMSTR table from the list, put the item number in the search box, click search. You should find more than 1 record with the same Item number. Check each row, and verify which one is valid. Click in any field of the invalid record, then click the '-' button at the bottom of the screen. This will delete this record from this table. Do the Same in the MTICMSTR table.

** WARNING: The '-' record delete button is not reversable!! Make sure you are on the correct record (row).

Title: Re: DELETING ITEMS
Post by cmsk on 03/16/07 at 06:31:26

kevind wrote:

Thanks for that Kevin, although this topic still seems unanswered... In any event, I tryied what you suggested and as I said above, I only have the duplicates in the BKICMSTR file and the (-) is grey out. All users are out of the system, but if I check off "Allow Editing" it still says the item is locked by another user.

Title: Re: DELETING ITEMS
Post by GasGiant on 03/16/07 at 06:37:55

Sounds like you need to delete some user file handles in the Pervasive Monitor maybe?

Title: Re: DELETING ITEMS
Post by cmsk on 03/16/07 at 12:17:20

GasGiant wrote:

Sounds like you need to delete some user file handles in the Pervasive Monitor maybe?

I'll check into it, but I'm not overly savvy with pervasive' utilities. I assume users will be listed under the monitor?

Title: Re: DELETING ITEMS
Post by cmsk on 03/17/07 at 08:36:07

cmsk wrote:

[quote author=GasGiant link=1134578274/0#14 date=1174055875]Sounds like you need to delete some user file handles in the Pervasive Monitor maybe?

I'll check into it, but I'm not overly savvy with pervasive' utilities. I assume users will be listed under the monitor?[/quote]

You nailed it GasGiant, thanks!!!