Skip to main content
Solved

Can we force Wanted Delivery Date to be a workday?

  • Jun 22, 2022 5:52 PM UTC
  • 10 replies
  • 486 views
Do Gooder (Customer)
Forum|alt.badge.img+3

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? 

Best answer by Chamath Kuruppuarachchi

@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? 

View original

    10 replies

    Hero (Employee)
    Forum|alt.badge.img+6
    • Jackie P
    • Hero (Employee)
    • Jun 23, 2022 6:42 AM UTC

    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

      Chamath Kuruppuarachchi
      Hero (Partner)
      Forum|alt.badge.img+13

      @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? 

        Do Gooder (Customer)
        Forum|alt.badge.img+3
        • jenotto
        • Author
        • Do Gooder (Customer)
        • Jun 23, 2022 6:55 PM UTC

        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?

        matt.watters
        Ultimate Hero (Partner)
        Forum|alt.badge.img+26
        • matt.watters
        • Ultimate Hero (Partner)
        • Jun 23, 2022 7:59 PM UTC

        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.

        If a response resolves your issue, please use "Best Answer" so that the thread can be closed and others can find solutions more easily. Regards - Matt
          Do Gooder (Customer)
          Forum|alt.badge.img+3
          • jenotto
          • Author
          • Do Gooder (Customer)
          • Jun 23, 2022 8:07 PM UTC

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

          Do Gooder (Customer)
          Forum|alt.badge.img+3
          • jenotto
          • Author
          • Do Gooder (Customer)
          • Jul 7, 2022 3:50 PM UTC

          @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. 

          Do Gooder (Customer)
          Forum|alt.badge.img+3
          • jenotto
          • Author
          • Do Gooder (Customer)
          • Aug 12, 2022 7:00 PM UTC

          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.

            Sidekick (Customer)
            Forum|alt.badge.img+6
            • Abdel
            • Sidekick (Customer)
            • Oct 22, 2024 10:31 AM UTC

            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

            Do Gooder (Customer)
            Forum|alt.badge.img+3
            • jenotto
            • Author
            • Do Gooder (Customer)
            • Oct 22, 2024 2:47 PM UTC

            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;

              Sidekick (Customer)
              Forum|alt.badge.img+6
              • Abdel
              • Sidekick (Customer)
              • Oct 22, 2024 3:23 PM UTC

              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

              Terms & ConditionsAccessibility statement