This is a tool designed to handle lot reassignments on a group of totes.   It is rarely used but in the case where a shift has been packed under the wrong item number, this tool can do a speedy remedy of such.  There are several portions of the package, to do different parts of re-assigning totes.


Reassign Totes will actually send the transactions to TEE.   You will need to edit the SQL to pick the correct totes:





The portion to Ticket Print  will send a file to the ticket print app.  SQL will also need to be adjusted.   This can be useful when needing to reprint a bunch of tickets as it will create the files to be sent to bartender.    When the location needs to recreate tickets for a group of totes ticketed in error, this can be a very helpful tool.






"Year Code" will set en_lot_ext with the appropriate Y code.  Again, SQL will need to be edited.   The Y code is heavily used so having it set for the new combination item/tote# will be needed.  If you need to do a lot reassignment, this step will be necessary or the users won't see the totes on the inventory spreadsheet page that filters by Year Code.




"delete old ext" will take out the en_lot_ext records for the "from" totes on the re-assignment.  This is not necessary, but good to keep the data cleaned up.  Again, editing the SQL will be necessary