details: https://code.openbravo.com/erp/devel/pi/rev/a7227d12e46e
changeset: 16609:a7227d12e46e
user: Jon AlegrÃa <jon.alegria <at> openbravo.com>
date: Wed May 23 19:44:01 2012 +0200
summary: Fixes issue 0020576: Generate invoices manual shows more that one
order
depending on the taxes of the order line
Removed the group by order line tax fields
diffstat:
src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 54c23859baeb -r a7227d12e46e
src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
--- a/src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml Wed May 23
16:25:30 2012 +0200
+++ b/src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml Wed May 23
19:44:01 2012 +0200
@@ -12,7 +12,7 @@
WHERE (o.docstatus IN ('CO', 'CL', 'IP')) AND (o.c_doctype_id IN (SELECT
c_doctype.c_doctype_id
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))) AND ((l.qtyordered -
l.qtyinvoiced) <> 0 OR (l.qtydelivered - l.qtyinvoiced) <> 0)
-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) sq
+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,
o.invoicerule, o.m_pricelist_id, c.c_currency_id) 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>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
