You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Excluding the week ends in calculating the Scheduled Arrival Date

edited Dec 13, 2023 2:02PM in Order Management 12 comments

Hello Everyone, 

We have a requirement to exclude the weekends in calculating the scheduled Arrival Date based on the transit time, request Type (Ship On) & scheduled ship date.

Eg.: SSD (Scheduled Ship Date) is 22-Dec (Friday),

Transit Time is 3 Days

Shipping warehouse associated with 7 days calendar (5- working days & 2- Off days)

SAD (Scheduled Arrival Date) is calculated as 25-Dec (Monday), which includes Saturday and Sunday,

but our expected SAD is 27-Dec (Wednesday) by excluding Saturday and Sunday,

Can someone, suggest us on the above

Thanks,

Venkat Bootharaju

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!