Forecast for replaced product

(3) Share

Report

Posted on by Chetan Rajpurohit

163

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?

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Guy Terry 28,924 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Chetan Rajpurohit 163 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Guy Terry 28,924 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Farouk Galal 53 on at

Like (1)

Report

you can try using the item allocation key for only those two items and give the other item 100%

Was this reply helpful? Yes No
Verified answer

Drew Lencsak 411 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Vahid Ghafarpour 12,090 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No