How to Exclude Items From Master Planning in Dynamics 365

Master planning in Dynamics 365 Supply Chain Management tries to balance supply and demand across all stocked items, but not every product should be part of that calculation. Whether you’re dealing with promotional kits, one‑off custom builds, or items that are always purchased on a make‑to‑order basis, you’ll want to keep them out of the automated plan. This guide walks through the reasons, the exact steps, and the gotchas you’ll meet when you need to exclude items from master planning in Dynamics 365.

Why Excluding Certain Items Improves Planning Accuracy

Including every SKU in the run‑time plan can inflate safety stock, generate phantom demand, and skew coverage calculations. For example, a high‑value engineering prototype that never repeats can cause the system to reserve inventory that should be available for fast‑moving parts. By marking such articles as “do not plan,” you let the engine focus on the items that truly drive replenishment, which leads to:

• More realistic gross‑requirements tables.
• Reduced unnecessary purchase orders.
• Cleaner demand forecasts that reflect real sales patterns.

In practice, the impact is often visible within the first few planning cycles – the recommended purchase quantities shrink, and the exception reports become easier to read.

Step‑by‑Step: How to Exclude Items in Dynamics 365

Dynamics 365 provides a couple of ways to keep an item out of the master plan. The most common method is the Planning exclusion flag on the product record. Follow these steps:

• Open the product catalog. Navigate to Product information management → Products → All products and locate the item you want to exclude.
• Edit the product. Click the Planning fast‑tab (or the equivalent tab in your version).
• Set the exclusion flag. Check the box labelled “Do not include in master planning” or “Planning exclusion.” This tells the engine to ignore the item when it builds the gross‑requirements schedule.
• Save and close. The change takes effect the next time you run a master plan.

If you prefer a more granular approach, you can also use coverage groups or supply schedules. Assign the item to a coverage group that has its Plan automatically option disabled, or create a supply schedule that marks the horizon as “Never.” Both techniques achieve the same result while giving you the flexibility to toggle planning status without editing the product each time.

Using the Planning Worksheet to Verify Exclusions

After you’ve set the flag, it’s wise to confirm the item truly disappeared from the plan. Open the Planning worksheet (found under Master planning → Planning worksheet), select the relevant site and horizon, then filter by the product number. If the item is absent, the exclusion is active. If you still see lines, double‑check that the item isn’t part of a bill‑of‑materials where a child component is still marked for planning – the engine will pull in components unless they’re also excluded.

Common Pitfalls and How to Avoid Them

Even seasoned planners can stumble over a few traps:

• Excluding a component of a kit. When a parent product is planned, its children are automatically considered. Make sure you either exclude the parent or set the entire BOM to “non‑stocked” if you don’t want any planning activity.
• Overlooking demand forecasts. If a demand forecast exists for an excluded item, the system may still generate a suggestion. Clear or deactivate the forecast to keep the plan clean.
• Forgetting to refresh the plan. The exclusion flag only takes effect after the next master‑plan run. Running the plan immediately after changes helps you spot errors early.

Best Practices for Ongoing Maintenance

Keeping your master plan lean is an ongoing discipline. Here are some habits that pay off:

• Review the Planning exclusion list quarterly – business needs change, and a product once sold on a project basis may become a regular SKU.
• Document the rationale behind each exclusion in the product notes. Future users will appreciate the context.
• Leverage security roles to restrict who can toggle the exclusion flag. Accidental changes can disrupt supply‑chain KPIs.
• Combine exclusions with proper demand‑forecast settings. If an item is “do not plan,” its forecast should typically be set to zero or disabled.

FAQs

Can I exclude an item for one site but keep it in the plan for another?

Yes. The exclusion flag can be set at the site level by editing the product’s site‑specific inventory parameters. This lets you treat a regional specialty as make‑to‑order while still planning it centrally elsewhere.

Does excluding an item affect the safety‑stock calculation for related items?

Only if the excluded item is a component of another stocked product. In that case, safety stock for the parent will be based on the parent’s demand, not the child’s, which is usually the desired outcome.

What’s the difference between “Do not plan” and setting a product as “Non‑stocked”?

“Do not plan” stops the master‑planning engine from generating replenishment proposals, but you can still manually create purchase orders. “Non‑stocked” tells the system the item will never be held in inventory, effectively removing it from all inventory‑related processes.

Will excluding items reduce the time it takes to run a master plan?

Generally, yes. Fewer items mean a smaller calculation matrix, so the engine completes its run faster, especially in environments with thousands of SKUs.