How to calculate Goods issue date based on the time of delivery

[Former Member]

Hi SAP Gurus,

I seek your help/suggestion for the given scenario.

The user requires calculating the GI date based on time of delivery.

Based on the delivery priority (like Priority 1= Day 1, Priority 2= Day 2) maintained in customer master, the need is something like below-

1st case= If Retail Customeru2019s delivery orders received before midday (Noon cut off) require to be dispatched on same working day (Day 1)

Wholesaler customer delivery orders received before midday require to be dispatched by the next

Working day (Day 2 Including day of receipt)

2nd case= Retail customeru2019s delivery orders received after midday require to be dispatched by the next working day

Wholesaler customer delivery orders received after midday require to be dispatched by on day 3

Kindly suggest , how to proceed in this. I am new to SAP world so need ur help to tackle this.

Thanks a lot in advance for the valuable inputs.

[Former Member · Accepted solution]

Customer has the shipping condition. Sales order will get the shipping condition from the customer. One of the cirteria for determining the route is also shipping condition. Now, you can change the shipping condition based on which you can change the routes. You define the routes in such a way that you can either use it to deliver the same day or the next day.

Now, when the users create a sales order they can change the shipping condition based on which the delivery happens. Also, you can use a user exit to check the time and then change the shipping condition based on which the route is redetmined. If you are getting the orders thro' edi, then you ask your customer to send the shipping condition. Else, the user exit will anyway take care of it while saving the edi orders.

Hope this helps...

Regards,

Mukund S

[Former Member]

Dear Mukund,

Thanks for your suggestion. I need some more input regarding the same. Can you pls explain me any scenario what i mentioned earlier, like if retail customer orders before 12 noon, it has to be dispatched by 5 Noon, within that day only. or any other which u feel to be more useful to discuss. i.e. any path flow/configuarion flow to be maintained to achieve this. /

Awaiting for any valuable input from experts.

[Former Member]

What I proposed to do was,

a. Create routes like 0 day route, 1 Day route, 2 day route etc.

b. Route determination is based on the Shipping condition of the customer. Put in the shipping condition for the customer as 00 - immediate delivery. 01 - By Truck, 02 - By Rail, 03 - Ship etc

c. Now, put in your route determination in such a way that routes change in the sales order with shipping condition (SC). Like, if the shipping condition is set to 00, then 0 day route comes up. Meaning immediate delivery, if SC is 01, then your normal route by truck picks up. etc.

When the sales order is manually created, you know the time of creation. As route is one of the criteria, the material confirmation happens based on number of days you put in the route to reach the destination. Now that you have the material available for today's delivery, the delivery program can be run to create it, or it can be manually created.

Now, when you configure the route you have to specify 'Transit duration in calendar days'.

When you have the sales order created electronically (say thru EDI), then, you may have to ask them to send in shipping condition. Else, you have to modify the function module Idoc_input_orders in such a way that if the sales order creation time is < 12 PM, then put shipping condition as 00, else copy what ever is there in the customer.

If you do not want to check the time manually when the user creates the sales order, then you may have to use the user exit MV45AFZZ (and I think you can use Save_order_prepare) to check the time and change the shipping condition. By this you will avoid extra coding in Idoc_input_orders and also need not bother if the user changed the route or not.

Hope my explanation helps.

Regards,

Mukund S