Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Super Contributor
Posts: 21
Registered: ‎12-08-2009
Accepted Solution

SLX Discontinued Products (web v7.5 sp2)

On the products table, there is a column called STATUS, which seems to either store “Available” or “Discontinued”. When I change a product’s status to “discontinued”, the product still shows up as a choice in the product tree (when adding a product to an opportunity). What’s the best practice on getting rid of (discontinuing) a product?

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: SLX Discontinued Products (web v7.5 sp2)

Since the PK (Primary Key) of the Product record is used in many places, you never want to actually delete the (product) records.

 

I'd suggest you doing a mod to filter out records that do not meet the "Available" status.  

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Highlighted
Nickel Super Contributor
Posts: 105
Registered: ‎11-11-2009

Re: SLX Discontinued Products (web v7.5 sp2)

That is exactly what I did to ensure I only saw available product.  It works very well!