Open Forum

Expand all | Collapse all

Lot Number by bin table

  • 1.  Lot Number by bin table

    Posted May 24, 2021 06:07 PM
      |   view attached

    I am attempting to write a jet report using Lot Number by bin information. Does anyone know what table that information is on? Or what tables are able to be combined?


    Schrell Tipton
    Manufacturing Manager
    Ellsworth Corporation
    Germantown WI

  • 2.  RE: Lot Number by bin table

    Posted May 25, 2021 08:06 AM
    The table you are looking for is Warehouse Entry.  This will have your item no., Location, Bin and Qty. (Base).  However, unlike the item ledger entry table, there is not a remaining quantity field so you'll have to sum since the dawn of time to get your totals.

    Mark Buckingham
    Signature Systems Group, LLC
    Flower Mound TX

  • 3.  RE: Lot Number by bin table

    Posted Jun 08, 2021 10:56 AM
    Edited by Abram Towle Jun 10, 2021 12:05 PM
    Additionally, Inventory Overview has Bin and Lot information as well. It can show Qty Picked, which is a nice addition if you wanted to see that information.

    Edit: I realized that Inventory Overview is an add-on table, so please disregard.

    Abram Towle
    Continuous Improvement Analyst
    Ortho Molecular Products, Inc
    Milwaukee WI

If you've found this thread useful, dive deeper into User Group community content by role