Skip to main content

Once a Production Work Order is Released and we can see the LotSerialNbr in the Production Order Maintenance, where does that number actually reside, or is it a phantom number until the Production Work Order is completed? I have looked in AMMTran.LotSerialNbr, AMMTranSplit.LotSerialNbr, and AMProdItemSplit.LotSerialNbr and cannot find the same number in any of the DAC’s. Once the Production Work Order is Completed, all the numbers appear to be there, but we need to see them on the Released level, not Completed, which leads me to think that the number doesn’t really exists until Completion. Even useing a GI with the three DAC’s I mentioned above yields no records found.

Hi @wmatthews1877 ,

The Line Details on the Production Order Maintenance table are stored in the AMProdItemSplit DAC.  Are you certain that the serial numbers aren’t in this table?

If you have permissions, you can find the DAC and field for any screen element by using Customization-->Inspect Element, or a shortcut is Ctrl-Alt Left click.  


I figured it out by myself, and found the LotSerialNbr right where you stated. Once I found that it was easy enough to use MIN and MAX to get the starting number and ending number is what we needed. Thank you for your help.


Reply