details: /erp/devel/pi/rev/b4fdc3108285
changeset: 7875:b4fdc3108285
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Tue Jul 13 16:45:44 2010 +0530
summary: Fixes issue 13869: If an order has a 100% discount so the total is
100 this order can not be selected in the process to generate invoices
As it is agreed that sales orders net amount could be 0, l.priceactual is
removed from both the conditions
diffstat:
src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r c80022d61c9c -r b4fdc3108285
src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
--- a/src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml Tue Jul 13
13:02:59 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml Tue Jul 13
16:45:44 2010 +0530
@@ -13,7 +13,7 @@
FROM c_doctype
WHERE c_doctype.docbasetype = 'SOO' AND (c_doctype.docsubtypeso NOT IN ('ON',
'OB', 'WR')))) AND (o.invoicerule = 'I' OR o.invoicerule = 'O' OR o.invoicerule
= 'N' OR o.invoicerule = 'D' OR o.invoicerule = 'S' AND (si.invoicefrequency IS
NULL OR si.invoicefrequency = 'D' OR si.invoicefrequency = 'W' OR
si.invoicefrequency = 'T' AND trunc(o.dateordered) <= (TRUNC(now(), 'MM') +
si.invoicedaycutoff - 1) AND trunc(now()) >= (TRUNC(o.dateordered, 'MM') +
si.invoiceday - 1) OR trunc(o.dateordered) <= (TRUNC(now(), 'MM') +
si.invoicedaycutoff + 14) AND trunc(now()) >= (TRUNC(o.dateordered, 'MM') +
si.invoiceday + 14) OR si.invoicefrequency = 'M' AND trunc(o.dateordered) <=
(TRUNC(now(), 'MM') + si.invoicedaycutoff - 1) AND trunc(now()) >=
(TRUNC(o.dateordered, 'MM') + si.invoiceday - 1)))
GROUP BY o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_id,
o.documentno, o.dateordered, o.c_doctype_id, o.totallines, o.grandtotal,
l.c_tax_id, o.invoicerule, o.m_pricelist_id, c.c_currency_id
-HAVING sum(l.qtyordered - l.qtyinvoiced) <> 0 OR sum((l.qtydelivered -
l.qtyinvoiced) * l.priceactual) <> 0) sq
+HAVING sum(l.qtyordered - l.qtyinvoiced) <> 0 OR sum(l.qtydelivered -
l.qtyinvoiced) <> 0) sq
JOIN m_pricelist p ON sq.m_pricelist_id = p.m_pricelist_id
JOIN c_currency c ON sq.c_currency_id = c.c_currency_id]]></view>
</database>
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
