What tables are involved with Lot #’s in Inventory

plumbline consulting

List of tables used by various modules when lot/serial numbering is used:

1. Lot numbers can be assigned at Receipt or Issue

2. Quantities for Lots are held in LotSerMst (what you seen in Lot/ser screen), Location (what you see in location screen)

3. LotSerT table ties Lot numbers to batches. They have ties to INTRAN by batnbr and lineref, they are released when the intran is released. They are created when the batch is created (Receipt batch if “Issue on Receipt”)

4. SOShipLot is where lot# information stored for Sales Orders

5. INTRAN and LOTSERT are bound by batnbr,cpnyid,site, trantype, Intran.lineref=lotsert.intranlineref, intran.lineid=lotsert.intranlineid