Fixes issue 27919: Match Landed Cost P&E raises an error in Postgres 8.4
authorUnai Martirena <unai.martirena@openbravo.com>
Mon, 20 Oct 2014 18:54:45 +0200
changeset 25064 8e150ca07c2f
parent 25063 446f3299efdb
child 25065 203b797e4189
Fixes issue 27919: Match Landed Cost P&E raises an error in Postgres 8.4
src-db/database/sourcedata/AD_TABLE.xml
--- a/src-db/database/sourcedata/AD_TABLE.xml	Mon Oct 20 18:39:02 2014 +0200
+++ b/src-db/database/sourcedata/AD_TABLE.xml	Mon Oct 20 18:54:45 2014 +0200
@@ -11408,7 +11408,7 @@
 where (lcc.matched = false or lcm is not null)
   and @additional_filters@
   and @insertion_point_0@
-group by  coalesce(lcm.id, lcc.id), lcc, lct.name, lcc.amount, lcc.currency.iSOCode, lcm.amount, case when lcm is not null then true else false end, lc.referenceDate, lcc.matched, lcc.isMatchingAdjusted, lcm.id, lcc.id, il, lc.documentNo, lcc.lineNo, lcm.amountInInvoiceCurrency]]></HQLQUERY>
+group by  coalesce(lcm.id, lcc.id), lcc, lct.name, lcc.amount, lcc.currency.iSOCode, lcm.amount, case when lcm is not null then true else false end, lc.referenceDate, lcc.matched, lcc.isMatchingAdjusted, lcm.id, lcc.id, il, lc.documentNo, lcc.lineNo, lcc.processed, lcm.amountInInvoiceCurrency]]></HQLQUERY>
 <!--B2960E2BDCCD4F7599A2433F2681847F-->  <ENTITY_ALIAS><![CDATA[lcc]]></ENTITY_ALIAS>
 <!--B2960E2BDCCD4F7599A2433F2681847F--></AD_TABLE>