Inventory Pick trick

ShenpenShenpen Member Posts: 386
edited 2005-06-09 in NAV Tips & Tricks
Inventory Pick and Put-Away was really a big idea in 3.7: before that, the only way to have Bins was to implement full WMS which is really a complicated stuff. Inventory Picks are really simple and easy to use, suitable to many companies.

But there is problem: you cannot have a pickink route by bin rankings.

The trick is, that if you comment out some code in codeunit Create Inventory Pick then at least you can have a picking route by Bin Code sequences (alphanumerical or numerical), so you can set up Bin Codes to picking route order. Here it is:


Commented out lines from InsertPickLine:

SETCURRENTKEY(Default,"Location Code","Item No.","Variant Code","Bin Code");
//SETRANGE(Default,DefaultBin);
SETRANGE("Location Code",NewWhseActivLine."Location Code");
SETRANGE("Item No.",NewWhseActivLine."Item No.");
SETRANGE("Variant Code",NewWhseActivLine."Variant Code");
//IF BinCode <> '' THEN
//SETRANGE("Bin Code",BinCode);


Of course programing Bin Rankings here is a much nicer solution, but it is an easy one to do.

Do It Yourself is they key. Standard code might work - your code surely works.

Comments

  • krikikriki Member, Moderator Posts: 9,110
    SETCURRENTKEY(Default,"Location Code","Item No.","Variant Code","Bin Code"); 
    //SETRANGE(Default,DefaultBin); 
    SETRANGE("Location Code",NewWhseActivLine."Location Code"); 
    SETRANGE("Item No.",NewWhseActivLine."Item No."); 
    SETRANGE("Variant Code",NewWhseActivLine."Variant Code"); 
    //IF BinCode <> '' THEN 
    //SETRANGE("Bin Code",BinCode);
    

    One small problem with this: it scans the whole table! This because the first field in the key (="Default") has no SETRANGE on it.
    You should use or create another index to avoid that Navisions scans the whole table.
    Something Like
    [code]SETCURRENTKEY("Location Code","Item No.","Variant Code","Bin Code");
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • ShenpenShenpen Member Posts: 386
    Thank you... I am completely embarrassed... :) Maybe I had a hangover or something :)

    Do It Yourself is they key. Standard code might work - your code surely works.
Sign In or Register to comment.