thunder_anger
Board Regular
- Joined
- Sep 27, 2009
- Messages
- 206
Hi to all of you and good morning
I have an issue here
I want to calculate the cost of sold items according to the stock and the price according to date
<tbody>
</tbody>
If I sold 100 unit of the product coded 301 I want it to calculate the price as follows
3*0.85 + 15*0.6 + 20*0.5 + 62*0.25
Is that possible
I have an issue here
I want to calculate the cost of sold items according to the stock and the price according to date
Code | QTY | U. Price | Date |
301 | 3 | 0.85 | 01/01/2012 |
301 | 15 | 0.6 | 06/01/2012 |
301 | 20 | 0.5 | 13/01/2012 |
402 | 50 | 4.5 | 06/05/2012 |
402 | 30 | 2.5 | 06/06/2012 |
305 | 120 | 2.5 | 1/1/2013 |
301 | 100 | 0.25 | 01/01/2013 |
385 | 25 | 25 | 1/1/2013 |
310 | 25 | 25 | 1/1/2013 |
301 | 25 | 1.1 | 6/2/2013 |
320 | 222 | 0.3 | 6/2/2013 |
<tbody>
</tbody>
If I sold 100 unit of the product coded 301 I want it to calculate the price as follows
3*0.85 + 15*0.6 + 20*0.5 + 62*0.25
Is that possible