Hi,We're using Lanham's "Outbound Warehouse Request" with a large warehouse, barcoding, hundreds of skus, and bins with lot tracking and expiration dates.However, a pick, of about 20 orders (which can vary in size) takes around 10-20 minutes and deadlocks NAV and sometimes it deadlocks meaning the pick selected must start over.Have pickers and our new 2.2 Insight Works handhelds and packers just hanging out waiting for picks to be created.Recently made to code changes to the program to not look at all reservation entries each time:
CU 7312 TableData Whse. Item Tracking Line=rimd
CU 50098BinContent.SETCURRENTKEY("Location Code","Item No.","Variant Code","Bin Type Code"); //J.74
We use Lanham OWR as well and have found it to be a valuable tool. There are places that I have modified to reduce locking / io which has helped a great deal.I don't like the Bin.Empty boolean, so I only maintain it for our "RESERVE" bins. In Codeunit 7301, function InsertWhseEntry, I have put an IF statement to only update Bin.Empty for our Bin."Bin Type Code" of "RESERVE". I don't care that our SHIP, RECEIVE, or PICK Homes have a BIN Code of Empty. It's the Bin Content you care about anyway. the CALCSUMS("Qty. (Base)) slows the system down.In our system, we always have a number of locks in the Warehouse Request table. My only thought on this is that the Warehouse Request table is so small, there are a lot of records in a Page. If lock escalation locks a page, then a larger number of rows are locked. Just my 2 cents.
If you've found this thread useful, dive deeper into User Group community content by role