details: /erp/devel/pi/rev/55a53776503a
changeset: 7831:55a53776503a
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Fri Jul 09 15:17:03 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.
Root cause:
'Creates invoices from order' window retrieves records from
C_INVOICE_CANDIDATE_V view. There, we have HAVING clause that restricts sales
orders if it's net amount is 0.
Solution:
The condition in HAVING clause has been modified in order to allow
zero-amounted sales order.
diffstat:
src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 07813f3009e7 -r 55a53776503a
src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
--- a/src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml Thu Jul 08
23:41:54 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml Fri Jul 09
15:17:03 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) * l.priceactual) <> 0 OR
sum((l.qtydelivered - l.qtyinvoiced) * l.priceactual) <> 0) sq
+HAVING sum(l.qtyordered - l.qtyinvoiced) <> 0 OR sum((l.qtydelivered -
l.qtyinvoiced) * l.priceactual) <> 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
