Hi,
Just wondering how do you pull out the previous moving average price for a goods return? We have scenario in which business want the valuation of the return to pick up the moving average price base on the relevant previous goods issue transaction.
For example:
1 - Sales of Goods issue (material A) on Dec 12, 2010 MAP price is USD 30 (mvmt 601)
2 - Sale of goods issue (material A) on Feb 11, 2011 MAP price is USD 42 (mvmt 601)
Now a goods return incurs today for the business transaction incurs on no. 1, and we would like the valuation incurs base on the no.1 transaction which is the USD30?
Possible to do this?
Thanks
Tuff