Open sales orders APO forecast consumption date - RDD or ATP date?

[Former Member]

There is a debate in my organization on whether RDD or ATP date should be used for forecast consumption of open orders. For open sales orders in APO, which date in the sales order should be used to determine which wk/mth the open sales order shall fall under? RDD date or ATP date and why?

In the Forecast Consumption wiki page it states that

"Use customer requirement's available date (e.g. sales requirement's available date) to calculated which date's forecast to be consumed.

Delivery date or other dates in sales order's schedule line are not used / considered in consumption logic."

Is the above referring to the ATP date?

Thank you.

[former_member244427]

Hello Erica,

Before we answer your question, you need to think about which date is the date of PIR, is it the date on which your supply should be available (Available date for the forecast) or is it the date on which the goods would be delivered to the customer (RDD)?

Now lets say your answer is RDD, then the planning engine which uses this PIR to create the supply should know the transportation time to calculate date on which the material should be ready and available. But as the PIR is independent of the destination or customer, we do not have this information. So the PIR is always at the date when we need the product to be ready to be picked for supplying. Now, should we reduce this PIR with RDD from sales order, we cannot subtract Apples from Oranges, so the answer is no, we need to use the "sales requirement's available date" as the PIR is also availability date.

I understand why this debate. Normally PIR=Forecast, and the organizations think the forecast is when the customer would need the material in there warehouse, which is not completely wrong.

But, from system's perspective PIR is the date when its needed at the location where you are entering the data, if you entering the data at the production plant the date represents its needed on this date in the production plant, when your PIR is at DC it represents its needed on this date at the DC, and when its entered at the customer level it would represent the so called RDD. In ECC we cannot achieve this.

Organization need to change the way look at PIR and adapt the numbers and dates to represent requirement at the plant/DC.

Hope I was able to give to enough ammunition to debate 😉

Regards,

Abhishek Rai

[rupesh_brahmankar]

Hello,

The standard behaviour is to look at Customer requested available date means CRD - MAD which date's forecast to be consumed.

The date displayed on MD04 is usually the Material Availability date of the schedule of the item of the Sales document. The date that the material is required to be available. Loading date - Pick/pack processing time = Material Availability date.

Required Delivery Date the date requested by customer for the ordered goods, however you have some in-transit time to deliver the goods. According system calculate the material should be available on particular date to delivery on requested date.

It is not the confirmation date for schedule line from ATP.

So for forecast consumption system use your first schedule line requested quantity and requested material availability date.

Best Regards,

R.Brahmankar