diff --git a/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql b/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
+++ b/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
@@ -224,8 +224,9 @@
       <Sql><![CDATA[
         SELECT CASE WHEN C.CLOSE_FACT_ACCT_GROUP_ID IS NULL THEN 'N' ELSE 'Y' END || SELECTED.C_YEAR_ID AS ID,
           C_YEAR.YEAR AS NAME
-        FROM C_PERIOD PREVIOUS LEFT JOIN AD_ORG_CLOSING C ON C.C_YEAR_ID = PREVIOUS.C_YEAR_ID, C_PERIOD SELECTED, C_YEAR,
-          AD_ORG_ACCTSCHEMA OAS
+        FROM C_PERIOD PREVIOUS LEFT JOIN AD_ORG_CLOSING C ON C.C_YEAR_ID = PREVIOUS.C_YEAR_ID
+                               LEFT JOIN AD_ORG_ACCTSCHEMA OAS ON C.AD_ORG_ACCTSCHEMA_ID = OAS.AD_ORG_ACCTSCHEMA_ID,
+          C_PERIOD SELECTED, C_YEAR
         WHERE PREVIOUS.AD_CLIENT_ID = ?
           AND SELECTED.AD_CLIENT_ID = ?
           AND SELECTED.ISACTIVE = 'Y'
@@ -240,7 +241,7 @@
           )
           AND C_YEAR.C_YEAR_ID = SELECTED.C_YEAR_ID
           AND C.AD_ORG_ACCTSCHEMA_ID = OAS.AD_ORG_ACCTSCHEMA_ID
-          AND OAS.C_ACCTSCHEMA_ID = ?
+          AND (OAS.C_ACCTSCHEMA_ID = ? OR OAS.C_ACCTSCHEMA_ID IS NULL)
         UNION
         SELECT 'M'||Y.C_YEAR_ID AS ID, Y.YEAR AS NAME
         FROM C_PERIOD P, C_YEAR Y