Can someone give advice on creating a GI that would allow a user to search a finished good lot number and see the raw material used to create that lot? Currently we do this by using a different GI to find the production order number and move transaction associated with the lot, then going to the Events tab of the production order, finding the move transaction, then opening the material transaction that was created at the exact same time. I see the move number listed on the Material transaction under ‘Orig Batch Nbr’ so I’ve tried to creating various GIs using AMBatch, AMProdEvnt, AMMTran to at least create a simplified path to the information we need, but I was unable to get a material transaction to show up for every finished good lot even though I can find them manually by the process described above. Our VAR sent us a GI linking AMProdItem to INTran and INTran to INTranSplit, but that still didn’t do what we needed it to.
Does anyone know how to either get a GI to display all move transactions with their associated material transactions or better yet a GI that would allow us to search a finished good lot number and see the specific raw material lot numbers used to create it?
This is my current basic version that pulls the material transaction for some finished good lots, but not all:
