Skip to Content
0
Feb 12, 2015 at 04:16 AM

Shipping Transits Duration : Sales Order

341 Views

Hi Friends,

The Issue is regarding, transits duration days at the sales order level as follow below,

Suppose the customer requested delivery date is on 24.02.2015 and for this transits duration is of 5 days. For this i have created route and transportation zone and same has been assigned in customer master. Till now everything is working fine. But now client requires that the date should also include holidays also. But in US saturday and sunday is holiday, so these dates are not in consideration.

My question is now . how to do these, so that even holidays dates can be calculated in transits duration.

Example : Total base on US Calendar.

2/24 is a Tuesday, this order needs to ship the Thursday prior (2/19)

Orders ships on 2/19

2/20 is 1 Day from 2/19

2/21 is 2 days from 2/19

2/22 is 3 days from 2/19 -----Holiday

2/23 is 4 days from 2/19 -----Holiday

2/24 is 5 days from 2/19

Second Example:

Transits Days procedure:

  • 23.02.2015 “Monday” = Day 1
  • 22.02.2015 “Sunday” = Not Calculating ( US Holiday)
  • 21.02.2015 “Saturday” = Not Calculating ( US Holiday)
  • 20.02.2015 “Friday” = Day 2
  • 19.02.2015 “Thursday” = Day 3
  • 18.02.2015 “Wednesday” = Day 4
  • 17.02.2015 “Tuesday” = Day 5

Hope you will respond on this asap.

Thanks in advance.

Regards,

Kundan

Attachments