Stock Calculation
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 |
Stock Calculation
What's the question?
Regards, Fred. "Shah Alam" <Shah wrote in message ... 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 |
All times are GMT +1. The time now is 07:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com