Supply chain | Supply Chain Management, Commerce

Forecast for replaced product

(1) Share

Report

Posted on by Chetan Rajpurohit

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?

All responses (6)

Answers (0)

VaHiX 3,119 on at

Like (2)

Report

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 302 on at

Like (1)

Report

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 51 on at

Like (1)

Report

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 28,626 Super User 2024 Season 2 on at

Like (1)

Report

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.
Chetan Rajpurohit 73 on at

Like (0)

Report

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 28,626 Super User 2024 Season 2 on at

Like (1)

Report

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.