Sage SalesLogix
  • Contact Us
  • Sage North America
800-643-6400
Welcome Twitter Facebook LinkedIn
Community Home Blogs Share Ideas Search Request Access Resources
Reply
Copper Super Contributor
kennedystephen
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?

Please use plain text.
Gold Super Contributor
RJLedger
Posts: 2,234
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

".. Stay Focused..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Please use plain text.
Nickel Super Contributor
dennissekulic
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!
Please use plain text.