| # Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. | |
| # License: GNU General Public License v3. See license.txt | |
| from __future__ import unicode_literals | |
| def execute(): | |
| import webnotes | |
| from stock.stock_ledger import update_entries_after | |
| res = webnotes.conn.sql("select distinct item_code, warehouse from `tabStock Ledger Entry`") | |
| i=0 | |
| for d in res: | |
| try: | |
| update_entries_after({ "item_code": d[0], "warehouse": d[1]}) | |
| except: | |
| pass | |
| i += 1 | |
| if i%100 == 0: | |
| webnotes.conn.sql("commit") | |
| webnotes.conn.sql("start transaction") |