[fix] [minor] price list patch
diff --git a/patches/september_2013/p03_modify_item_price_include_in_price_list.py b/patches/september_2013/p03_modify_item_price_include_in_price_list.py
index f29f8f5..8ca6d76 100644
--- a/patches/september_2013/p03_modify_item_price_include_in_price_list.py
+++ b/patches/september_2013/p03_modify_item_price_include_in_price_list.py
@@ -7,11 +7,13 @@
def execute():
webnotes.reload_doc("setup", "doctype", "price_list")
webnotes.reload_doc("setup", "doctype", "item_price")
+ webnotes.reload_doc("stock", "doctype", "item")
+
webnotes.conn.sql("""update `tabItem Price` set parenttype='Price List',
- parentfield='item_prices', item_code=parent""")
-
+ parentfield='item_prices', `item_code`=`parent`""")
+
# re-arranging idx of items
- webnotes.conn.sql("""update `tabItem Price` set parent=price_list, idx=0""")
+ webnotes.conn.sql("""update `tabItem Price` set `parent`=`price_list`, idx=0""")
for pl in webnotes.conn.sql("""select name from `tabPrice List`"""):
webnotes.conn.sql("""set @name=0""")
webnotes.conn.sql("""update `tabItem Price` set idx = @name := IF(ISNULL( @name ), 0, @name + 1)