How calendars are considered when calculating lead times

Lead time calculation is the calculation that takes place to calculate "Expected Receipt Date" from the "Order Date" or the other way around. Similarly, sales have the calculation to calculate "Planned Delivery Date" from "Shipment Date" or the other way around as well. Here, we will be focusing on the Purchase side but this will have same explanation for the Sales.

In any case, the interesting piece I would like to cover is how determines what calendar to consider when calculating lead times. As you know, there are many different calendars in NAV:

  • Company calendar
  • Location calendar
  • Vendor calendar
  • Shipping Agent calendar
  • ...

But, how all those relate when this calculation takes place? First of all, we need to have the following NAV premise in mind: if we don't have vendor calendar defined, NAV considers location calendar. Thus, if for whatever reason you have a location calendar while vendor does not have any (7 days per week), NAV will calculate the expected receipt date based on the location calendar. Here, most of the times, we wouldn't like this since we don't want the vendor lead time to be impacted by our location/warehouse calendar. If you are aware of this premise, you will understand better the design and you will have to setup a workaround: to create a vendor calendar with all days as working days (7 days per week). Having this in mind, NAV will find the vendor calendar (all working days) and will use this together with the vendor lead time.

Now, what are the different calculations that NAV is doing with lead times and calendars? a backward calculation and a forward calculation. Lets try to explain this a bit:

  • Forward. Here, we are calculating the expected receipt date (when do we have this in our company's premises?). This calculation is being done from the "Order Date". In other words, we now the purchase "Order Date" and we need to calculate the purchase "Expected Receipt Date" together with lead times and calendars. As mentioned above, if we don't have vendor calendar, it will use the location calendar. If we have vendor calendar (workaround: 7 days/week working days), it will use this vendor calendar together with the lead time and, once this final date is found, it will round to the next working day as per the location calendar (so, we won't set the "Expected Receipt Date" to a non-working date based on our location calendar but to the next working).
  • Backward. Here, we know the "Expected Receipt Date" (for instance, this is a requisite from our planning) and we need to calculate the "Order Date". The logic is similar to the above while we are calculation this backward (we know when do we want to have this available "Expected ..." and we would like to determine the date when we need to place this purchase "Order Date").

Here, the main thing is the fact about location calendar being used when vendor calendar is not set. As long as you are aware of this, you will anticipate issues by setting a 7 d/week calendar for the vendor to ensure this will be considered.



Comments (2)

  1. Jan Leeuwenburgh says:

    This could be a bit late considering the age of the post, but it’s worth a shot.

    I’m trying to setup a vendor calendar, the calendar is setup so the only available day is Friday. I set this calendar as the vendor calendar and ran MRP for one of the items from this supplier that was supposed to be ordered later this month. I did this by opening the net requirements for the item in the planned purchase orders section on AX2012 and then updated the main planning. This is the part where I got confused as it kept using the standard calendar. AX used the standard calendar to check when to order the item and not the vendor calendar I selected.

    My question is, how do I make it so that it actually does run the vendor calendar when I have it selected and setup the calendar properly according to the tutorial. It also shows on the second tab of the ‘Plan’ that the calendar selected is the standard calendar.

  2. Sigfredo says:

    This refers to AX2012 while post refers to NAV. Not sure if we are on the same page …
    When this is NAV, vendor calendar should be used since we need then vendor to be available so when ordering this.

Skip to main content