To whom can help me,
I am trying to calculate a cost for stock that ages dynamically depending on the period selected. I have attached an example qv file to work with.
I know what I want to do, just not quite sure how to do it in QV. Here is the data and an example of how it should be calculated:
if period 201112 is selected then the calculation is as follows:
Quantity on hand is 118
So it start latest first i.e. 53*1206.28=63932.84
then 2*39.82=79.64
then 4*19.91=79.64
then 20*13.05=261
then 10*12.50=125
then 10*12.05=120.50 (Although the quantity is 90, the remainder is 10, therefore that is the final outstanding qty for the calc)
total cost is 64598.62
If period 201112 is selected then the same calc must be perfomed dynamically which normally yields a different result(as you select older periods the cost changes.
The report n the QV file has a report where the current cost of 118*700 = 82600
So the difference between the current cost and aged cost is 82600-64598.62=18001.38
I hope i have explained the situation clearly enough to help me.
Many Thanks
Gary
