Related to bug 28896: Missing entry on group by clause
authorUnai Martirena <unai.martirena@openbravo.com>
Thu, 12 Feb 2015 13:35:34 +0100
changeset 25906 77ed398f859c
parent 25905 c3acd6c8dc33
child 25907 3cf79f7adef9
Related to bug 28896: Missing entry on group by clause
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/hqlinjections/AddPaymentOrderInvoicesTransformer.java
--- a/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/hqlinjections/AddPaymentOrderInvoicesTransformer.java	Thu Feb 12 09:06:42 2015 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/hqlinjections/AddPaymentOrderInvoicesTransformer.java	Thu Feb 12 13:35:34 2015 +0100
@@ -294,6 +294,7 @@
       groupByClause.append(" COALESCE(ipriority.priority, opriority.priority), ");
       groupByClause.append(" inv.salesTransaction, ");
       groupByClause.append(" oinfo.organization, ");
+      groupByClause.append(" oinfo.aPRMPaymentDescription, ");
       groupByClause.append(" inv.orderReference, ");
     } else if ("O".equals(transactionType)) {
       groupByClause.append(" ord.documentNo, ");
@@ -310,6 +311,7 @@
       groupByClause.append(" COALESCE(ipriority.priority, opriority.priority), ");
       groupByClause.append(" inv.salesTransaction, ");
       groupByClause.append(" oinfo.organization, ");
+      groupByClause.append(" oinfo.aPRMPaymentDescription, ");
       groupByClause.append(" inv.orderReference, ");
     }
     groupByClause.append(" COALESCE(invbp.id, ordbp.id), ");