Attached example show Assembly A is linked to Part materials B and in turn to C and D. The reason only A – B – C – D are in importance are because they are either track serial number or track lot number on the part record. When the transaction get complete with job we would have recorded serial and lot number information.
We need a query to drill down from the top assembly serial number and trace all materials whose records set to track serial number or lot number with corresponding information.
We need a query to drill down from the top assembly serial number and trace all materials whose records set to track serial number or lot number with corresponding information.