commit c2caae53dd93219b7cafb2a75dbf9b37b2f508e2
author Nabin Hait <nabinhait@gmail.com> Wed Oct 23 12:02:08 2013 +0530
committer Nabin Hait <nabinhait@gmail.com> Wed Oct 23 12:02:08 2013 +0530
tree f349acaf25998c521e6aeed3d3b9be730432a481
parent 4ed7f6834452f97b0f15c83ee0ac346217a7208e

[utility] repost stock

utilities/repost_stock.py

diff --git a/utilities/repost_stock.py b/utilities/repost_stock.py
index e2ecdee..136a762 100644
--- a/utilities/repost_stock.py
+++ b/utilities/repost_stock.py
@@ -16,7 +16,7 @@
 	for d in webnotes.conn.sql("""select distinct item_code, warehouse from 
 		(select item_code, warehouse from tabBin
 		union
-		select item_code, warehouse from `tabStock Ledger Entry`)"""):
+		select item_code, warehouse from `tabStock Ledger Entry`) a"""):
 			repost_stock(d[0], d[1])
 		
 	webnotes.conn.auto_commit_on_many_writes = 0