- 1. stf transactions (data entry) over the intranet had problems when solomon tries to do a "release now" action.
- 2. further analysis by LPE shows that the intranet module hasn't completely emulated the "transfers" transaction of solomon, in that the items transferred did not have corresponding serialized entries in LotSerT
- 3. relations: Batch 1:1 TrnsfrDoc, Batch 1:n INTran, INTran 1:n LotSerT
- 4. look up for LotSerT.LotSerNbr will come from LotSerMst (where all serialized items are built up)
SELECT LotSerNbr FROM LotSerMst WHERE InvtId='1002122' AND SiteId='LOG-MCS' AND Status = 'A' AND WhseLoc='MAIN' AND QtyOnHand > 0 ORDER BY LotSerNbr ASC