Raw Lot Material Trace to Finished Good

Hi ​@jschiele ,

the key field you're missing is AMMTranSplit.ParentLotSerialNbr, which directly links raw material lots to the finished good lot.

Parameter: AMMTranSplit.ParentLotSerialNbr (this is your finished good lot search field)
Result columns:
- AMProdItem.ProdOrdID — Production Order
- AMMTranSplit.ParentLotSerialNbr — FG Lot
- AMMTran.InventoryID — Raw Material Item
- AMMTranSplit.LotSerialNbr — Raw Material Lot
- AMMTranSplit.Qty — Qty Consumed

No need to go through Events tab, timestamps, or INTran. ParentLotSerialNbr on AMMTranSplit is the direct link between the finished good lot and the raw material lots consumed during backflush.
For reverse lookup (raw material lot → which finished goods used it), just filter on AMMTranSplit.LotSerialNbr instead.

Hope above helps!!

Hi Rakshanda,

Thank you so much for taking the time to reply! Unfortunately this didn’t work for me. Only 200 parent lot/serial numbers showed up in the report out of over 100K records and none were lots we had produced since go live, so I’m unsure what exactly it’s pulling there. Is there something off about the way I’ve reconstructed the report or anything else I can try?

HI ​@jschiele ,

The ParentLotSerialNbr approach only works if you have Preassign Lot/Serial enabled on your production orders. For most setups (especially backflush), that field is empty — which explains why you only see ~200 records.
Alternative GI approach using the Move → Material batch link:

AMBatch.MaterialBatNbr is the key — it links the move batch to the material batch created during backflush.
Parameter: MoveSplit.LotSerialNbr (your finished good lot search)
Result columns:
- MoveTran.ProdOrdID — Production Order
- MoveSplit.LotSerialNbr — FG Lot
- MatlTran.InventoryID — Raw Material Item
- MatlSplit.LotSerialNbr — Raw Material Lot
- MatlSplit.Qty — Qty Consumed
- Move.BatNbr — Move Batch
- Matl.BatNbr — Material Batch
If some material is issued manually (not backflush), MaterialBatNbr won't capture those. For manual issues, you'd need a separate GI joining AMMTran (DocType = "M") directly to AMProdItem via OrderType/ProdOrdID, then linking the production order's lot to the material lot.

if possible please share your GI XML

Hope above helps!!

I tried your suggestions and some variations, but the best I can seem to get is seeing the finished good lots, inventory ids, and move batches but the columns for raw material, raw material lot/ser nbr, and qty consumed are empty. Every lot we produce should backflushes material. I’ve attached the XML from the two different GI attempts if that helps. The second called ‘LotMaterialIssued’ gets perhaps even closer but for some reason it is missing almost all of our most common production order types from our go live in November up to this month. There’s no condition I can see that should be causing this. Thank you again so much for your time, I really appreciate it.

I actually think I see that materials are not showing up on the LotMaterialIssued report when it is set to ‘Bachflush FIFO’ instead of just ‘Backflush’ which I believe is a custom field added by our VAR. I would love anyone’s input/help on this.