details: https://code.openbravo.com/erp/devel/pi/rev/5cb014ebb804 changeset: 19010:5cb014ebb804 user: Naiara Martinez <naiara.martinez <at> openbravo.com> date: Wed Dec 12 11:30:34 2012 +0100 summary: fixed issue 22524: The document status is taking into account the discounts
diffstat: src-db/database/sourcedata/AD_COLUMN.xml | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diffs (22 lines): diff -r 7b227385bb5f -r 5cb014ebb804 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Tue Dec 11 22:15:20 2012 +0100 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed Dec 12 11:30:34 2012 +0100 @@ -285001,7 +285001,8 @@ <!--9E82E728716246B393C40D2CDCA0133A--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--9E82E728716246B393C40D2CDCA0133A--> <SQLLOGIC><![CDATA[(select case when sum(ol.qtyordered) = 0 then 0 else round(coalesce(sum(ol.qtydelivered), 0)/sum(ol.qtyordered) * 100, 0) end - from c_orderline ol where ol.c_order_id=c_order_id)]]></SQLLOGIC> + from c_orderline ol where ol.c_order_id=c_order_id and ol.c_order_discount_id is null + )]]></SQLLOGIC> <!--9E82E728716246B393C40D2CDCA0133A--></AD_COLUMN> <!--9E96300C46ED4928E040007F01006BD5--><AD_COLUMN> @@ -293119,7 +293120,7 @@ <!--B5B203AE8D674B8DABC6669419815CA7--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--B5B203AE8D674B8DABC6669419815CA7--> <SQLLOGIC><![CDATA[(select case when sum(ol.qtyordered) = 0 then 0 else round(coalesce(sum(ol.qtyinvoiced), 0)/sum(ol.qtyordered) * 100, 0) end -from c_orderline ol where ol.c_order_id=c_order_id)]]></SQLLOGIC> +from c_orderline ol where ol.c_order_id=c_order_id and ol.c_order_discount_id is null)]]></SQLLOGIC> <!--B5B203AE8D674B8DABC6669419815CA7--></AD_COLUMN> <!--B5B4E54AEAC82679E040007F01004CAA--><AD_COLUMN> ------------------------------------------------------------------------------ LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
