details: https://code.openbravo.com/erp/devel/pi/rev/5375dedb29d6
changeset: 21066:5375dedb29d6
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Sep 04 01:56:32 2013 +0200
summary: Fixes issue 24097: Invoices to collect widget shows voided invoices
diffstat:
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
| 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r f32bf92a94d5 -r 5375dedb29d6
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
---
a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
Wed Sep 04 01:34:46 2013 +0200
+++
b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
Wed Sep 04 01:56:32 2013 +0200
@@ -6,7 +6,7 @@
<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--1EF87E8E961A4E5BA3B41E1AB772B47C-->
<OBKMO_WIDGET_CLASS_ID><![CDATA[147D825456D54D0486C3D7072531C5C9]]></OBKMO_WIDGET_CLASS_ID>
-<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <HQL><![CDATA[select inv.id as
invoiceId, inv.documentNo as documentNo, inv.businessPartner.id as
businessPartnerId, inv.businessPartner.name as businessPartnerName,
inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount,
inv.currency.iSOCode as currency, inv.paymentTerms.name as paymentTerms,
inv.outstandingAmount as outstandingAmount, inv.daysTillDue as daysTillDue,
inv.dueAmount as dueAmount, inv.organization.name as organizationName from
Invoice as inv where inv.businessPartner.name like :businessPartnerName
and inv.documentNo like :documentNo and inv.processed = true and
inv.paymentComplete = false and inv.salesTransaction = true and
inv.client.id = :client and inv.organization.id in (:organizationList)
and inv.organization.name like :organizationName and
@optional_filters@ order by inv.invoiceDate]]></HQL>
+<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <HQL><![CDATA[select inv.id as
invoiceId, inv.documentNo as documentNo, inv.businessPartner.id as
businessPartnerId, inv.businessPartner.name as businessPartnerName,
inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount,
inv.currency.iSOCode as currency, inv.paymentTerms.name as paymentTerms,
inv.outstandingAmount as outstandingAmount, inv.daysTillDue as daysTillDue,
inv.dueAmount as dueAmount, inv.organization.name as organizationName from
Invoice as inv where inv.businessPartner.name like :businessPartnerName
and inv.documentNo like :documentNo and inv.processed = true and
inv.documentStatus <> 'VO' and inv.paymentComplete = false and
inv.salesTransaction = true and inv.client.id = :client and
inv.organization.id in (:organizationList) and inv.organization.name like
:organizationName and @optional_filters@ order by inv.invoiceDate]]></HQL>
<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <TYPE><![CDATA[HQL]]></TYPE>
<!--1EF87E8E961A4E5BA3B41E1AB772B47C--></OBCQL_WIDGET_QUERY>
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
