Calculate schedule ship date based on pick release time
We have a requirement to calculate schedule ship date for a sales orderline based on the time of Pick Release i.e. when the SO line is released to warehouse. We cannot use defaulting rules on SO line to do this calculation as the time of pick release i.e. before noon or afternoon decides how many days needs to be added to sysdate for calculating schedule ship date which is communicated to external warehouse.
So far we have one option i.e. to do this calculation in the custom program we have developed to send the pick release lines to external warehouse.When this custom program is run and picks the released SO lines to be sent to external warehouse, the program can check systime and hence can caclulate the schedule ship date to be communicated to external warehouse. But in this approach, the only place we have the calclulated ship date is in the interface tables unless we use the same program to update schedule ship date in SO line. Later we will need to compare the