How to completely hide or deactivate discontinued products?

Finance and Operations/AX
1

Hello everyone,

We are using Dynamics 365 F&O and I need some guidance regarding product deactivation.

We have about 100 items that have been discontinued, and we want to completely prevent them from appearing when a user creates a Purchase Requisition.

I tried using the “Stopped” flag under Default Order Settings, but the product still shows up in the lookup/search. When the user selects it, the system just throws the “Product is stopped” error message.

In our scenario, we only use the ERP for purchase requisitions; we do not have any inventory movements for these items.

Is there a standard, out-of-the-box way to fully deactivate or hide these products so they don’t even appear as an option for the end-user?

Thanks in advance for your help!

2

Hi @Maria_Alice_Santana

The “Stopped” flag blocks orders at validation, not at lookup, so products still show up. That’s expected F&O behavior.

Quick Fix (No Code): Add a custom lookup filter on the Purchase Requisition form to exclude items where Status = “Stopped”. Takes an hour.

Better (Low-Code): Create a “Discontinued” product attribute and filter lookups against that instead.

Full Control (X++): Override the lookup datasource with a where() condition to completely hide discontinued items.

For 100 items, the custom lookup filter is your fastest win.

I remember you had a similar product visibility issue back in October. This might be worth a deeper look. We can help you build a scalable solution, or just guide you through the lookup approach, let us know what works better for you.

How can we help?

3

You can limit Purchase requisition users from seeing certain categories by setting up Category access policy rule: Procurement and sourcing/Setup/Policies/Purchasing policies

You can also Hide all products per category in your Procurement catalog: Procurement and sourcing/Catalogs/Procurement catalogs

Or you can remove single items from you Procurement category under Products fasttab: Procurement and sourcing/Procurement categories

You achieve the same outcome as the previous if you remove an item directly from Category hierarchy that is the basis for your Procurement category: Product information management/Setup/Categories and attributes/Category hierarchies

And you should of course use Product lifecycle state to block discontinued Released products.