Calculation of goods issue date in sales order with routes

[Former Member]

Hello Gurus,

This is my first post on SCN, I'm excited to share a new little problem I have.

I have configured my routes determination as per our requirements.  For example, I have one route configured in 0VTC such that the transit duration is 1 hour.

When I create a sales order, I enter that route (1 hour transit.dur) under shipping on the line item.  Then I set a delivery date sometime in the future to test out my config.  Looking at the shipping "Goods Issue Date", I see that the date is 2 hours earlier than my delivery date.  It's supposed to be 1 hour.

I looked through many forums and found no help on this.  My factory calendar is configured such that all days, including weekends and holidays are production days.

Please advise at your earliest.

Thanks,

Mido

[former_member223981 · Accepted solution]

Hi Mido,

I did a quick test and it worked ok for me.

This sounds like a time zone issue. Set a breakpoint in include LV03CF02 (form SCHEDULE_BACKWARDS):

*************************

*   4.5A delivery date & time checked by caller (which may allows

*   ..   a delivery o non-workin days)

*   calculate transit time

     CALL FUNCTION ls_current_function_module

       EXPORTING

         iv_calendarid          = is_scheddu-transit_fc

         iv_tstreamid           = is_scheddu-transit_ts

         iv_begin_datelocal_req = cs_schedev-lfdat

         iv_begin_timelocal_req = cs_schedev-lfuhr

         iv_begin_timezone      = is_scheddu-transit_tz    <<<<<<<<<<<<<<<

        iv_end_timezone        = is_scheddu-loading_tz    <<<<<<<<<<<<<<<

        iv_duration            = is_scheddu-transit

         iv_direction           = gc_minus

*************************

Do you have a different value in is_scheddu-transit_tz & is_scheddu-loading_tz ?

[former_member223981 · Accepted solution]

Just a quick addition to my previous reply:

is_scheddu-transit_tz: Should hold the timezone of the customer. Check in transaction VD03; Adres tab

is_scheddu-loading_tz; Should hold the timezone of the shipping point address. Check in SPRO - Enterprise Structure - Define, copy, delete, check shipping point; select the relevant shipping point, then press the address button.

Are the timezones different between the customer and shipping point?

[Former Member · Accepted solution]

Hi Noel,

Thanks for your very helpful response.  I did a break point and checked the values.  The logic is there and GI is 1 hour less than delivery.  Also the timezones are both identical for the shipping point and the ship-to.  So it must be something else.  

So where else is there logic that overwrites the logic of the Include?

[former_member223981 · Accepted solution]

*************************

*   4.5A delivery date & time checked by caller (which may allows

*   ..   a delivery o non-workin days)

*   calculate transit time

     CALL FUNCTION ls_current_function_module

       EXPORTING

         iv_calendarid          = is_scheddu-transit_fc

         iv_tstreamid           = is_scheddu-transit_ts

         iv_begin_datelocal_req = cs_schedev-lfdat

         iv_begin_timelocal_req = cs_schedev-lfuhr

         iv_begin_timezone      = is_scheddu-transit_tz    <<<<<<<<<<<<<<<

        iv_end_timezone        = is_scheddu-loading_tz    <<<<<<<<<<<<<<<

        iv_duration            = is_scheddu-transit

         iv_direction           = gc_minus

*************************

What are the values in the data objects listed above at this point?

[Former Member · Accepted solution]

[Former Member · Accepted solution]

I'm beginning to think this issue has to do with shifts/working hours/factory calendar. 

May the system is setup such that the last hour of work (shift) is always at 22:00:00?

Any help please

[phanikumar_v3 · Accepted solution]

have you assigned any shifts for the shipping point??

Also please check any unloading times maintained at customer master???

Phanikumar

[Former Member]

All

The issue is now resolved.  What I had to do was assign a 24 hour working shift to a factory calendar, then assign that factory calendar to the shipping point.  My issue was that my working shift hours ended at 22:00:00, thus, GI was calculated based on the latest shift possible.

Thank you all for your help. 

[Former Member]

This message was moderated.

[former_member182378]

Mido,

Are you changing the requested delivery date of the same line item, in the sales order and then getting 2hrs of transit time? instead of one.

Please give the screenshots - of route configuration and sales order (both cases - present and future)

[Former Member]

Hi TW Typewriter,

Yes, I am changing the date in the "schedule lines" tab for the sales order to a date next week, say May 23, 2014.  When I click on the display "Shipping" info, I see:

1) Delivery date: 05/23/2014 - 00:00

2) GI Date: 05/22/2014 - 22:00:00

The expectation is to have the GI date 23:00:00 since my config for the route on the sales order is for 1 hr of transit time only.

See attached

[phanikumar_v3]

Transit Duration will always maintained in Days.

As per you maintained in Hours.(i hope here only the issue lying)

Please provide the screen shot By going to 0VTC>>>select the relevant>>>Click on route stages in control data section.--provide this screen shot to us.

Phanikumar

[Former Member]

Hi Phanikumar,

Looks like I did not maintain the route stages screen for the particular route. 

What should it be maintained as if I want GI to be 1 hour less than delivery date?

Thanks

[phanikumar_v3]

Please follow my earlier reply on route stages in 0VTC.

can help you anyway.

Phanikumar

[Former Member]

I'm not too sure I follow.  What do I enter in the route stages of the route chosen in 0VTC?

Please assist me with that.  I attach a screenshot.  I only want 1 hour for total time between GI and delivery.

Thanks

[phanikumar_v3]

Please search in Google how system determines delivery date & GI date ---you will get lot of Info.

Please dont take wrong--during this search procedure you will learn many more things.

Phanikumar