Open Forum

Expand all | Collapse all

NAV 2015 Allow Negative Inventory

  • 1.  NAV 2015 Allow Negative Inventory

    Posted 27 days ago
    ​​Hello,

    When we are processing our Production Orders, is it possible to have a negative inventory, we would like our inventory to go into the negative, we have it set up this way in our manufacturing set up as well as individually on our item cards, but when processing our Production Orders, it makes us do a positive adjustment for all items that may have a qty on hand = 0 before allowing us to consume them. Any help is appreciated.

    ------------------------------
    Lorna Campbell
    Triple M Housing
    Lethbridge AB
    ------------------------------


  • 2.  RE: NAV 2015 Allow Negative Inventory

    TOP CONTRIBUTOR
    Posted 27 days ago
    Are you using Forward or Backward Flushing on your components?  If so, this requires the Item be available prior to posting the output.

    ------------------------------
    Ben Baxter
    Consultant
    Accent Software, Inc.
    Carmel IN
    ------------------------------



  • 3.  RE: NAV 2015 Allow Negative Inventory

    Posted 27 days ago
    ​We are currently using manual flush.

    ------------------------------
    Lorna Campbell
    Triple M Housing
    Lethbridge AB
    ------------------------------



  • 4.  RE: NAV 2015 Allow Negative Inventory

    TOP CONTRIBUTOR
    Posted 20 days ago
    Is your inventory lot controlled?  NAV will not allow lot controller inventory to go negative.

    ------------------------------
    David Wiser
    Project Manager/Solution Architect
    Beck Consulting
    Kent WA
    ------------------------------



  • 5.  RE: NAV 2015 Allow Negative Inventory

    Posted 18 days ago
    Take a look at the Inventory Setup.   There is a Prevent Negative Inventory checkbox there.

    ------------------------------
    Mark Buckingham
    Signature Systems Group, LLC
    Flower Mound TX
    ------------------------------



  • 6.  RE: NAV 2015 Allow Negative Inventory

    NAVUG ALL STAR
    Posted 15 days ago

    Hi Lorna,

    Thank you for posting. I wanted to clarify a couple of things with standard NAV functionality. First, Lot Specific Tracking, Serial No. Specific Tracking, Transfers Shipment, Consumption for Manufacturing, Consumption for Assembly, certain Warehouse setup with the use of Bins and/or full Directed Put-away and Pick, where inventory is zero or insufficient remaining quantity to process a posting, the system will block the posting in standard NAV code.   The blocking in these scenarios mentioned will occur whether Prevent Negative inventory is checked in Inventory Setup or on the specific Item Card.

    The blocking of consumption into negative is primarily due to the costing dependencies of consumption on final rolled up production BOM cost, The Product Management team for NAV over the years has elected to not allow negative quantity on consumption. It would seem that your implementation partner possibly customized NAV to post a Positive Adjustment to enable the posting of consumption when insufficient quantity exists to record the consumption rather than blocking the consumption posting.

    It can be a challenging situation.  Using backward flushing using Routing Link codes to tie consumption to a later step in the Routing can sometimes help delay consumption to a specific routing process later in the manufacturing process. This would possibly help alleviate some of the attempted negative consumption posting using a more just-in-time approach.

    In the end, it would seem like the desired business process was determined in the implementation phase of you NAV installation that the company didn't want production interrupted by out stock component inventory and elected to use the customization to post Positive Adjustment quantity when necessary to meet required supply rather than block manufacturing consumption.

    Thanks for posting.



    ------------------------------
    Thomas (Tom) Blaisdell
    Sr. Support Escalation Engineer
    Microsoft
    Alpharetta GA
    ------------------------------