commit d4c5a9e2c42df6c134b8cee09152dea2bd9e4f4a
author Nabin Hait <nabinhait@gmail.com> Mon Apr 30 11:50:34 2012 +0530
committer Nabin Hait <nabinhait@gmail.com> Mon Apr 30 11:50:34 2012 +0530
tree 04c296064db1495ef681b21b17edb56930b4386d
parent 3e8f35c09e40ae211f69cc2c8fa97133ebcdaec4

fixes in bin

erpnext/stock/doctype/bin/bin.py

diff --git a/erpnext/stock/doctype/bin/bin.py b/erpnext/stock/doctype/bin/bin.py
index 1c2b53e..da9eafd 100644
--- a/erpnext/stock/doctype/bin/bin.py
+++ b/erpnext/stock/doctype/bin/bin.py
@@ -326,7 +326,7 @@
 		
 		# update the bin
 		if sll or not prev_sle:
-			sql("update `tabBin` set valuation_rate=%s, actual_qty=%s, stock_value = %s where name=%s", \
+			sql("update `tabBin` set valuation_rate=%s, actual_qty=%s, stock_value = %s, projected_qty = (actual_qty + indented_qty + ordered_qty + planned_qty - reserved_qty) where name=%s", \
 				(flt(val_rate), cqty, flt(stock_val), self.doc.name))