Stock Calculation

S

Shah Alam

Suppose,
ProductionDate Production Op Balance DelDate Party Qnty Cl.
Balance
1.1.09 500 500 2.1.09
Leon 300 200
2.1.09 500 700 -----
---- ---- 700
3.1.09 500 1200 ------
---- 1200
4.1.09 ---- 1200 4.1.09
David 500 700
5.1.09 --- 700 5.1.09
Mahi 300 400

Note that in case of only DelDate that follows by Production date.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested If conversion to Select case 5
How to keep track of transaction and calculation? 0
Calculated Item causes undue repitition in pivot table 2
MACRO OR FORMULA NEEDED FOR CALCULATION 2
select record before and after, then calculate average. 5
Matching two spreadsheets 2
Complex problem in calculating when to order an item 1
Solver problem 4

Top