[OBCQL] Pending goods receipt widget fixed to show only purchase transactions.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Thu, 20 Jan 2011 10:21:28 +0100
changeset 9973 c82872d3f44c
parent 9972 48237af3bdfe
child 9974 84093893978a
[OBCQL] Pending goods receipt widget fixed to show only purchase transactions.
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	Thu Jan 20 10:10:44 2011 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Thu Jan 20 10:21:28 2011 +0100
@@ -84,6 +84,7 @@
 from OrderLine as ol left join ol.attributeSetValue
 where ol.client.id =:client
 and ol.salesOrder.documentStatus='CO'
+and ol.salesOrder.salesTransaction=false
 and ol.orderedQuantity <> (select coalesce(sum(po3.quantity),0) 
                             from ProcurementPOInvoiceMatch po3
                             where po3.goodsShipmentLine is not null