Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Unanswered

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

(1) ShareShare
ReportReport
Posted on by 32
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

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans