Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Planning worksheet filters for MPS and MPR calculation

Posted on by Microsoft Employee

can you advice me how could exclude some warehouse locations and bin contents from the MPS and MRP calculation?

i use a couple of bin contents to separate returns or expired items, but haven't seen how could exclude them from calculation

i've tried to activate a parameter into the manufacturing setup (use forecast on locations), using the location filter of  "total limits to" included on the regenerative calculation plan, but exlude all bins contents for the location filtered, no selective bins content exclusion is allowed

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Planning worksheet filters for MPS and MPR calculation

    Thanks Vishal

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Planning worksheet filters for MPS and MPR calculation

    You're rigth,   regards

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Planning worksheet filters for MPS and MPR calculation

    There is no standard solution available, when you use Bin Content for expired items.

    You need to write off the items from expired items on periodic basis or use separate locations for Expired Items.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Planning worksheet filters for MPS and MPR calculation

    Hi Rodrigo, I have the same situation, I also use bin contents to separate expired items, ¿did you find a solution?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Planning worksheet filters for MPS and MPR calculation

    i tink, our planner have to take special care and consider the real available inventory in order to adjust the planning worksheet proposal using as much he could, the customizing planning engine as you've suggested before, don't you?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Planning worksheet filters for MPS and MPR calculation

    planning-example.pngVishal, here you are some shapes as manufacturing setup, stockkeeping setup, production forecast and coments over the case.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Planning worksheet filters for MPS and MPR calculation

    Bin contents would not be excluded however you may able to use the inventory of specific locations only and can exclude certain locations inventory by managing proper SKU.

    In typical scenario, when you have multiple warehouses, planning should run independently and should not consider the inventory from all the locations. Hence defining the right setups at stockkeeping level should solve your issue.  

    Can you share some sample scenario and related setups for your requirement in bit more detail?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Planning worksheet filters for MPS and MPR calculation

    thanks Vishal, i've tested creating a production forecast by location, then using the "limit totals" into the planning engine, but it considers just the forecast for the specified location, taking the available inventory for all locations. I mean filters does not were made to exclude existence, only forecast.

    also, i made a stockkepping unit for an item in order to tested, so i could'nt see any difference over calculation.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Planning worksheet filters for MPS and MPR calculation

    I think, if you look at managing your planning at Stockkeeping level, it should meet your requirement to an extent.

    If not, you need to go with customizing planning engine to exclude certain locations or bins from the calculation, however it would be really complex job.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Planning worksheet filters for MPS and MPR calculation

    we do manage planning at item level

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans