commit 232ad777c9316888210f59e24494f57e5ad2e90c
author Nabin Hait <nabinhait@gmail.com> Tue Aug 04 11:21:54 2015 +0530
committer Nabin Hait <nabinhait@gmail.com> Tue Aug 04 11:40:38 2015 +0530
tree 0cb236918ebbdfb2ee781b77ded91fbbf78e157b
parent 7edb951fdb4d2a46614fae94e4772a8854dc3aac

[fix][patch] Remove fifo stack entry if qty after transaction is zero via stock reconciliation

erpnext/patches.txt

diff --git a/erpnext/patches.txt b/erpnext/patches.txt
index 961d97e..761f1a9 100644
--- a/erpnext/patches.txt
+++ b/erpnext/patches.txt
@@ -187,3 +187,4 @@
 erpnext.patches.v5_4.set_root_and_report_type
 erpnext.patches.v5_4.notify_system_managers_regarding_wrong_tax_calculation
 erpnext.patches.v5_4.fix_invoice_outstanding
+execute:frappe.db.sql("update `tabStock Ledger Entry` set stock_queue = '[]' where voucher_type = 'Stock Reconciliation' and ifnull(qty_after_transaction, 0) = 0")
\ No newline at end of file