details: https://code.openbravo.com/erp/devel/pi/rev/d38f82392f3a
changeset: 17707:d38f82392f3a
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Mon Aug 20 12:45:47 2012 +0200
summary: Fixes issue 20699: Some candidate orders can't be selected using the
Create Lines From button
diffstat:
src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (21 lines):
diff -r de48663576d7 -r d38f82392f3a
src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
--- a/src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml Mon Aug 20
12:02:56 2012 +0200
+++ b/src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml Mon Aug 20
12:45:47 2012 +0200
@@ -1,7 +1,7 @@
<?xml version="1.0"?>
<database name="VIEW C_INVOICE_CANDIDATE_V">
<view name="C_INVOICE_CANDIDATE_V"><![CDATA[SELECT sq.ad_client_id,
sq.ad_org_id, sq.c_bpartner_id, sq.c_order_id, sq.documentno, sq.dateordered,
sq.c_doctype_id, sq.amountlines, sq.amountlinesgross, sq.notinvoicedlines,
round(sq.notinvoicedlinesgross, c.stdprecision) AS notinvoicedlinesgross,
sq.term, sq.pendinglines, round(sq.pendinglinesgross, c.stdprecision) AS
pendinglinesgross, sq.qtyordered, sq.qtydelivered
-FROM (SELECT 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 AS amountlines,
o.grandtotal AS amountlinesgross, sum(round((l.qtyordered - l.qtyinvoiced) *
l.priceactual, c.stdprecision)) AS notinvoicedlines, sum(round((l.qtyordered -
l.qtyinvoiced) * l.priceactual, c.stdprecision) * (1 + t.rate / 100)) AS
notinvoicedlinesgross, o.invoicerule AS term, sum(round((l.qtydelivered -
l.qtyinvoiced) * l.priceactual, c.stdprecision)) AS pendinglines,
sum(round((l.qtydelivered - l.qtyinvoiced) * l.priceactual, c.stdprecision) *
(1 + t.rate / 100)) AS pendinglinesgross, sum(l.qtyordered) AS qtyordered,
sum(l.qtydelivered) AS qtydelivered, o.m_pricelist_id, c.c_currency_id
+FROM (SELECT 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 AS amountlines,
o.grandtotal AS amountlinesgross, sum(round((l.qtyordered - l.qtyinvoiced) *
l.priceactual, c.stdprecision)) AS notinvoicedlines, sum(round((l.qtyordered -
l.qtyinvoiced) * l.priceactual, c.stdprecision) * (1 + t.rate / 100)) AS
notinvoicedlinesgross, o.invoicerule AS term, sum(round((l.qtydelivered -
l.qtyinvoiced) * l.priceactual, c.stdprecision)) AS pendinglines,
sum(round((l.qtydelivered - l.qtyinvoiced) * l.priceactual, c.stdprecision) *
(1 + t.rate / 100)) AS pendinglinesgross, sum(abs(l.qtyordered)) AS qtyordered,
sum(abs(l.qtydelivered)) AS qtydelivered, o.m_pricelist_id, c.c_currency_id
FROM c_order o
JOIN m_pricelist p ON o.m_pricelist_id = p.m_pricelist_id
JOIN c_currency c ON p.c_currency_id = c.c_currency_id
@@ -11,7 +11,7 @@
LEFT JOIN c_invoiceschedule si ON bp.c_invoiceschedule_id =
si.c_invoiceschedule_id
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)
+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 (abs(l.qtyordered -
l.qtyinvoiced) <> 0 OR abs(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,
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>
------------------------------------------------------------------------------
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
