Skip to main content

Notifications

Supply Chain Management forum
Unanswered

Planning Optimization Requirement Date's in the past - issue with expired batches & double counting

Posted on by 26
My company is in the process of testing/validating planning optimization, and we are running into an issue with the way that planning optimization handles requirements dates that are in the past. It appears that net requirements is "double counting" issues related to inventory that was put on a hold status & removed from available inventory (ie: Inventory Journal for a negative quantity), in which those batches have also exceeded their best before date (ie: expired Batch for a negative quantity). The problem we are seeing is that planning optimization puts all requirement date issues in the past on todays date, yet expired batch dates still appear in the past on whatever the best before date was. Because of this, we have situations where planning optimization is "double counting".
 
Take the following for example: Consider today it is Month 3. An item was put on hold due to quality concerns (status changed to remove from available inventory) in Month 1, but also expires in Month 2. In deprecated master planning, Net requirements would only see the inventory status change in Month 1, and ignore the expired batch in Month 2, since that batch was already removed from available inventory. Now, in planning optimization, we are seeing that Net Requirements shows negative issue for the Expired batch in Month 2, but then ALSO shows another negative issue for the Inventory status change in Month 3 on todays date, effectively double counting the negative issues for this batch. This results in Planning Optimization overplanning in the future to compensate for this.
 
Does anyone have experience with this issue, or does anyone have any advice on how to navigate around this issue? Screenshots below for context, plans were refreshed on 10/8 in the below pictures...
 
Planning Optimization Output
 
Deprecated Master Planning Output

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans