02-16-2010 08:15 AM
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?
Solved! Go to Solution.
02-16-2010 08:40 AM
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.