I am trying to generate a list of lots or serial numbers that are currently on the Production Order. I have AMProdItemSplit in the Production ticket at this time but I can only seem to get one Lot or Serial number to print.
This is my first time trying to print a collection of data and I am try to determine the best way. Anyone have any pointers or help articles for this? Attached is my rpx as well.
hi
Looking at the DAC schema browser, it doesn’t use a lot number until the production order is moved & inventory consumed at which point the lot nbr is allocated.
Aleks
They are assigned on a Production Order on the Line Details tab. I can capture the first lot or serial that is listed but I can’t seem to figure out how to get the full list pulled into my Production Ticket.
For your join on your schema, try joining on OrderType = OrderType, ProdOrdID = ProdOrdID.
And try the join type as Inner.
Aleks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.