Hi,
I am struggling to find a simple way to track inventory movements and match with valuations in a multi BOM environment. I am curious as to how anybody may be doing something similar if anyone has recent experience? The company runs on average cost and has a fairly complicated manufacturing environment. Some reports give value but not qty and stock movements would give you end qty but with movements from beginning of time. I feel like I am missing a trick somewhere.
thanks!

thank you - it is a great suggestion. It will take some work due to the multiple layers of BOMS - i.e. some BOMS are sub assemblies of other BOMS etc.
Thank you for the feedback