Open Forum

Expand all | Collapse all

NAV2013 LeadTime and dates

Jump to Best Answer
  • 1.  NAV2013 LeadTime and dates

    TOP CONTRIBUTOR
    Posted May 06, 2019 09:27 AM
    Edited by Samuel Champoux May 06, 2019 04:11 PM
    ​Hi, quick question on leadtimes.
    We have items set as 4W and 6W of Leadtime, but NAV2013 seems to calculate 7 days and use open days, so it gives us 4W plus 8 open days and 6W plus 12 open days.
    Is that standard or did we miss a setup?

    Users expect Leadtimes in weeks to be 5 open days, not 7.

    Quick examples:
    Item is 2W leadtime. I enter it today (2019-05-06), I expect the delivery date to be 2019-05-20, but it gives me 2019-05-24 instead. (4 open days later)
    Item is 6W leadtime. I enter it today (2019-05-06), I expect the delivery date to be 2019-06-17, but it gives me 2019-07-03 instead. (12 open days later)

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: NAV2013 LeadTime and dates

    TOP CONTRIBUTOR
    Posted May 06, 2019 10:50 AM

    Check your calendar settings. Check to see if a calendar is assigned to the vendor, if not, it is using the Base Calendar. If you do not have Saturday and Sunday marked as non-working days on the calendar being referenced, this could be your problem.

     



    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: NAV2013 LeadTime and dates

    TOP CONTRIBUTOR
    Posted May 06, 2019 10:51 AM

    Check your calendar settings. Check to see if a calendar is assigned to the vendor, if not, it is using the Base Calendar. If you do not have Saturday and Sunday marked as non-working days on the calendar being referenced, this could be your problem.

     



    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: NAV2013 LeadTime and dates

    TOP CONTRIBUTOR
    Posted May 06, 2019 03:07 PM
    Edited by Samuel Champoux May 06, 2019 03:12 PM
    Yes our weekends are marked as non-workable, actually it seems like the cause of the problem.

    If the standard week is 5 days, 4W should be 20 days, not 28 days, or am I misunderstanding something?

    Quick examples:
    Item is 2W leadtime. I enter it today (2019-05-06), I expect the delivery date to be 2019-05-20, but it gives me 2019-05-24 instead. (4 open days later)
    Item is 6W leadtime. I enter it today (2019-05-06), I expect the delivery date to be 2019-06-17, but it gives me 2019-07-03 instead. (12 open days later)

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: NAV2013 LeadTime and dates
    Best Answer

    TOP CONTRIBUTOR
    Posted May 06, 2019 04:35 PM
    I think the problem is that 4W is 28 days. There is no consideration of working and non-working in date formulas. You need to use the number of working days for your lead time formula, in your first example = 20D. If you setup your calendars with non-working days including holidays, I think you will find that NAV will calculate dates properly.

    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: NAV2013 LeadTime and dates

    TOP CONTRIBUTOR
    Posted May 07, 2019 08:02 AM
    Edited by Samuel Champoux May 07, 2019 08:02 AM
    ​Thank you, I thought that was the case.
    How do people usually setup the calendar? With or without weekends?
    I am thinking maybe we should have an all-open calendar for vendors, and maybe another different calendar for other things that really need week-ends off, like shop/planification claendars.

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: NAV2013 LeadTime and dates

    TOP CONTRIBUTOR
    Posted May 07, 2019 11:34 AM
    Typically, the users I have worked with using lead time and calendars wanted to take advantage of considering holidays and non-working days setting dates on orders. They would set up lead time as 20D, not 4W and use a calendar indicating weekends and holidays. I think they just confirmed with the vendors that they told them 4 weeks that they really meant 20 working days. However, there is nothing stopping you from setting up multiple calendars. It becomes a data management question.

    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software
    ------------------------------

    Conference-BCNAVUG_200x200


  • 8.  RE: NAV2013 LeadTime and dates

    Posted May 08, 2019 12:00 AM
    Fyi, we use days to drive settings rather than months or weeks. For our vendor cards, depending on the vendor, lead time would be presented as 35D as an example. This gives better control over date available result.

    ------------------------------
    Starrla Hawkins
    Director of Customer Relations and System Admin
    ECR4Kids, a CRI Global company
    San Diego CA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 9.  RE: NAV2013 LeadTime and dates

    TOP CONTRIBUTOR
    Posted May 08, 2019 10:13 AM
    Samuel - Adding to the discussion - if your purchase lead times represent working days meaning 20D represents 4 working weeks (Monday to Friday less holidays) then you can simply use your company calendar for planning. (which is setup in Company Information).

    If your purchase lead time represents calendar days, then you would setup a vendor calendar that is open 365 and assigned on each vendor. Planning will use this calendar and not the company calendar.

    From my experience purchasing lead times most often are setup to represent calendar days. The reason is that trying to manage the lead time on thousands of items is a challenge. What I mean by this is that the planning values (reorder points, reorder quantity, etc.) in NAV/BC are static and need to be managed on some regular schedule. Quarterly, semi-annually or yearly depending on your business and often require updating due to seasonal requirements. Vendor Lead time falls into this managed data and when reviewing the purchase history from NAV/BC removing weekends from the purchase order date to received date can be a challenge to calculate a new vendor lead time for analysis representing days.

    ------------------------------
    John Grant
    Senior Application Consultant
    Innovia Consulting
    ------------------------------

    Conference-BCNAVUG_200x200


  • 10.  RE: NAV2013 LeadTime and dates

    TOP CONTRIBUTOR
    Posted May 08, 2019 04:38 PM
    ​Thank you all for your comments, very useful to help us decide!

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role