Planning Worksheet suggests over-supplying production

  • Planning Worksheet suggests over-supplying production

    Posted by DSC Communities on February 10, 2017 at 9:54 am
    • Mike Swann

      Member

      February 10, 2017 at 9:54 AM

      Hi All,

      We’ve come across a potentially strange situation in Nav which I could do with some help on.  Apologies in advance if this is down to a lack of my understanding!

      We are a manufacturing company who employ subcontract screen printers.  We have a situation with Nav currently that we have to change the production order status to Released in order for the Subcontract worksheet to pick up the Production Order and create the purchase order.  

      For this Subcontractor this means creating a Released Production Order 6 weeks in advance, so that we can raise the Purchase Order and reserve a slot in their factory.  

      We have also had the customer come back and ask to move the order forward a week, which we can now do as we will have completed production by then.  

      This is where we run in to a problem – If we run the Planning worksheet it suggests creating a new Production Order for this item.  I assume this is because the Production order is now released and therefor it cannot reschedule/delete the Order.  However, if we followed this suggestion we would end up with stock of a bespoke customer product which we can’t sell.  So my question is, assuming we haven’t mistakenly configured things in Nav, how would you pick this up?  We have caught this because it was a new customer and the operator in the Planning department knew there was only 1 order, if this was a bigger, existing customer this could be missed entirely.

      Has anyone else come across this situation?

      Thanks in advance for any help!

      Mike

      ——————————
      Mike Swann

      ——————————

    • Bob Bergman

      Member

      February 13, 2017 at 6:16 AM

      Hi,

      I tested this in a NAV 2016 DB and it worked correctly suggesting a reschedule.  I think that your setup on the Planning Fast Tab for the Subcontracted Item may need some changes.

      But I did run in to another concern:

      When I ‘Carried Out Action Message’ to reschedule, it rescheduled the Production order, but not the purchase Order.

      Bob

      ——————————
      Bob Bergman
      President
      REB Dynamics Consulting
      Port Charlotte FL
      ——————————
      ——————————————-

    • Mike Swann

      Member

      February 13, 2017 at 8:03 AM

      Hi Bob,

      Thanks for your reply.  I have done a bit more testing here based on what you have said.  We have very minimal modification to our Nav and the planning process is standard, so something else must be going on!  

      I’ve followed the changes in our system through, running the planning worksheet each time.  Nav will suggest rescheduling our production order every step of the way (Firm Planned PrO, Planned PrO, Raise Subcontract PO), except after a consumption.  This product is actually made from off-cuts of another product, so the material has been consumed already.  Now that there is an item ledger entry against the Production Order the planning window seems to be completely ignoring the existing order.  Does this behavior make sense to you?

      Thanks in advance for your help,

      Mike

      ——————————
      Mike Swann

      ——————————
      ——————————————-

    • Rick Dill

      Member

      February 13, 2017 at 10:30 AM

      Hi Mike, without looking in detail at your example, let me share a concept that might explain what you are seeing.

      Are you using Lot for Lot, and if so are you using the Lot Accumulation and Rescheduling Period? The lot accumulation groups days into a single period (creates a week long bucket for example). the rescheduling period defines a window of time that NAV will reschedule rather than suggest a cancel and new.

      The final point is that NAV will never let inventory fall below zero or safety stock so if it is within your items lead time NAV will suggest an emergency order rather than a reschedule message.

      ——————————
      Rick Dill
      Consultant
      ArcherPoint Inc.
      Waupaca WI
      ——————————
      ——————————————-

    DSC Communities replied 8 years, 7 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Planning Worksheet suggests over-supplying production’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!