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.
Go to Solution.
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:
View solution in original post
Thank you Nikolay.
It is a good solution but I don't know if it is recommended as a best practice.