View Finish Goods to Material OR Material to Finish Goods

Issue: How to trace a transaction from Front to end (Finish Goods to Material) OR end to Front (Material to Finish Goods)

*Please do not advise to use part transaction history tracker (this one is 1 to 1 transaction only)

Can I ask precisely what information you’re looking to analyze? Unless you’re serial-tracking your material parts there is precious little information beyond what is found in the PartTran table. JobMtl will show the total quantity issued. and SNTran will show any serialized part information, but out of the box that’s all I can think of.

Now that I reread your question, what you want to do is query the PartTran table. You can write a BAQ to give you that information.