Fixes issue 24097: Invoices to collect widget shows voided invoices
authorJavier Etxarri <javier.echarri@openbravo.com>
Wed, 04 Sep 2013 01:56:32 +0200
changeset 21096 5375dedb29d6
parent 21095 f32bf92a94d5
child 21097 f497677fd0d9
Fixes issue 24097: Invoices to collect widget shows voided invoices
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>