Supply chain | Supply Chain Management, Commerce

Forecast Consumption

(0) Share

Report

Posted on by PNash

Hello;

Is there any way to change forecast consumption to be based on Customer Requested Date as opposed to Physical Date?

The challenge we have is that when we re-date past due orders and they ship, they consume forecast in the week that they are shipped in. This leads to understating of demand. What I would expect to see is that the forecast consumption happens in the week that the order is requested, and then when it ships it does not consume forecast in the ship week.

I.E. if the forecast in a week is 1000, and we ship 200 that are past due.. the remaining forecast is 800, however we still do expect to get orders for 1000.

We have to manually intervene and adjust forecast signaling to make the demand stay whole.

There has got to be a better way, no?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Hi PNash,

Have you considered setting up coverage groups?

To configure a coverage group so that it includes a demand forecast, follow these steps.

Go to Master planning > Setup > Plans > Coverage groups.

Select an existing coverage group, or create a new group.

On the Other FastTab, set the following fields:

Forecast plan time fence – Enter the number of days (from today's date) that the demand forecast should be applied for.

Reduction key – Select the reduction key to apply.

Reduce forecast by – For master plans where the Method used to reduce forecast requirements field is set to Transactions - reduction key or Transactions - dynamic period, specify which transactions should reduce the forecast. Select one of the following values:

All transactions – All transactions should reduce the forecast.

Orders – Only sales orders should reduce the forecast.

For more detailed steps, please refer to the following documents:

Master planning with demand forecasts - Supply Chain Management | Dynamics 365 | Microsoft Docs

Hope my answer can help you.

Best Regards,

Charlotte

Was this reply helpful? Yes No
Suggested answer

ColbyGallagher 3,666 on at

Like (0)

Report

Hi PNash, (Phil?),

It sounds like you're correctly updating the confirmed ship date on the sales line to when it will actually ship, which updates the associated Inventory Transaction record with a new expected date in say week 3, which is not the same as the sales line requested ship date the customer provided, which is in week 1. Is my understanding correct?

In general, no, you're not going to get master planning to reduce forecast based on the data on the sales line (Requested ship date), its going to respond to the data on the associated Inventory Transaction (Expected date) .

Documentation from Microsoft pretty much says the same thing:

https://docs.microsoft.com/en-us/dynamics365/supply-chain/master-planning/reduction-keys

and the ReqForecastReduce class shows the same:

It probably wouldn't be a difficult mod to:

1.) Add a flag to the item coverage record / coverage group that says "add re-dated demand to the correct demand forecast"

2.) When a sales line's confirmed ship date is changed, check the item coverage record or the coverage group, to see if the new parm is ticked to yes, if so, go update the demand forecast in the confirmed ship date week and increase it by the sales line delivery remainder quantity. Then, when the SO line ships "on time" according to the new expected date on the inventory transaction, the demand forecast will get reduced using standard logic the way you expect it to.

3.) Log the change from # 2 somewhere so you can validate the data for a while.

Was this reply helpful? Yes No