IN OUR BUSINESS WE WILL CARRY 900+ SKUS A YEAR,WITH 800+ OF THEM SPECIFIC LOT TRACKED, A GOOD DEAL OF THEM WITH MORE THAN ONE LOT#. WE HAVE A SIMPLE WAREHOUSE SET UP - REQUIRE PUT AWAY, REQUIRE PICK, BIN MANDATORY. IN THE PUT AWAY DOCUMENT A RELATIONSHIP IS BUILT OR FIXED BETWEEN THE ITEM, THE SPECIFIC LOT#, AND THE STORAGE BIN. WHEN SELLING THE ITEMS, THAT FIXED RELATIONSHIP IS NOT OBVIOUS. IF YOU PICK A SPECIFIC LOT, THE PROGRAM DOES NOT LIMIT PICK FROM BINS TO THE BINS THAT CONTAIN ONLY THAT LOT. RATHER, ALL BINS WITH THE ITEM NUMBER ARE AVAILABLE FOR CONSIDERATION. IF I PICK A SPECIFIC BIN FIRST AND THEN MY ITEM TRACKING LINES, THE BIN DOES NOT LIMIT THE ITEM TRACKING LINES TO ONLY WHAT IS IN THAT PARTICULAR BIN, BUT ALL LINE TRACKING LINES AVAILABLE ACCORDING TO ITEM NUMBER ARE SHOWN. THIS LEADS TO ERRORS AND SOME DISAPPOINTING LOT TRACKING RESULTS. IS THERE A WAY TO MAINTAIN THE RELATIONSHIP BUILT IN THE INVENTORY PUT AWAY SO THAT ONLY APPROPRIATE LOT/BIN COMBINATIONS SHOW IN THE SALES ORDER? IS THERE A SET UP THAT ALLOWS THE ITEM LOT# TO BE VIEWED IN A BIN?
THANKS FOR YOUR HELP.