repost projected qty
diff --git a/patches/december_2012/repost_projected_qty.py b/patches/december_2012/repost_projected_qty.py
new file mode 100644
index 0000000..4e4f522
--- /dev/null
+++ b/patches/december_2012/repost_projected_qty.py
@@ -0,0 +1,5 @@
+def execute():
+ import webnotes
+ webnotes.conn.sql("""update `tabBin`
+ set projected_qty = ifnull(actual_qty, 0) + ifnull(indented_qty, 0) +
+ ifnull(ordered_qty, 0) + ifnull(planned_qty, 0) - ifnull(reserved_qty, 0)""")
\ No newline at end of file
diff --git a/patches/patch_list.py b/patches/patch_list.py
index c902e0d..ce03fb2 100644
--- a/patches/patch_list.py
+++ b/patches/patch_list.py
@@ -713,4 +713,8 @@
'patch_module': 'patches.december_2012',
'patch_file': 'repost_ordered_qty',
},
+ {
+ 'patch_module': 'patches.december_2012',
+ 'patch_file': 'repost_projected_qty',
+ },
]
\ No newline at end of file