details: /erp/devel/pi/rev/c72b2f028c8f
changeset: 6705:c72b2f028c8f
user: Mikel Irurita <mikel.irurita <at> openbravo.com>
date: Mon Mar 15 10:11:19 2010 +0100
summary: Trial Balance Report review. Added new filters and dimensions.
Updated queries and html, pdf, xls output.
diffstat:
src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml |
10 +
src-db/database/sourcedata/AD_PROCESS.xml |
11 +-
src-db/database/sourcedata/AD_TEXTINTERFACES.xml |
132 +-
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html |
750 ++++--
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java |
697 +++--
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.xml |
86 +-
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail.html |
27 +-
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail.java |
131 +-
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail.xml |
5 +-
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail_data.xsql |
82 +-
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml |
609 +++++
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalancePDF.jrxml |
1103 ++++++++++
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql |
501 +++-
13 files changed, 3353 insertions(+), 791 deletions(-)
diffs (truncated from 4792 to 300 lines):
diff -r 2c2166aa1aa1 -r c72b2f028c8f
src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
--- a/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml Mon Mar 15
09:09:46 2010 +0100
+++ b/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml Mon Mar 15
10:11:19 2010 +0100
@@ -23970,6 +23970,16 @@
<!--2D84F7A0CC044AF98979061236347389--> <ISDEFAULT><![CDATA[Y]]></ISDEFAULT>
<!--2D84F7A0CC044AF98979061236347389--></AD_MODEL_OBJECT_MAPPING>
+<!--30041C231BCC437AAFC78E2E2EC8D881--><AD_MODEL_OBJECT_MAPPING>
+<!--30041C231BCC437AAFC78E2E2EC8D881-->
<AD_MODEL_OBJECT_MAPPING_ID><![CDATA[30041C231BCC437AAFC78E2E2EC8D881]]></AD_MODEL_OBJECT_MAPPING_ID>
+<!--30041C231BCC437AAFC78E2E2EC8D881-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--30041C231BCC437AAFC78E2E2EC8D881--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--30041C231BCC437AAFC78E2E2EC8D881--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--30041C231BCC437AAFC78E2E2EC8D881-->
<AD_MODEL_OBJECT_ID><![CDATA[800787]]></AD_MODEL_OBJECT_ID>
+<!--30041C231BCC437AAFC78E2E2EC8D881-->
<MAPPINGNAME><![CDATA[/ad_reports/ReportTrialBalanceExcel.xls]]></MAPPINGNAME>
+<!--30041C231BCC437AAFC78E2E2EC8D881--> <ISDEFAULT><![CDATA[N]]></ISDEFAULT>
+<!--30041C231BCC437AAFC78E2E2EC8D881--></AD_MODEL_OBJECT_MAPPING>
+
<!--332827CF4E354EF8A92A4A708E166BA0--><AD_MODEL_OBJECT_MAPPING>
<!--332827CF4E354EF8A92A4A708E166BA0-->
<AD_MODEL_OBJECT_MAPPING_ID><![CDATA[332827CF4E354EF8A92A4A708E166BA0]]></AD_MODEL_OBJECT_MAPPING_ID>
<!--332827CF4E354EF8A92A4A708E166BA0-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 2c2166aa1aa1 -r c72b2f028c8f src-db/database/sourcedata/AD_PROCESS.xml
--- a/src-db/database/sourcedata/AD_PROCESS.xml Mon Mar 15 09:09:46 2010 +0100
+++ b/src-db/database/sourcedata/AD_PROCESS.xml Mon Mar 15 10:11:19 2010 +0100
@@ -2787,7 +2787,16 @@
<!--800039--> <VALUE><![CDATA[ReportTrialBalance]]></VALUE>
<!--800039--> <NAME><![CDATA[Trial Balance Report]]></NAME>
<!--800039--> <DESCRIPTION><![CDATA[Trial Balance Report]]></DESCRIPTION>
-<!--800039--> <HELP><![CDATA[Trial Balance Report]]></HELP>
+<!--800039--> <HELP><![CDATA[Create a report showing the sum of debits
against the sum of credits for all general ledger accounts in a specified time
period. It is possible to group the results by the Business Partner, Product or
Project accounting dimensions. It is also possible to filter the results by
organization, range of accounts and a selection of Business Partners, Products
and Projects accounting.
+
+There are 3 ways available to get the results, the Search button, the pdf and
Excel exports.
+
+The Search button shows the result in the same window. With an expand/collapse
button the details of subaccounts are displayed according to the selected
grouping type.
+The result is grouped by the account and by the selected accounting dimension
(if there is one selected). The displayed entries are ordered by the account
code.
+
+The pdf export generates a pdf file that can be printed or stored in the
computer for later reviews. It has the same grouping rules as the search button.
+
+The Excel export generates an xls file that can be used to perform more
advanced analysis to the data. In this case the entries are not shown in
different groups. So the user can reorder and group the entries as desired. For
each entry the account code, account name, initial balance amount, debit
amount, credit amount, final balance amount, business partner, product and
project are shown.]]></HELP>
<!--800039--> <ACCESSLEVEL><![CDATA[1]]></ACCESSLEVEL>
<!--800039--> <ISUSERSTARTABLE><![CDATA[N]]></ISUSERSTARTABLE>
<!--800039--> <ISREPORT><![CDATA[Y]]></ISREPORT>
diff -r 2c2166aa1aa1 -r c72b2f028c8f
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
--- a/src-db/database/sourcedata/AD_TEXTINTERFACES.xml Mon Mar 15 09:09:46
2010 +0100
+++ b/src-db/database/sourcedata/AD_TEXTINTERFACES.xml Mon Mar 15 10:11:19
2010 +0100
@@ -706,17 +706,6 @@
<!--800545--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--800545--></AD_TEXTINTERFACES>
-<!--800566--><AD_TEXTINTERFACES>
-<!--800566--> <AD_TEXTINTERFACES_ID><![CDATA[800566]]></AD_TEXTINTERFACES_ID>
-<!--800566--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--800566--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--800566--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--800566--> <TEXT><![CDATA[Show selected level only]]></TEXT>
-<!--800566-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html]]></FILENAME>
-<!--800566--> <ISUSED><![CDATA[Y]]></ISUSED>
-<!--800566--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--800566--></AD_TEXTINTERFACES>
-
<!--800570--><AD_TEXTINTERFACES>
<!--800570--> <AD_TEXTINTERFACES_ID><![CDATA[800570]]></AD_TEXTINTERFACES_ID>
<!--800570--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -12762,28 +12751,6 @@
<!--810036--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--810036--></AD_TEXTINTERFACES>
-<!--810037--><AD_TEXTINTERFACES>
-<!--810037--> <AD_TEXTINTERFACES_ID><![CDATA[810037]]></AD_TEXTINTERFACES_ID>
-<!--810037--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--810037--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--810037--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--810037--> <TEXT><![CDATA[Debit Period]]></TEXT>
-<!--810037-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html]]></FILENAME>
-<!--810037--> <ISUSED><![CDATA[Y]]></ISUSED>
-<!--810037--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--810037--></AD_TEXTINTERFACES>
-
-<!--810038--><AD_TEXTINTERFACES>
-<!--810038--> <AD_TEXTINTERFACES_ID><![CDATA[810038]]></AD_TEXTINTERFACES_ID>
-<!--810038--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--810038--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--810038--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--810038--> <TEXT><![CDATA[Credit Period]]></TEXT>
-<!--810038-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html]]></FILENAME>
-<!--810038--> <ISUSED><![CDATA[Y]]></ISUSED>
-<!--810038--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--810038--></AD_TEXTINTERFACES>
-
<!--810039--><AD_TEXTINTERFACES>
<!--810039--> <AD_TEXTINTERFACES_ID><![CDATA[810039]]></AD_TEXTINTERFACES_ID>
<!--810039--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -15132,17 +15099,6 @@
<!--1003900011--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--1003900011--></AD_TEXTINTERFACES>
-<!--1003900012--><AD_TEXTINTERFACES>
-<!--1003900012-->
<AD_TEXTINTERFACES_ID><![CDATA[1003900012]]></AD_TEXTINTERFACES_ID>
-<!--1003900012--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--1003900012--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--1003900012--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--1003900012--> <TEXT><![CDATA[All:]]></TEXT>
-<!--1003900012-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html]]></FILENAME>
-<!--1003900012--> <ISUSED><![CDATA[Y]]></ISUSED>
-<!--1003900012--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--1003900012--></AD_TEXTINTERFACES>
-
<!--1003900014--><AD_TEXTINTERFACES>
<!--1003900014-->
<AD_TEXTINTERFACES_ID><![CDATA[1003900014]]></AD_TEXTINTERFACES_ID>
<!--1003900014--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -16252,6 +16208,17 @@
<!--00B7AF5613384D16BD23168FF64D24CE-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--00B7AF5613384D16BD23168FF64D24CE--></AD_TEXTINTERFACES>
+<!--04AF48556B2E4A22AB53FFA3B4BF2DD3--><AD_TEXTINTERFACES>
+<!--04AF48556B2E4A22AB53FFA3B4BF2DD3-->
<AD_TEXTINTERFACES_ID><![CDATA[04AF48556B2E4A22AB53FFA3B4BF2DD3]]></AD_TEXTINTERFACES_ID>
+<!--04AF48556B2E4A22AB53FFA3B4BF2DD3-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--04AF48556B2E4A22AB53FFA3B4BF2DD3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--04AF48556B2E4A22AB53FFA3B4BF2DD3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--04AF48556B2E4A22AB53FFA3B4BF2DD3--> <TEXT><![CDATA[Account Name]]></TEXT>
+<!--04AF48556B2E4A22AB53FFA3B4BF2DD3-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml]]></FILENAME>
+<!--04AF48556B2E4A22AB53FFA3B4BF2DD3--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--04AF48556B2E4A22AB53FFA3B4BF2DD3-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--04AF48556B2E4A22AB53FFA3B4BF2DD3--></AD_TEXTINTERFACES>
+
<!--06D146DA9FC911DD8326D35A1C1FBFCD--><AD_TEXTINTERFACES>
<!--06D146DA9FC911DD8326D35A1C1FBFCD-->
<AD_TEXTINTERFACES_ID><![CDATA[06D146DA9FC911DD8326D35A1C1FBFCD]]></AD_TEXTINTERFACES_ID>
<!--06D146DA9FC911DD8326D35A1C1FBFCD-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -16571,6 +16538,17 @@
<!--1F7A12B22E5211DE94C70773B37B0560-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--1F7A12B22E5211DE94C70773B37B0560--></AD_TEXTINTERFACES>
+<!--2014493EDD694BDAB8B6E57A3947C451--><AD_TEXTINTERFACES>
+<!--2014493EDD694BDAB8B6E57A3947C451-->
<AD_TEXTINTERFACES_ID><![CDATA[2014493EDD694BDAB8B6E57A3947C451]]></AD_TEXTINTERFACES_ID>
+<!--2014493EDD694BDAB8B6E57A3947C451-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2014493EDD694BDAB8B6E57A3947C451--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2014493EDD694BDAB8B6E57A3947C451--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2014493EDD694BDAB8B6E57A3947C451--> <TEXT><![CDATA[Group By]]></TEXT>
+<!--2014493EDD694BDAB8B6E57A3947C451-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html]]></FILENAME>
+<!--2014493EDD694BDAB8B6E57A3947C451--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--2014493EDD694BDAB8B6E57A3947C451-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--2014493EDD694BDAB8B6E57A3947C451--></AD_TEXTINTERFACES>
+
<!--203E574E2E5211DE83B8B39281CDF47D--><AD_TEXTINTERFACES>
<!--203E574E2E5211DE83B8B39281CDF47D-->
<AD_TEXTINTERFACES_ID><![CDATA[203E574E2E5211DE83B8B39281CDF47D]]></AD_TEXTINTERFACES_ID>
<!--203E574E2E5211DE83B8B39281CDF47D-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -17857,6 +17835,17 @@
<!--58E820EAFF083EE9E040007F01015AA4-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--58E820EAFF083EE9E040007F01015AA4--></AD_TEXTINTERFACES>
+<!--598EA1B1F3B4464F87AA6C148B89A694--><AD_TEXTINTERFACES>
+<!--598EA1B1F3B4464F87AA6C148B89A694-->
<AD_TEXTINTERFACES_ID><![CDATA[598EA1B1F3B4464F87AA6C148B89A694]]></AD_TEXTINTERFACES_ID>
+<!--598EA1B1F3B4464F87AA6C148B89A694-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--598EA1B1F3B4464F87AA6C148B89A694--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--598EA1B1F3B4464F87AA6C148B89A694--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--598EA1B1F3B4464F87AA6C148B89A694--> <TEXT><![CDATA[Final Balance]]></TEXT>
+<!--598EA1B1F3B4464F87AA6C148B89A694-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml]]></FILENAME>
+<!--598EA1B1F3B4464F87AA6C148B89A694--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--598EA1B1F3B4464F87AA6C148B89A694-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--598EA1B1F3B4464F87AA6C148B89A694--></AD_TEXTINTERFACES>
+
<!--59C535D117488963E040007F010128AB--><AD_TEXTINTERFACES>
<!--59C535D117488963E040007F010128AB-->
<AD_TEXTINTERFACES_ID><![CDATA[59C535D117488963E040007F010128AB]]></AD_TEXTINTERFACES_ID>
<!--59C535D117488963E040007F010128AB-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -18836,6 +18825,17 @@
<!--605A878DC6B5C144E040007F01003147-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--605A878DC6B5C144E040007F01003147--></AD_TEXTINTERFACES>
+<!--60AF049F210E475692184884E21A3970--><AD_TEXTINTERFACES>
+<!--60AF049F210E475692184884E21A3970-->
<AD_TEXTINTERFACES_ID><![CDATA[60AF049F210E475692184884E21A3970]]></AD_TEXTINTERFACES_ID>
+<!--60AF049F210E475692184884E21A3970-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--60AF049F210E475692184884E21A3970--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--60AF049F210E475692184884E21A3970--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--60AF049F210E475692184884E21A3970--> <TEXT><![CDATA[Initial Bal.]]></TEXT>
+<!--60AF049F210E475692184884E21A3970-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalancePDF.jrxml]]></FILENAME>
+<!--60AF049F210E475692184884E21A3970--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--60AF049F210E475692184884E21A3970-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--60AF049F210E475692184884E21A3970--></AD_TEXTINTERFACES>
+
<!--60D44A2F9BAD4906940E372D168B73BF--><AD_TEXTINTERFACES>
<!--60D44A2F9BAD4906940E372D168B73BF-->
<AD_TEXTINTERFACES_ID><![CDATA[60D44A2F9BAD4906940E372D168B73BF]]></AD_TEXTINTERFACES_ID>
<!--60D44A2F9BAD4906940E372D168B73BF-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20706,6 +20706,28 @@
<!--7FF3469B9A49B90AE040007F01007549-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--7FF3469B9A49B90AE040007F01007549--></AD_TEXTINTERFACES>
+<!--80E23F4A6FC141DFB300F8E511EBE05E--><AD_TEXTINTERFACES>
+<!--80E23F4A6FC141DFB300F8E511EBE05E-->
<AD_TEXTINTERFACES_ID><![CDATA[80E23F4A6FC141DFB300F8E511EBE05E]]></AD_TEXTINTERFACES_ID>
+<!--80E23F4A6FC141DFB300F8E511EBE05E-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--80E23F4A6FC141DFB300F8E511EBE05E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--80E23F4A6FC141DFB300F8E511EBE05E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--80E23F4A6FC141DFB300F8E511EBE05E--> <TEXT><![CDATA[Final Bal.]]></TEXT>
+<!--80E23F4A6FC141DFB300F8E511EBE05E-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalancePDF.jrxml]]></FILENAME>
+<!--80E23F4A6FC141DFB300F8E511EBE05E--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--80E23F4A6FC141DFB300F8E511EBE05E-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--80E23F4A6FC141DFB300F8E511EBE05E--></AD_TEXTINTERFACES>
+
+<!--819A66AA424F4169949E75C372C9938C--><AD_TEXTINTERFACES>
+<!--819A66AA424F4169949E75C372C9938C-->
<AD_TEXTINTERFACES_ID><![CDATA[819A66AA424F4169949E75C372C9938C]]></AD_TEXTINTERFACES_ID>
+<!--819A66AA424F4169949E75C372C9938C-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--819A66AA424F4169949E75C372C9938C--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--819A66AA424F4169949E75C372C9938C--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--819A66AA424F4169949E75C372C9938C--> <TEXT><![CDATA[Acct. No.]]></TEXT>
+<!--819A66AA424F4169949E75C372C9938C-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml]]></FILENAME>
+<!--819A66AA424F4169949E75C372C9938C--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--819A66AA424F4169949E75C372C9938C-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--819A66AA424F4169949E75C372C9938C--></AD_TEXTINTERFACES>
+
<!--83138086E1BB4553A01995EE567C1BF5--><AD_TEXTINTERFACES>
<!--83138086E1BB4553A01995EE567C1BF5-->
<AD_TEXTINTERFACES_ID><![CDATA[83138086E1BB4553A01995EE567C1BF5]]></AD_TEXTINTERFACES_ID>
<!--83138086E1BB4553A01995EE567C1BF5-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20946,6 +20968,17 @@
<!--AE7B8660F2B811DDA8F4001D09C4A2FE-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--AE7B8660F2B811DDA8F4001D09C4A2FE--></AD_TEXTINTERFACES>
+<!--AEB4114777D14A2988B8937F98CAFA16--><AD_TEXTINTERFACES>
+<!--AEB4114777D14A2988B8937F98CAFA16-->
<AD_TEXTINTERFACES_ID><![CDATA[AEB4114777D14A2988B8937F98CAFA16]]></AD_TEXTINTERFACES_ID>
+<!--AEB4114777D14A2988B8937F98CAFA16-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--AEB4114777D14A2988B8937F98CAFA16--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--AEB4114777D14A2988B8937F98CAFA16--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--AEB4114777D14A2988B8937F98CAFA16--> <TEXT><![CDATA[Initial
Balance]]></TEXT>
+<!--AEB4114777D14A2988B8937F98CAFA16-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml]]></FILENAME>
+<!--AEB4114777D14A2988B8937F98CAFA16--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--AEB4114777D14A2988B8937F98CAFA16-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--AEB4114777D14A2988B8937F98CAFA16--></AD_TEXTINTERFACES>
+
<!--B0310282628911DE8D8512313C002DE1--><AD_TEXTINTERFACES>
<!--B0310282628911DE8D8512313C002DE1-->
<AD_TEXTINTERFACES_ID><![CDATA[B0310282628911DE8D8512313C002DE1]]></AD_TEXTINTERFACES_ID>
<!--B0310282628911DE8D8512313C002DE1-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -21078,6 +21111,17 @@
<!--CBCCF3724F8B4AAFB2FDB775505E9B43-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--CBCCF3724F8B4AAFB2FDB775505E9B43--></AD_TEXTINTERFACES>
+<!--CBF216FCE9E1497CB5EA50151D4EDE88--><AD_TEXTINTERFACES>
+<!--CBF216FCE9E1497CB5EA50151D4EDE88-->
<AD_TEXTINTERFACES_ID><![CDATA[CBF216FCE9E1497CB5EA50151D4EDE88]]></AD_TEXTINTERFACES_ID>
+<!--CBF216FCE9E1497CB5EA50151D4EDE88-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--CBF216FCE9E1497CB5EA50151D4EDE88--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--CBF216FCE9E1497CB5EA50151D4EDE88--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--CBF216FCE9E1497CB5EA50151D4EDE88--> <TEXT><![CDATA[<no
description>]]></TEXT>
+<!--CBF216FCE9E1497CB5EA50151D4EDE88-->
<FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalancePDF.jrxml]]></FILENAME>
+<!--CBF216FCE9E1497CB5EA50151D4EDE88--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--CBF216FCE9E1497CB5EA50151D4EDE88-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--CBF216FCE9E1497CB5EA50151D4EDE88--></AD_TEXTINTERFACES>
+
<!--CF7B445B487E4AC3A63CE243F78AE40D--><AD_TEXTINTERFACES>
<!--CF7B445B487E4AC3A63CE243F78AE40D-->
<AD_TEXTINTERFACES_ID><![CDATA[CF7B445B487E4AC3A63CE243F78AE40D]]></AD_TEXTINTERFACES_ID>
<!--CF7B445B487E4AC3A63CE243F78AE40D-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 2c2166aa1aa1 -r c72b2f028c8f
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html
--- a/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html Mon Mar
15 09:09:46 2010 +0100
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html Mon Mar
15 10:11:19 2010 +0100
@@ -13,7 +13,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2001-2010 Openbravo SLU
+ * All portions are Copyright (C) 2001-2009 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************
@@ -60,25 +60,27 @@
</script>
<script language="JavaScript" type="text/javascript">
function displayLogic() {
- //alert("inpLvl"+inputValue(document.frmMain.inpLevel)+" -
inpOnly:"+inputValue(document.frmMain.inpOnly));
- if (inputValue(document.frmMain.inpLevel) == 'S' &&
inputValue(document.frmMain.inpOnly) == '-1') {
+ if (inputValue(document.frmMain.inpLevel) == 'S') {
displayLogicElement('AcctFromTo', true);
- displayLogicElement('BP', true);
- displayLogicElement('BP1', true);
- displayLogicElement('BP2', true);
+ displayLogicElement('Filter1', true);
+ displayLogicElement('Filter2', true);
+ displayLogicElement('Filter3', true);
+ displayLogicElement('Filter4', true);
}else{
displayLogicElement('AcctFromTo', false);
- displayLogicElement('BP', false);
- displayLogicElement('BP1', false);
- displayLogicElement('BP2', false);
+ displayLogicElement('Filter1', false);
+ displayLogicElement('Filter2', false);
+ displayLogicElement('Filter3', false);
+ displayLogicElement('Filter4', false);
}
}
function onloadFunctions() {
displayLogic();
+ keyArray[keyArray.length] = new keyArrayItem("ENTER", "openSearch(null,
null, '../info/AccountElementValue.html', 'SELECTOR_ACCOUNTELEMENTVALUE',
false, 'frmMain', 'inpcElementValueIdFrom', 'inpElementValueIdFrom_DES',
document.frmMain.inpElementValueIdFrom_DES.value, 'Command', 'KEY');",
"inpElementValueIdFrom_DES", "null");
+ keyArray[keyArray.length] = new keyArrayItem("ENTER", "openSearch(null,
null, '../info/AccountElementValue.html', 'SELECTOR_ACCOUNTELEMENTVALUE',
false, 'frmMain', 'inpcElementValueIdTo', 'inpElementValueIdTo_DES',
document.frmMain.inpElementValueIdTo_DES.value, 'Command', 'KEY');",
"inpElementValueIdTo_DES", "null");
}
-
function validate() {
var frm=document.frmMain;
if (inputValue(frm.inpDateFrom)==null || inputValue(frm.inpDateFrom)=="") {
@@ -103,31 +105,123 @@
return false;
}
markCheckedAllElements(frm.inpcBPartnerId_IN);
+ markCheckedAllElements(frm.inpcProjectId_IN);
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
