How to setup dateformula and leadtime??

dn

Anyone who know if you can setup the Lead Time Calculation so items always arrive a monday?
I mean that I want to add the field Lead Time Calculation with some formula so it calculates
"Requested Receipt Date" day to always be a monday.
Is it possible in Nav 4. Sp1 ??

David_Singleton

Monday is WD1 in the CALCDATE function, you can used that, eg CD+14d+WD1 or something like that should suggest the first Monday more than 14 days from today.

dn

Thx for respons but I didn't worked for me.
Let say I have an order date 09-11-25, and leadtime 5D. If I don't use formula CD+5D+WD1 then I'll have
"Planned Receipt Date" to 09-12-02. (Saturday and Sunday is not workdays),Safety Lead Time is 1D then
Expected Receipt Date to 09-12-04.

IF I use formula CD+5D+WD1 or (5D+WD1 ) then will
"Planned Receipt Date" to 09-12-11
Expected Receipt Date to 09-12-15.
I expected
"Planned Receipt Date" to be 09-12-07
:-k