Hi all
There no idea coming to my mind to how to perform me. That is what I need.
Suppose I have purchase table with following data
Batch no. Quantity. Date.
1001. 100. 01/01/2014
1002. 50. 02/01/2014
Now supposingly sales as follows
Date. Quantity invoice no
05/01/2014. 125 1
10/01/3014...