Managing old and discontinued Products

We need to be able to remove old and discontinued product associations with vendors or hide old and discontinued products without removing the history of the purchase.

The only solution I've seen so far(provided by SD below) removes the product, but also removes it from any PurchaseOrder thereby leaving no audit trail...not very good practice.

With the implementation of the new list based view in the Purchase Order screen it will not be long before it becomes unmanageable and difficult to use as the mix of discontinued and new product continues to grow.

What have other people done to manage this?

You can follow these steps if you are using MYSQL database

You can connect to the database through the following commands form the SD+ server :

cmd> cd C:\AdventNet\ME\Servicedesk\mysql\bin
cmd> mysql.exe -u root -P 33366 servicedesk

delete from PurchaseOrder where PURCHASEORDERID IN (select PURCHASEORDERID from purchaseorderext where COMPONENTID = 10)

delete from AssetDetails where COMPONENTID=<COMPONENTID>;

delete from ComponentVendor where COMPONENTID=<COMPONENTID>;

delete from ComponentDefinition where COMPONENTID=<COMPONENTID>;

This will remove the purchase order and Assert pointing to these products will be removed from the database.

Else you can just use the query alone in MSSQL server, if you use MSSQL server.

GaneshKB