commit f84237642e2595b62c9646916bcf31d799a70e68
author Nabin Hait <nabinhait@gmail.com> Wed Oct 03 14:51:42 2012 +0530
committer Nabin Hait <nabinhait@gmail.com> Wed Oct 03 14:51:42 2012 +0530
tree 46dbe18017f4a5e1b5c6ce6c52e44798c8f556fd
parent 1f33e46e344b90cde620a72978934cafed9d6b43

find wrong vouchers

patches/october_2012/find_wrong_voucher.py

diff --git a/patches/october_2012/find_wrong_voucher.py b/patches/october_2012/find_wrong_voucher.py
index ca612f3..189f2b6 100644
--- a/patches/october_2012/find_wrong_voucher.py
+++ b/patches/october_2012/find_wrong_voucher.py
@@ -2,7 +2,7 @@
 	import webnotes
 	from webnotes.utils import flt
 	vouchers = webnotes.conn.sql("""
-		select parent, parenttype, modified, sum(tax_amount) as tax from `tabPurchase Taxes and Charges`
+		select parent, parenttype, modified, sum(if(add_deduct_tax='Add', tax_amount, -tax_amount)) as tax from `tabPurchase Taxes and Charges`
 		where modified >= '2012-07-12'
 		and category in ('Total', 'Valuation and Total')
 		and parenttype != 'Purchase Taxes and Charges Master'