Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Planning Worksheet behaviour when filtering by item

Posted on by 40

Hi,

in the Planning worksheet when I run the "Calculate Regenaritive plan wksh" and I filter by a specific item number representing and Assembly with an associated BoM, I don't get any proposal for the components of that BoM, even though all the setups seems to be correct: replenishment and planning policies, low level code, etc.

Indeed, if I do the same without any filter applied to a specific item, I get all the proposals for both assemblies and components and therefore production orders and purchase orders.

Does the Planning worksheet limit the calculations to the specific selected item in the filter field disregarding the associated BoM? 

Thanks.

Fabrizio

  • Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    RE: Planning Worksheet behaviour when filtering by item

    The planning worksheet relies on accurate planning parameters to create lines for items. Without proper parameters, the system may not be able to identify demand correctly. This can result in no planning, inaccurate or incomplete planning suggestions.

    it is important to verify that the item's planning parameters are correctly set up. This involves checking factors such as demand settings, timing considerations, and other relevant parameters.

    below is a good discussion for your reference

    community.dynamics.com/.../assemble-to-stock---what-generates-the-assembly-order

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,934 Super User 2024 Season 2 on at
    RE: Planning Worksheet behaviour when filtering by item

    Well You can try to explore option to add dimension value to Items (but I think only Global dimensions can be used) and then when running the plan - add filter to that value. But if one and the same component is used on many BOMs then it might not be useful. 

    Otherwise You can calculate regenerative plan for all items, and then delete the lines that You don't need now.

    Without knowing a bit more details about business / products it's hard to tell best way. 

  • RE: Planning Worksheet behaviour when filtering by item

    Thanks for the answer: since we're doing some tests I hoped that filtering by an assembly was enough to get also the planning for the child components of that assembly. This would allow as to:

    1) avoid to run the Regenerative Plan for all the items (assemblies and components that have a Planning set up) or

    2) avoid to include all the components included in the assembly under test...imagine when you have 10-20 components per assembly.

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,934 Super User 2024 Season 2 on at
    RE: Planning Worksheet behaviour when filtering by item

    I feel like the answer is already in the question. If You add filter, it will look only at that item and ignore anything else. You might want to adjust Your filter, and include all items, that You want to look (main item and components)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans