Master Planning in Dynamics 365: Filtering Frustrations with Coverage Groups?

Table of Contents

Filtering Frustrations with Coverage Groups in Dynamics 365 Master Planning? Let’s Fix That!¶

image just illustration

Ever tried to fine-tune your master planning in Dynamics 365 by filtering items based on their coverage groups, only to be met with a frustrating wall of resistance? You’re not alone. It’s a common headache, but luckily, there’s a light at the end of the tunnel.

The Problem: Filtering Just Doesn’t Work as Expected¶

You set up your master planning batch job, meticulously joining the Items table to the Item coverage table. You specify exactly which Vendor and Coverage group values you want to include. You hit run, expecting a perfectly tailored plan. But then…bam! The system cheerfully ignores your carefully crafted filters and generates planned orders for everything. What gives?

image just illustration

The issue, as highlighted in KB article 4612572, is a system limitation. While you can create the join and specify the filter criteria, the master planning engine doesn’t currently respect those filters when generating planned orders. It’s like telling a dog to only fetch red balls, and it brings back every ball in the park.

The Workaround: Getting the Results You Need¶

So, how do we get around this limitation and actually filter our master planning runs effectively? There are a couple of strategies you can employ:

1. Pre-Filtering Your Items¶

Before running your master planning job, create a separate query or view that filters your items based on the desired Coverage group and Vendor values. Then, in your master planning setup, use this pre-filtered list of items as the input. This ensures that only the desired items are considered from the get-go.

image just illustration

2. Post-Filtering Your Planned Orders¶

If pre-filtering isn’t feasible, you can run your master planning job as usual and then filter the resulting planned orders. This requires an extra step, but it achieves the same outcome. You can use Excel or other reporting tools to filter the generated orders based on the Coverage group and Vendor linked to the respective items.

image just illustration

Digging Deeper: Understanding Coverage Groups¶

To truly master this challenge, let’s take a closer look at how coverage groups function within Dynamics 365. Coverage groups allow you to define how and where an item is stocked and supplied. They link items to specific vendors, warehouses, or other supply sources. This is crucial for planning and optimizing your supply chain. However, as we’ve seen, using them as filters in master planning requires a workaround.

Imagine you have multiple vendors supplying the same item, but you only want to plan orders for a specific vendor. That’s where the frustration with the current filtering limitation arises. You want that granular control, and these workarounds help you achieve it.

Example: Filtering by Vendor¶

Let’s say you have item ‘ABC’ supplied by two vendors: ‘Vendor X’ and ‘Vendor Y’. You only want to generate planned orders for ‘Vendor X’. Using the pre-filtering method, you’d create a query that selects only item ‘ABC’ with the Coverage group linked to ‘Vendor X’. This filtered list then becomes the input for your master planning run.

image just illustration

Beyond the Basics: Further Optimization¶

While the above workarounds address the immediate filtering issue, there are other ways to optimize your master planning process:

• Review your planning parameters: Ensure your planning parameters are configured correctly to avoid unnecessary planning runs.
• Utilize forecast models: Accurate forecasting is key to effective planning. Explore the various forecasting models available in Dynamics 365.
• Monitor and adjust: Regularly review your planned orders and make adjustments as needed. Master planning is an ongoing process, not a one-time event.

The Future of Filtering¶

Hopefully, future updates to Dynamics 365 will address this filtering limitation directly. In the meantime, these workarounds empower you to achieve the desired control over your master planning process.

Now, it’s your turn! What are your experiences with filtering in master planning? Share your thoughts, tips, and questions in the comments below. Let’s learn from each other and conquer this challenge together. Come back again if you want to get other information.