Lead Time




I am trying to calculate production date based on the delivery date and the leadtime.

But the problem that, I need to exclude weekends and it didn't work. I tried several methods but it didn't work on all the cases.


Any idea that helps ?


Thanks in advance.




Best Answer

  • nikolay_denisov

    Hello @TAGORTI 

    I have an idea, but it might be not fully aligned with best practices.


    So if you have to calculate lead time only for this current year - you could do it via module which will have a daily timescale with dimension of your material.

    So as an input you will have a date order; Lead time (working days).

    Please see my small POC:

    Screenshot 2020-10-09 at 19.09.07.png


    Screenshot 2020-10-09 at 19.09.26.png

    Regards, Nikolay


  • Thank you Nikolay.


    It is a good solution but I don't know if it is recommended as a best practice.