Fixes Issue 26930:Balance Sheet, P&L Rpt should show legal name of org
authorAtul Gaware <atul.gaware@openbravo.com>
Thu, 31 Jul 2014 22:31:26 +0530
changeset 24150 7a2993961171
parent 24149 286896a13002
child 24151 4f31d2d162f9
Fixes Issue 26930:Balance Sheet, P&L Rpt should show legal name of org
instead of name
src/org/openbravo/erpCommon/ad_reports/Organization_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/Organization_data.xsql	Fri Aug 01 12:37:37 2014 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/Organization_data.xsql	Thu Jul 31 22:31:26 2014 +0530
@@ -46,7 +46,7 @@
    <SqlMethod name="selectOrgName" type="preparedStatement" return="string" default="">
       <SqlMethodComment></SqlMethodComment>
       <Sql>
-        SELECT NAME FROM AD_ORG
+        SELECT COALESCE(SOCIAL_NAME, NAME) AS NAME FROM AD_ORG
         WHERE AD_ORG_ID = ?
       </Sql>
       <Parameter name="org"/>