Need help writing a query to show the component cost of a production order, using moving average valuation method.
I understand the table oinm has all history for an item and its calculated price.
would like to query a production order to show the cost of components at the time of receipt of that production order.
ideas?