Inventory Pick trick

Shenpen

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.

kriki

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");

Shenpen

Thank you... I am completely embarrassed... Maybe I had a hangover or something