Forward Scheduling calculation formulas for Sales Order

[Former Member]

Dear Experts,

I need to analyse & validate the proposed Schedule line dates for Sales Order with gATP .....

MAD calculated by the backward scheduling is falling in the past as on 25Nov2014 .......& im not able to match the schedule line dates calculated by the forward scheduling formula....

Would anyone please share the formulas for forward Scheduling OR validate the forward scheduling formulas used below similar to the backward Scheduling ones pasted below ?

Route	Transit Days	Transp
VSAV96	50,00	20,00
Shp Pt	Loadingw.days	Pick/pack wrkdys
A014	1,00	13,00

As per my calculation the dates should have been as Material availability date = Loading date - Pick/Pack time = 24-Oct-2014  - 13 = 10-Oct-2014 ( in the past on 25Nov-2014 ) as per backward scheduling on 25Nov-2014 ....

Material availability date = 25-Nov-2014 Current system date

Confirmed Delivery date = Material availability date( 25-Nov-2014 ) + Loading time 1 + Pick/Pack wdays 13 + Transportation lead wdays 20 + Transit wdays  50 = Material availability date( 25-Nov-2015 ) + 84 = 18-Feb-2015

Goods issue date = Confirmed delivery date - Transit wdays  = 18-Feb-2015 - 50 = 30-Dec-2014

Loading date = Goods issue date - Loading time = 30-Dec-2014  - 1 = 29-Dec-2014

Transportation scheduling date = Loading date - Transportation lead time  = 29-Dec-2014  - 20 = 09-Dec-2014

System calculated dates are on Current system date 25-Nov-2014 :----

Delivery date         D 15.12.2014  Arrival time     12:00

Goods issue date 16.12.2014  GI Time 14:23

Loading date 15.12.2014  Loading Time     14:23

Material avail.date       02.12.2014  Matl Staging Tme 14:23

Transportation Plan. Date 25.11.2014  Tr. Plan. Time   14:23

Would you pls be so kind & shed lights on why my calculations are not matching the system calculated dates ?

Regards

MM

[prashant_sharma21]

Hello MD,

While scheduling the material system first go through the Backword scheduling and then come to Forward scheduling.

There are two Delivery date in sales order. expected Delivery date and Actual Delivery Date.

Expected Delivery date: given by customer/Business

Actual Delivery Date: system calculate.

While backward scheduling if system find Material availability date in past or enough stock is not there then system then system take Forward scheduling.

In forwarding scheduling system consider today date as a material availability date (or calculate material availability date through MRP)  and add transportation lead time pick/pack time (which ever is longer) then add Loading time + Transit time to calculate Actual Delivery date. 

Thanks,

Prashant Sharma

[Former Member]

Mr. SharmaJee & AmanJee,

Thanks for the help.

Would you pls be so kind & answer my queries VERY SPECIFICALLY for better clarity??

System determined dates by forward Scheduling

Delivery date         D 15.12.2014  Arrival time     12:00

Goods issue date 16.12.2014  GI Time 14:23

Loading date 15.12.2014  Loading Time     14:23

Material avail.date       02.12.2014  Matl Staging Tme 14:23

Transportation Plan. Date 25.11.2014  Tr. Plan. Time   14:23

Here are my determinant data....

Route	Transit Days	Transp Lead time
VSAV96	50,00	20,00
Shp Pt	Loadingw.days	Pick/pack wrkdys
A014	1,00	13,00

1. What will be the MAD for forward scheduling if backward scheduling MAD is in the past ? ( i understand current system date )?    -----------Answer here pls

2. Has Unrealistic Schedule line dates been resulted out of "No Confirmation & no Committed Qty" in the schedule line due to higher transportation Planning time + unrealistic Delivery date on which no AVAILABILITY ?????     -----------Answer here

3. Why & how did system determine these UNREALISTIC & INCORRECT dates by the forward scheduling formulas -----------Answer here pls

4. Backward Scheduling:--

Goods issue date = Requested delivery date - Transit time = 15-Dec-2014  -  50 = 25-Oct-2014(in the past on 25Nov-2014 )

Loading date = Goods issue date - Loading time = 25-Oct-2014  - 1 = 24-Oct-2014(in the past on 25Nov-2014 )

Transportation scheduling date = Loading date - Transportation lead time = 24-Oct-2014  - 20 = 03-Oct-2014 (in the past on 25Nov-2014 )

Material availability date = Loading date - Pick/Pack time = 24-Oct-2014  - 13 = 10-Oct-2014 ( in the past on 25Nov-2014 )

Are the below forward scheduling dates manually calculated & the calculations correct ? Pls validate... & If correct why im unable to match the system calculated dates with manual forward scheduling formulas?? .. -----------Answer here pls

Material availability date MAD = 25-Nov-2014 = Current system date

Loading date = Material availability date + pick/pack time = 25-Nov-2014 + 13 = 07-Dec-2014

Transportation Planng date = Loading date - Trp lead time = 07Dec-2014 – 20 = 17Nov2014

Goods issue date = Loading date + Loading time = 07-Dec-2014 + 1 = 08-Dec-2014

Confirmed delivery date = Goods issue date + Transit time = 08-Dec-2014 + 50 = 27Jan2015

BR

MM

[Former Member]

MM,

MAD used for forward scheduling is 'current date'.

I will assume that your scheduling is being done in ECC.  Most of your questions about calculations of dates cannot be answered without knowing the factory calendars assigned to each of the relevant objects.

I suggest you read SAP help on the matter concerning how dates are calculated.  Transportation and Delivery Scheduling - Shipping (LE-SHP) - SAP Library

Best Regards,

DB49

[prashant_sharma21]

Hello MD,

Let me try to explain your issue.

1. What will be the MAD for forward scheduling if backward scheduling MAD is in the past ? ( i understand current system date )?    -----------Answer here pls

Ans: yes, If backward scheduling is failed then system consider current data as a Material Availability date (if no TOR comes in the picture).

2. Has Unrealistic Schedule line dates been resulted out of "No Confirmation & no Committed Qty" in the schedule line due to higher transportation Planning time + unrealistic Delivery date on which no AVAILABILITY ?????     -----------Answer here

Ans: usually this issue occurs while backward scheduling usually system add Transportation planning time or Pick/pack time (whichever is longer) to calculate Loading date. I don't think so system will throw this error due to longer transportation planning date.

3. Why & how did system determine these UNREALISTIC & INCORRECT dates by the forward scheduling formulas -----------Answer here pls

Ans: could you plz track changes in sales order you might get some clue moreover Plz check respective calendars as well, consider working day & holidays .

Are the below forward scheduling dates manually calculated & the calculations correct ? Pls validate... & If correct why im unable to match the system calculated dates with manual forward scheduling formulas?? .. -----------Answer here pls

Material availability date MAD = 25-Nov-2014 = Current system date

Loading date = Material availability date + pick/pack time = 25-Nov-2014 + 13 = 07-Dec-2014

Transportation Planng date = Loading date - Trp lead time = 07Dec-2014 – 20 = 17Nov2014

Goods issue date = Loading date + Loading time = 07-Dec-2014 + 1 = 08-Dec-2014

Confirmed delivery date = Goods issue date + Transit time = 08-Dec-2014 + 50 = 27Jan2015

Ans: I don't know how you/your system calculating Loading time 25th Nov + 13 days system should not calculate 7th Dec.

Moreover as per my understanding system add Transportation planning time or Pick/pack time (whichever is longer) to MAD to calculate Loading date.

Thanks,

Prashant Sharma

[AmanSharief]

Hi Md,

As per my understanding goes, system is not giving any unrealistic or incorrect dates but this is the standard system behavior in forward scheduling.

Here system will calculate the MAD as per your transportation lead time.

As per your example, your transportation lead time is 20 days then the loading date would be after 20 days i..e, 15.12.2015, from this date system will less the pick/pack time and proposes the MAD as below.

15.12.2015 – 13days = 02.12.2015, from this you can calculate rest of the dates I believe.

If stock is not available and the stock replenishment time is higher than the transportation lead time then the MAD date would be today date + planned delivery time maintained in MRP2 view of material master.

Somehow,  I could see that system is unable to pick up the transit time, please check if you have maintained the transit time correctly or if anything else is missing but rest of the dates are correct.

Let me also know once you have picked what you missed in transit time.

Regards,

Aman

[AmanSharief]

Hi Md,

To answer to your first question: formulas for forward Scheduling:

Normally, backward scheduling is always carried out first.  If the material availability date or transportation scheduling date is calculated to be in the past, the system must then use forward scheduling (to determine the next possible date).

Text Removed

Please check if this helps.

Regards,

Aman

Message was edited by: G Lakshmipathi

Copy pasting from other source is strictly not encouraged in SCN.  Please AVOID this practice.

cc :  Jyoti Prakash

[Former Member]

Dear Aman,

Many thanks for your kind gesture. Sorry for the late reply as i was away ...

3 more clarifications please

1. What will be the MAD for forward scheduling if backward scheduling MAD is in the past ? ( i understand current system date )?

2. Has Unrealistic Schedule line dates been resulted out of "No Confirmation & no Committed Qty" in the schedule line due to higher transportation Planning time + unrealistic Delivery date on which no AVAILABILITY ?????

3. Apparently system determined NO Committed Qty in the schedule lines....but how did system determine these UNREALISTIC & INCORRECT dates ,,,,,,i mean i am unable to match them with the forward scheduling formulas you proposed.....

Material availability date MAD = 25-Nov-2014 = Current system date

Loading date = Material availability date + pick/pack time = 25-Nov-2014 + 13 = 07-Dec-2014

Transportation Planng date = Loading date - Trp lead time = 07Dec-2014 – 20 = 17Nov2014

Goods issue date = Loading date + Loading time = 07-Dec-2014 + 1 = 08-Dec-2014

Confirmed delivery date = Goods issue date + Transit time = 08-Dec-2014 + 50 = 27Jan2015

Delivery date         D 15.12.2014  Arrival time     12:00

Goods issue date 16.12.2014  GI Time 14:23

Loading date 15.12.2014  Loading Time     14:23

Material avail.date       02.12.2014  Matl Staging Tme 14:23

Transportation Plan. Date 25.11.2014  Tr. Plan. Time   14:23

Here are my determinant data....

Route	Transit Days	Transp Lead time
VSAV96	50,00	20,00
Shp Pt	Loadingw.days	Pick/pack wrkdys
A014	1,00	13,00

Regards

MM

[AmanSharief]

Hi Lakshmipathi Sir,

I can understand what you mean but if you are referring to the formula of forward scheduling then this basic content is being copied from the documents which I prepared when I used to train people on SD and I am not very sure if the same content is available at some other source.

I completely agree to your comment and respect the rules set by SCN but my understanding says even if the content is available at others sources, the basic formulas, definitions, menu paths, tcodes, etc. remains same in any of the sources.

Also, being a senior consultant I had prepared some documents on SD topics based on my own experience and understanding and I was searching only in SCN to check if any documents are already available on the same topic and now as per your caution I make sure to search the same at others sources as well before I upload the document.

Correct me if I am wrong.

Regards,

Aman