Skip to main content

On a Purchae Order, in APPS10 we’re seeing that the Wanted Delivery Date calculation is allowing the date to be a weeekend or holiday. Is there a way to make that change itself to a work day? 

Hi 

You need to specify Workdays and Non-Workdays on the Distribution Calendar on the Site and also add holidays using the exception and apply to the Distribution Calendar.

Hope that helps

Thanks

Jackie


@jenotto Wanted delivery date is based on the Distribution calendar that connected to the site. Try to change the calendar to a calendar which contain working days only. But this might affect to all customer and purchase orders.

Did I answer your question? 


Thank you @Jackie P and @Chamath Kuruppuarachchi ! I’m looking there now and think I’m observing that we are using the Default calendar and that the Default calendar is excluding weekends and holidays.

 

Thoughts?


I’ve worked with customers where the default calendar ‘*’ simply did not work properly. For example, connected to a work center we would have no results from the work center resource capacity calculation.

Recommend in a TEST environment creating a new Calendar, using the Schedule WEEK and using this as the Distribution Calendar for the Site. As @Chamath Kuruppuarachchi stated, this will affect dates on customer orders and purchase orders.


Thank you @matt.watters , I’ll test that out.


@matt.watters, thank you for the suggestion. We did some testing and couldn’t get it to work so I’ll put in a case with IFS. 


Just to update: IFS said in our case that Wanted Delivery Date could not be caused to automatically change to a work day. We’re working on a custom event to check it.


Just to update: IFS said in our case that Wanted Delivery Date could not be caused to automatically change to a work day. We’re working on a custom event to check it.

Hello @jenotto 

   Did you find a solution for that please ? did you created the Event ?

 

Abdel


Hi @Abdel , we ended up modifying PURCHASE_ORDER_LINE_PART_API to perform the check, by adding this statement.

      IF WORK_TIME_CALENDAR_API.Get_Closest_Work_Day('*', newrec_.wanted_delivery_date) <> newrec_.wanted_delivery_date THEN
          Client_SYS.Add_Warning(lu_name_, 'TEST: The selected Wanted Delivery Date for line :P1 release :P2 is a weekend or holiday.' || CHR(10), newrec_.line_no,  newrec_.release_no);
      END IF;


Hi @Abdel , we ended up modifying PURCHASE_ORDER_LINE_PART_API to perform the check, by adding this statement.

      IF WORK_TIME_CALENDAR_API.Get_Closest_Work_Day('*', newrec_.wanted_delivery_date) <> newrec_.wanted_delivery_date THEN
          Client_SYS.Add_Warning(lu_name_, 'TEST: The selected Wanted Delivery Date for line :P1 release :P2 is a weekend or holiday.' || CHR(10), newrec_.line_no,  newrec_.release_no);
      END IF;

Thank you so much for your answer


Reply