Open Forum

Expand all | Collapse all

Demand and Inventory Forcasting

  • 1.  Demand and Inventory Forcasting

    Posted 15 days ago
    Dear Team.
    I am currently looking for an Easy way to manage the below in Nav 2018.
    • Inventory planning and forecasting using my set Sale budget.
    current scenario is that we have Product's Budget by Customers per Month.

    I need to use the sales budget to plan for my Material  and inventory Requirements for planning.
    Any add on or solution available within Nav?

    ------------------------------
    Stanislaus Banda
    Head Of Supply Chain and ICT
    Osho Chemical Industries ltd
    Nairobi
    ------------------------------


  • 2.  RE: Demand and Inventory Forcasting

    TOP CONTRIBUTOR
    Posted 14 days ago
    As long as you already have a sales forecast developed, you can load it into the Production Forecast (or Demand Forecast) Entry table.  The forecast type would be "Sales Item" and the table will allow you to enter multiple lines for each item by forecast date and location.  Unfortunately, this does currently allow the capture of the customer number or variant codes, if used.  But these could easily be added to the table so they can be reported on later.  Once the forecast is loaded, the Planning Worksheet can then be used to run MRP/MPS to create production or purchase orders as needed.

    ------------------------------
    David Wiser
    Project Manager
    Tigunia
    Seattle WA
    ------------------------------



  • 3.  RE: Demand and Inventory Forcasting

    Posted 14 days ago
    Thanks you David for the feedback, I will try to use the above and see what it gives.

    Secondly possible for Nav to give me the sales forecast based on Sales which have happened for me to Measure against what Sales Department Have given Out. this is to Avoid Overstocking or Under Stocking.


    ------------------------------
    Stanislaus Banda
    Head Of Supply Chain And ICT
    Osho Chemical Industries ltd
    Nairobi
    ------------------------------



  • 4.  RE: Demand and Inventory Forcasting

    GOLD CONTRIBUTOR
    Posted 14 days ago
    Stanislaus-

    Unfortunately base NAV does not have any logic built it to look at historical data and make suggestions.  It only see the forecast and actual demands.  The BC product has some Item Forecast AI that incorporates these details.  I have not tested to the point to discuss the functionality in detail, but I have seen the theoretical capabilities and they look like they would meet your need.  I recently did some research and there are some ISV planning tools out there.

    Please share how you solve this challenge with the group.  This is an interesting one.

    ------------------------------
    Jason Nicolaou
    Engagement Manager
    Sikich, LLP
    ------------------------------



  • 5.  RE: Demand and Inventory Forcasting

    TOP CONTRIBUTOR
    Posted 13 days ago
    There is an extension for the latest version of BC call Sales and Inventory Forecast which purports to provide forecasting based on past sales.  I have worked with it a little and it is tricky to configure properly, but seems to work.  The problem is that it doesn't feed into the Demand Forecast table so BC can use the full planning functions.  But still, something to look at.

    ------------------------------
    David Wiser
    Project Manager
    Tigunia
    Seattle WA
    ------------------------------



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