details: /erp/devel/api-checks/rev/37a6d7453a83
changeset: 104:37a6d7453a83
user: Stefan Hühner <stefan.huehner <at> openbravo.com>
date: Thu Apr 08 17:45:27 2010 +0200
summary: Fixed 12913: Ack as false positive, view structure (output columns)
are unchanged
diffstat:
model/model/views/C_INVOICE_CANDIDATE_V.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r aedb42a83ae4 -r 37a6d7453a83 model/model/views/C_INVOICE_CANDIDATE_V.xml
--- a/model/model/views/C_INVOICE_CANDIDATE_V.xml Wed Apr 07 21:27:29
2010 +0200
+++ b/model/model/views/C_INVOICE_CANDIDATE_V.xml Thu Apr 08 17:45:27
2010 +0200
@@ -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) * l.priceactual) <> 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>
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
