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
    Hi,

    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?

    Thanks,

    ------------------------------
    Schrell Tipton
    Manufacturing Manager
    Ellsworth Corporation
    Germantown WI
    ------------------------------


  • 2.  RE: Lot Number by bin table

    SILVER CONTRIBUTOR
    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