ISTech Support Forum - Deleting Obsolete Inventory

Jenn Browser Living the dream. Posts: 8 Gender:	Deleting Obsolete Inventory 08/30/07 at 08:40:43 I have alot of issues. I'll start with one for now. I am deleting inventory and an error comes up telling me I can not delete-is present on sales order or it's on a work order. When I go to look the item up, there are no open sales orders or work orders. How can I delete the items or get rid of that error?
Back to top	IP Logged

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1210 Gender:	Re: Deleting Obsolete Inventory Reply #1 - 08/30/07 at 09:45:37 They do not have to be open. It looks for any history. I have solved this before by purging old SO's (SM-J-J) and by Archiving Work Orders(SM-J-B). Hope this helps.
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: Deleting Obsolete Inventory Reply #2 - 08/30/07 at 09:58:12 If you do not want to purge or archive (we have never purged old SOs), you could choose to change the status to "D" for deleted, which pops up a message if someone tries to use the item. This works out for us.
Back to top	IP Logged

Jenn Browser Living the dream. Posts: 8 Gender:	Re: Deleting Obsolete Inventory Reply #3 - 08/30/07 at 10:29:37 I understand that changing the status will give you a warning, but without purging all old/archived history there is no way to get rid of the part number totally?
Back to top	IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: Deleting Obsolete Inventory Reply #4 - 08/30/07 at 10:31:01 Correct
Back to top	IP Logged

Jenn Browser Living the dream. Posts: 8 Gender:	Re: Deleting Obsolete Inventory Reply #5 - 08/30/07 at 10:39:54 crap, can I say that on here? Thank you for your help...I will have more questions, just have to find all my notes
Back to top	IP Logged

David Waldmann

Active Member

Live to work, or
work to live?

Posts: 1919
Gender: male

Re: Deleting Obsolete Inventory
Reply #6 - 08/30/07 at 10:46:24

Quote from GasGiant on 08/30/07 at 09:58:12:

you could choose to change the status to "D" for deleted

You're right about what it does, but it's actually for "Discontinued", the logic is that you might still have some on hnad that you want to sell. I think that D status will not allow them on WOs (except when created through SO-N...) or POs, but SOs are ok.

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

Jenn Browser Living the dream. Posts: 8 Gender:	Re: Deleting Obsolete Inventory Reply #7 - 08/30/07 at 10:51:43 I made all the items inactive, and marked them disconinuted. It is on items that have been discontinued for 1+ years and we have 0 on hand. Not real sure if I want to purge all old S/O's or not.
Back to top	IP Logged

Jenn Browser Living the dream. Posts: 8 Gender:	Purging Annual Inventory Reply #8 - 08/30/07 at 11:02:20 ok, next question...I'm having issues purging old inventory counts. I was able to do some of them but there are 3 that will not purge. Thee error is "no locations", that's all if gives me. How can I fix that one?
Back to top	IP Logged

Jenn Browser Living the dream. Posts: 8 Gender:	Re: Deleting Obsolete Inventory Reply #9 - 08/30/07 at 11:08:03 another questions for this one....is there a way if I did delete old S/O's and W/O's to do more than one at a time?
Back to top	IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: Deleting Obsolete Inventory Reply #10 - 08/30/07 at 11:11:18 Quote from Jenn on 08/30/07 at 11:08:03: another questions for this one....is there a way if I did delete old S/O's and W/O's to do more than one at a time? Yes. Purging old SO's is SM-J-J under the System Mgr menu, and archiving old WO's is SM-J-B. Both allow you to do ranges by number or date.
Back to top	IP Logged

GasGiant

Administrator

How can I help?

Posts: 1517
Gender: male

Re: Purging Annual Inventory
Reply #11 - 08/30/07 at 11:16:23

Quote from Jenn on 08/30/07 at 11:02:20:

ok, next question...I'm having issues purging old inventory counts. I was able to do some of them but there are 3 that will not purge. Thee error is "no locations", that's all if gives me. How can I fix that one?

You may have deleted the locations that were in the frozen inventory or something. You may need to purge them by reinitializing some tables or running a SQL statement to empty them. I did this awhile back, but I'd need to look up the table names, etc. Maybe Lynn will jump in on this before I get a chance to look it up.

Back to top

IP Logged

GasGiant

Administrator

How can I help?

Posts: 1517
Gender: male

Re: Deleting Obsolete Inventory
Reply #12 - 08/30/07 at 11:19:30

Quote from David Waldmann on 08/30/07 at 10:46:24:

Quote from GasGiant on 08/30/07 at 09:58:12:

you could choose to change the status to "D" for deleted

You're right about what it does, but it's actually for "Discontinued", the logic is that you might still have some on hnad that you want to sell. I think that D status will not allow them on WOs (except when created through SO-N...) or POs, but SOs are ok.

Sorry, was working from memory. For us it means the item has been deleted from our price list. We don't obsolete anything because we repair our equipment, even if it is 20+ years old.

Back to top

IP Logged

Jenn

Browser

Living the dream.

Posts: 8
Gender: female

Re: Deleting Obsolete Inventory
Reply #13 - 08/30/07 at 11:24:55

I'll try the SO and WO thing and see if that works....would that be the same Lynn that I've been emailing?

Also, I understood what you meant by the D, everyone's system works a little different.

I'm new at this DBA stuff, so you have been helping me out quite a bit with answering my questions, there are alot of issues here that I've been trying to resolve. If I would have known there was a forum I would have been on here weeks ago.

Back to top

IP Logged

Jenn

Browser

Living the dream.

Posts: 8
Gender: female

Re: Purging Annual Inventory
Reply #14 - 08/30/07 at 11:26:43

You may have deleted the locations that were in the frozen inventory or something. You may need to purge them by reinitializing some tables or running a SQL statement to empty them. I did this awhile back, but I'd need to look up the table names, etc. Maybe Lynn will jump in on this before I get a chance to look it up. [/quote]

also, I'm not sure about the locations thing, I have no idea if there were any set up, I was told there weren't, but again, I'm still going through alot of these things now.

Back to top

IP Logged