details: https://code.openbravo.com/erp/devel/pi/rev/8fe053d8c26f
changeset: 22663:8fe053d8c26f
user: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at>
openbravo.com>
date: Mon Mar 10 18:13:58 2014 +0530
summary: Fixes Issue 25785: Wrong grandtotal in invoices when you void it
diffstat:
src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateGrandTotalData.class
| 0
src-util/modulescript/src/org/openbravo/modulescript/UpdateGrandTotal_data.xsql
| 4 ----
2 files changed, 0 insertions(+), 4 deletions(-)
diffs (37 lines):
diff -r e41a9ad232c6 -r 8fe053d8c26f
src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateGrandTotalData.class
Binary file
src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateGrandTotalData.class
has changed
diff -r e41a9ad232c6 -r 8fe053d8c26f
src-util/modulescript/src/org/openbravo/modulescript/UpdateGrandTotal_data.xsql
---
a/src-util/modulescript/src/org/openbravo/modulescript/UpdateGrandTotal_data.xsql
Mon Mar 10 12:49:47 2014 +0100
+++
b/src-util/modulescript/src/org/openbravo/modulescript/UpdateGrandTotal_data.xsql
Mon Mar 10 18:13:58 2014 +0530
@@ -41,7 +41,6 @@
FROM C_Invoice i
WHERE i.docstatus = 'VO'
AND i.totallines = '0'
- AND i.c_doctype_id = '0'
AND i.grandtotal <> '0'
)
)
@@ -59,7 +58,6 @@
FROM C_Invoice i
WHERE i.docstatus = 'VO'
AND i.totallines = '0'
- AND i.c_doctype_id = '0'
AND i.grandtotal <> '0'
)
]]>
@@ -77,7 +75,6 @@
FROM C_Invoice i
WHERE i.docstatus = 'VO'
AND i.totallines = '0'
- AND i.c_doctype_id = '0'
AND i.grandtotal <> '0'
)
]]>
@@ -91,7 +88,6 @@
SET grandtotal=0
WHERE i.docstatus = 'VO'
AND i.totallines = '0'
- AND i.c_doctype_id = '0'
AND i.grandtotal <> '0'
]]>
</Sql>
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
