Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Suggested answer

Forecast for replaced product

Posted on by 73
Hi 
We have a scenario. Product A have enough sales history ( more than 3 years) in the system which is discontinued now. 
We have now product B (no sales history) as an alternative for the product A.
When we run forecast for product B, we want system to forecast the quantity for product B based on the history for product A. 
Please let me know if this is possible using ALTERNAIVE item number function in 'Released product' or using any other function in D365?
  • VaHiX Profile Picture
    VaHiX 2,454 on at
    Forecast for replaced product
     

    ** Please don't forget to close up the thread here by Like and verify it as an answer if it is helpful **

  • Suggested answer
    andrewlencsak Profile Picture
    andrewlencsak 272 on at
    Forecast for replaced product
    If you are generating statistical forecasts using Demand forecasting (with Azure Machine Learning) within the D365 UI, and not the new Demand planning app, you would have to import data for the new item using the data entity: " Historical external demand for V2 entity" to simulate previous demand. You would have to do this every period until D365 has enough historical demand data to use in the forecast generation. 
  • Suggested answer
    Farouk Galal Profile Picture
    Farouk Galal 51 on at
    Forecast for replaced product
    you can try using the item allocation key for only those two items and give the other item 100%
  • Suggested answer
    Guy Terry Profile Picture
    Guy Terry 28,604 Super User 2024 Season 2 on at
    Forecast for replaced product
    The Demand forecasting tool does not have specific functionality for this, but it does allow manual adjustments to the forecast in Excel, which it suggests can be used in these scenarios. The old PDF from the AX days describes (although I have not tried if it looks the same in F&O). You can find the PDF linked at the bottom of this page.
     
     
  • Forecast for replaced product
    Hi Terry, 
    Thanks for you reply. 
    I am not using Demand planning app or tool. I am using the standard Demand forecast function with Master Planning module of D365 F&O. 
  • Suggested answer
    Guy Terry Profile Picture
    Guy Terry 28,604 Super User 2024 Season 2 on at
    Forecast for replaced product
    How are you doing the thing you call 'run forecast'?
     
    If you are using the Demand Planning tool, it has the capability for 'phase in/phase out', but I do not believe this uses the Alternative Item field.

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 Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

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,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,336 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans