Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Partial Picks on Released Production Orders

Posted on by 5,124

Hello Experts,

We just went Live with our Manufacturing module in NAV 2013.  But we ran into problems registering partial picks on Released Production Orders.  The first time through with partial picks, everything went well.  But the second time we tried to register partial picks, we errored out: "The Total Item Tracking Quantity 5 exceeds the prod. order component quantity 2.  The changes cannot be saved to the database".  Note that the #5 is the quantity in the pick take and place while #2 value is the qty to handle in take and place.  Thoughts?

*This post is locked for comments

  • Verified answer
    mbr Profile Picture
    mbr 5,124 on at
    RE: Partial Picks on Released Production Orders

    Hi Suresh.  I think this is a known bug in NAV.  This was reported in NAV 2005 whereby partial picks DO NOT work properly for transfer lines.  In our case, we are working with production orders and performing a warehouse pick on Released Production Order.

    Anyway, I fixed the "bug" in codeunit 6500.  For those that are interested below is my fix:

    problem: when item lot tracking is turned on and users create warehouse pick on a released production order (Manufacturing module), partial picks do not work.

    Resolution:

    In the 6500 Item Tracking Management Codeunit, modify the ItemTrkgQtyPostedOnSource function. Add the code snippet from //Mbr 001 -start to //MBR 001 - end

     IF NOT ReservEntry.ISEMPTY THEN BEGIN

       ReservEntry.FINDSET;

       REPEAT

         Qty += ReservEntry."Qty. to Handle (Base)";

       UNTIL ReservEntry.NEXT = 0;

     END;

     IF "Source Type" = DATABASE::"Transfer Line" THEN BEGIN

       TransferLine.GET("Source ID","Source Ref. No.");

       Qty -= TransferLine."Qty. Shipped (Base)";

     END;

     //MBR 001 - start

     IF "Source Type" = DATABASE::"Prod. Order Component" THEN BEGIN

      ProdComp.SETRANGE("Prod. Order No.",SourceTrackingSpec."Source ID");

      ProdComp.SETRANGE("Prod. Order Line No.",SourceTrackingSpec."Source Prod. Order Line");

      ProdComp.SETRANGE("Item No.",SourceTrackingSpec."Item No.");

      IF ProdComp.FINDSET THEN

            Qty += ProdComp."Expected Qty. (Base)";

     END;

     //MBR 001 - end

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Partial Picks on Released Production Orders

    Check the Item Tracking Lines for the Lines and try updating the Qty. to Handle on the Tracking Lines to match the Pick Qty.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans