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.
Solved
Production Work Order in Released
Best answer by lauraj46
Hi
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.
+8Hi
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.
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
1 person likes this
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.
William J Matthews
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.