You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by ha...@apache.org on 2010/10/01 12:40:39 UTC
svn commit: r1003469 [4/7] - in /ofbiz/trunk/applications/accounting:
config/ webapp/accounting/WEB-INF/
webapp/accounting/WEB-INF/actions/reports/ webapp/accounting/reports/ widget/
Added: ofbiz/trunk/applications/accounting/webapp/accounting/reports/IncomeStatement.rptdesign
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/reports/IncomeStatement.rptdesign?rev=1003469&view=auto
==============================================================================
--- ofbiz/trunk/applications/accounting/webapp/accounting/reports/IncomeStatement.rptdesign (added)
+++ ofbiz/trunk/applications/accounting/webapp/accounting/reports/IncomeStatement.rptdesign Fri Oct 1 10:40:38 2010
@@ -0,0 +1,1173 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21" id="1">
+ <property name="createdBy">Eclipse BIRT Designer Version 2.6.0.v20100531 Build <2.6.0.v20100609-1613></property>
+ <property name="units">in</property>
+ <method name="initialize"><![CDATA[importPackage(Packages.javolution.util)
+importPackage(Packages.org.ofbiz.base.util)
+importPackage(Packages.org.ofbiz.entity.util)
+
+module = "IncomeStatement.rptdesign";
+dateFormatter = new java.text.SimpleDateFormat("dd MMMMM yyyy");
+
+// prepare uiLabelMap
+uiLabelMap = FastMap.newInstance();
+uiLabelMap.putAll(UtilProperties.getResourceBundleMap("CommonUiLabels", reportContext.getLocale()));
+uiLabelMap.putAll(UtilProperties.getResourceBundleMap("AccountingUiLabels", reportContext.getLocale()));
+
+fromDate = null;
+thruDate = null;
+glFiscalTypeId = null;
+
+// prepare parameters
+
+organizationPartyId = params["organizationPartyId"].value;
+userLogin = delegator.findOne("UserLogin", UtilMisc.toMap("userLoginId", params["userLoginId"].value), false);
+partyNameView = delegator.findOne("PartyNameView", UtilMisc.toMap("partyId", userLogin.getString("partyId")), false);
+
+fromDate = null;
+if (params["fromDate"].value) {
+ fromDate = params["fromDate"].value;
+}
+
+if (!params["thruDate"].value) {
+ thruDate = params["thruDate"].value;
+} else {
+ thruDate = UtilDateTime.nowTimestamp();
+}
+
+if (!params["glFiscalTypeId"].value) {
+ glFiscalTypeId = params["glFiscalTypeId"].value;
+} else {
+ glFiscalTypeId = "ACTUAL";
+}
+
+// call IncomeStatement.groovy script
+context = FastMap.newInstance();
+context.put("organizationPartyId", organizationPartyId);
+context.put("fromDate", fromDate);
+context.put("thruDate", thruDate);
+context.put("glFiscalTypeId", glFiscalTypeId);
+context.put("delegator", delegator);
+context.put("dispatcher", dispatcher);
+context.put("userLogin", userLogin);
+GroovyUtil.runScriptAtLocation("component://accounting/webapp/accounting/WEB-INF/actions/reports/IncomeStatement.groovy", context);
+
+// prepare data source lists
+revenueAccountBalanceList = context.get("revenueAccountBalanceList");
+expenseAccountBalanceList = context.get("expenseAccountBalanceList");
+incomeAccountBalanceList = context.get("incomeAccountBalanceList");
+balanceTotalList = context.get("balanceTotalList");]]></method>
+ <property name="iconFile">/templates/blank_report.gif</property>
+ <property name="bidiLayoutOrientation">ltr</property>
+ <data-sources>
+ <script-data-source name="OFBiz" id="149"/>
+ </data-sources>
+ <data-sets>
+ <script-data-set name="Revenue" id="150">
+ <list-property name="resultSetHints">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">glAccountId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">accountCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">accountName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">balance</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ </list-property>
+ <list-property name="columnHints">
+ <structure>
+ <property name="columnName">glAccountId</property>
+ <text-property name="displayName">Account ID</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">accountCode</property>
+ <text-property name="displayName">Account Code</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">accountName</property>
+ <text-property name="displayName">Account Name</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">balance</property>
+ <text-property name="displayName">Balance</text-property>
+ </structure>
+ </list-property>
+ <structure name="cachedMetaData">
+ <list-property name="resultSet">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">glAccountId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">accountCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">accountName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">balance</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ </list-property>
+ </structure>
+ <property name="dataSource">OFBiz</property>
+ <method name="open"><![CDATA[totalRow = 0;
+countOfRow = 0;
+
+if (revenueAccountBalanceList.size) {
+ totalRow = revenueAccountBalanceList.size();
+}]]></method>
+ <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false;
+
+var revenueAccountBalance = revenueAccountBalanceList.get(countOfRow);
+row["glAccountId"] = revenueAccountBalance.get("glAccountId");
+row["accountCode"] = revenueAccountBalance.get("accountCode");
+row["accountName"] = revenueAccountBalance.get("accountName");
+row["balance"] = revenueAccountBalance.get("balance");
+
+countOfRow ++;
+return true;]]></method>
+ </script-data-set>
+ <script-data-set name="Expense" id="151">
+ <list-property name="resultSetHints">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">glAccountId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">accountCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">accountName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">balance</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ </list-property>
+ <list-property name="columnHints">
+ <structure>
+ <property name="columnName">glAccountId</property>
+ <text-property name="displayName">Account ID</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">accountCode</property>
+ <text-property name="displayName">Account Code</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">accountName</property>
+ <text-property name="displayName">Account Name</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">balance</property>
+ <text-property name="displayName">Balance</text-property>
+ </structure>
+ </list-property>
+ <structure name="cachedMetaData">
+ <list-property name="resultSet">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">glAccountId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">accountCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">accountName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">balance</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ </list-property>
+ </structure>
+ <property name="dataSource">OFBiz</property>
+ <method name="open"><![CDATA[totalRow = 0;
+countOfRow = 0;
+
+if (expenseAccountBalanceList.size) {
+ totalRow = expenseAccountBalanceList.size();
+}]]></method>
+ <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false;
+
+var expenseAccountBalance = expenseAccountBalanceList.get(countOfRow);
+row["glAccountId"] = expenseAccountBalance.get("glAccountId");
+row["accountCode"] = expenseAccountBalance.get("accountCode");
+row["accountName"] = expenseAccountBalance.get("accountName");
+row["balance"] = expenseAccountBalance.get("balance");
+
+countOfRow ++;
+return true;]]></method>
+ </script-data-set>
+ <script-data-set name="Income" id="152">
+ <list-property name="resultSetHints">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">glAccountId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">accountCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">accountName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">balance</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ </list-property>
+ <list-property name="columnHints">
+ <structure>
+ <property name="columnName">glAccountId</property>
+ <text-property name="displayName">Account ID</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">accountCode</property>
+ <text-property name="displayName">Account Code</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">accountName</property>
+ <text-property name="displayName">Account Name</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">balance</property>
+ <text-property name="displayName">Balance</text-property>
+ </structure>
+ </list-property>
+ <structure name="cachedMetaData">
+ <list-property name="resultSet">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">glAccountId</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">accountCode</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">3</property>
+ <property name="name">accountName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">4</property>
+ <property name="name">balance</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ </list-property>
+ </structure>
+ <property name="dataSource">OFBiz</property>
+ <method name="open"><![CDATA[totalRow = 0;
+countOfRow = 0;
+
+if (incomeAccountBalanceList.size) {
+ totalRow = incomeAccountBalanceList.size();
+}
+]]></method>
+ <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false;
+
+var incomeAccountBalance = incomeAccountBalanceList.get(countOfRow);
+row["glAccountId"] = incomeAccountBalance.get("glAccountId");
+row["accountCode"] = incomeAccountBalance.get("accountCode");
+row["accountName"] = incomeAccountBalance.get("accountName");
+row["balance"] = incomeAccountBalance.get("balance");
+
+countOfRow ++;
+return true;]]></method>
+ </script-data-set>
+ <script-data-set name="BalanceTotal" id="260">
+ <list-property name="resultSetHints">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">totalName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">balance</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ </list-property>
+ <list-property name="columnHints">
+ <structure>
+ <property name="columnName">totalName</property>
+ <text-property name="displayName">Total Name</text-property>
+ </structure>
+ <structure>
+ <property name="columnName">balance</property>
+ <text-property name="displayName">Balance</text-property>
+ </structure>
+ </list-property>
+ <structure name="cachedMetaData">
+ <list-property name="resultSet">
+ <structure>
+ <property name="position">1</property>
+ <property name="name">totalName</property>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="position">2</property>
+ <property name="name">balance</property>
+ <property name="dataType">decimal</property>
+ </structure>
+ </list-property>
+ </structure>
+ <property name="dataSource">OFBiz</property>
+ <method name="open"><![CDATA[totalRow = 0;
+countOfRow = 0;
+
+if (balanceTotalList.size) {
+ totalRow = balanceTotalList.size();
+}]]></method>
+ <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false;
+
+var balanceTotal = balanceTotalList.get(countOfRow);
+row["totalName"] = balanceTotal.get("totalName");
+row["balance"] = balanceTotal.get("balance");
+
+countOfRow ++;
+return true;]]></method>
+ </script-data-set>
+ </data-sets>
+ <styles>
+ <style name="report" id="4">
+ <property name="fontFamily">sans-serif</property>
+ <property name="fontSize">10pt</property>
+ </style>
+ <style name="crosstab-cell" id="5">
+ <property name="borderBottomColor">#CCCCCC</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">1pt</property>
+ <property name="borderLeftColor">#CCCCCC</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">1pt</property>
+ <property name="borderRightColor">#CCCCCC</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">1pt</property>
+ <property name="borderTopColor">#CCCCCC</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">1pt</property>
+ </style>
+ <style name="crosstab" id="6">
+ <property name="borderBottomColor">#CCCCCC</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">1pt</property>
+ <property name="borderLeftColor">#CCCCCC</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">1pt</property>
+ <property name="borderRightColor">#CCCCCC</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">1pt</property>
+ <property name="borderTopColor">#CCCCCC</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">1pt</property>
+ </style>
+ </styles>
+ <page-setup>
+ <simple-master-page name="Simple MasterPage" id="2">
+ <property name="headerHeight">2in</property>
+ <page-header>
+ <grid id="8">
+ <property name="height">2.875in</property>
+ <property name="width">7.84375in</property>
+ <column id="9">
+ <property name="width">1.2916666666666667in</property>
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ </column>
+ <column id="10">
+ <property name="width">2.6354166666666665in</property>
+ </column>
+ <column id="11">
+ <property name="width">1.9583333333333333in</property>
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ </column>
+ <column id="27">
+ <property name="width">1.9583333333333333in</property>
+ </column>
+ <row id="12">
+ <cell id="13">
+ <property name="colSpan">2</property>
+ <property name="rowSpan">1</property>
+ <property name="textAlign">left</property>
+ <image id="28">
+ <property name="height">43px</property>
+ <property name="width">238px</property>
+ <method name="onCreate"><![CDATA[// get organization logo
+partyContents = delegator.findByAnd("PartyContent", UtilMisc.toMap("partyId", organizationPartyId, "partyContentTypeId", "LGOIMGURL"));
+partyContents = EntityUtil.filterByDate(partyContents);
+if (partyContents != null && partyContents.size() > 0) {
+ var dataResource = partyContents.get(0).getRelatedOne("Content").getRelatedOne("DataResource");
+ var dataResourceTypeId = dataResource.getString("dataResourceTypeId");
+ if ("LOCAL_FILE".equals(dataResourceTypeId)) {
+ this.file = dataResource.get("objectInfo");
+ } else {
+ this.URL = dataResource.get("objectInfo");
+ }
+} else {
+ this.URL = "http://localhost:8080/images/ofbiz_logo.gif";
+}]]></method>
+ <property name="source">url</property>
+ <property name="fitToContainer">false</property>
+ </image>
+ </cell>
+ <cell id="15">
+ <label id="29">
+ <property name="fontWeight">bold</property>
+ <property name="textUnderline">none</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonUsername") + ":";]]></method>
+ <text-property name="text">Username: </text-property>
+ </label>
+ </cell>
+ <cell id="24">
+ <text-data id="243">
+ <expression name="valueExpr">if (userLogin != null ) {partyNameView.getString("firstName") + "&nbsp;&nbsp;&nbsp;&nbsp;" + partyNameView.getString("lastName")}</expression>
+ <property name="contentType">html</property>
+ </text-data>
+ </cell>
+ </row>
+ <row id="16">
+ <cell id="17"/>
+ <cell id="18"/>
+ <cell id="19">
+ <label id="30">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonDate") + ":";]]></method>
+ <text-property name="text">Date: </text-property>
+ </label>
+ </cell>
+ <cell id="25">
+ <text-data id="244">
+ <expression name="valueExpr">dateFormatter.format(UtilDateTime.nowTimestamp())</expression>
+ <property name="contentType">html</property>
+ </text-data>
+ </cell>
+ </row>
+ <row id="132">
+ <cell id="133">
+ <label id="137">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_fromDate") + ":";]]></method>
+ <text-property name="text">From Date: </text-property>
+ </label>
+ </cell>
+ <cell id="134">
+ <text-data id="153">
+ <expression name="valueExpr">dateFormatter.format(fromDate)</expression>
+ <property name="contentType">html</property>
+ </text-data>
+ </cell>
+ <cell id="135">
+ <label id="278">
+ <property name="fontWeight">bold</property>
+ <property name="textUnderline">none</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingCurrency") + ":";]]></method>
+ <text-property name="text">Currency: </text-property>
+ </label>
+ </cell>
+ <cell id="136">
+ <text-data id="279">
+ <expression name="valueExpr">delegator.findOne("PartyAcctgPreference", UtilMisc.toMap("partyId", organizationPartyId), false).getRelatedOne("Uom").getString("description")</expression>
+ <property name="contentType">html</property>
+ </text-data>
+ </cell>
+ </row>
+ <row id="20">
+ <cell id="21">
+ <label id="31">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_thruDate") + ":";]]></method>
+ <text-property name="text">Thru Date: </text-property>
+ </label>
+ </cell>
+ <cell id="22">
+ <text-data id="251">
+ <expression name="valueExpr">dateFormatter.format(thruDate)</expression>
+ <property name="contentType">html</property>
+ </text-data>
+ </cell>
+ <cell id="23"/>
+ <cell id="26"/>
+ </row>
+ <row id="32">
+ <property name="height">0.5104166666666666in</property>
+ <cell id="33">
+ <label id="37">
+ <property name="fontWeight">bold</property>
+ <property name="textAlign">right</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_glFiscalTypeId") + ":";]]></method>
+ <text-property name="text">Fiscal Gl Type: </text-property>
+ </label>
+ </cell>
+ <cell id="34">
+ <text-data id="252">
+ <expression name="valueExpr">delegator.findOne("GlFiscalType", UtilMisc.toMap("glFiscalTypeId", glFiscalTypeId), false).getString("description")</expression>
+ <property name="contentType">html</property>
+ </text-data>
+ </cell>
+ <cell id="35"/>
+ <cell id="36"/>
+ </row>
+ <row id="245">
+ <cell id="246">
+ <property name="colSpan">4</property>
+ <property name="rowSpan">1</property>
+ <text id="250">
+ <method name="onPrepare"><![CDATA[this.content = "<CENTER><H3>" + uiLabelMap.get("AccountingIncomeStatement") + "</H3></CENTER>";]]></method>
+ <property name="contentType">html</property>
+ </text>
+ </cell>
+ </row>
+ </grid>
+ </page-header>
+ <page-footer>
+ <grid id="138">
+ <property name="width">7.9375in</property>
+ <column id="256">
+ <property name="width">2.8229166666666665in</property>
+ </column>
+ <column id="139">
+ <property name="width">0.8333333333333334in</property>
+ </column>
+ <column id="140">
+ <property name="width">0.3645833333333333in</property>
+ </column>
+ <column id="141">
+ <property name="width">0.7395833333333334in</property>
+ </column>
+ <column id="257">
+ <property name="width">3.1770833333333335in</property>
+ </column>
+ <row id="142">
+ <cell id="258"/>
+ <cell id="143">
+ <auto-text id="144">
+ <property name="textAlign">right</property>
+ <property name="type">page-number</property>
+ </auto-text>
+ </cell>
+ <cell id="145">
+ <text id="146">
+ <property name="textAlign">center</property>
+ <property name="contentType">plain</property>
+ <text-property name="content"><![CDATA[of]]></text-property>
+ </text>
+ </cell>
+ <cell id="147">
+ <property name="textAlign">right</property>
+ <auto-text id="148">
+ <property name="textAlign">left</property>
+ <property name="type">total-page</property>
+ </auto-text>
+ </cell>
+ <cell id="259">
+ <property name="textAlign">right</property>
+ </cell>
+ </row>
+ </grid>
+ </page-footer>
+ </simple-master-page>
+ </page-setup>
+ <body>
+ <label id="38">
+ <property name="fontWeight">bold</property>
+ <property name="fontStyle">italic</property>
+ <property name="paddingTop">10pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingRevenues");]]></method>
+ <text-property name="text">Revenues</text-property>
+ </label>
+ <table id="154">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <property name="width">7.947916666666667in</property>
+ <property name="dataSet">Revenue</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">glAccountId</property>
+ <text-property name="displayName">Account ID</text-property>
+ <expression name="expression">dataSetRow["glAccountId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">accountCode</property>
+ <text-property name="displayName">Account Code</text-property>
+ <expression name="expression" type="javascript">dataSetRow["accountCode"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">accountName</property>
+ <text-property name="displayName">Account Name</text-property>
+ <expression name="expression" type="javascript">dataSetRow["accountName"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">balance</property>
+ <text-property name="displayName">Balance</text-property>
+ <expression name="expression">dataSetRow["balance"]</expression>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="name">RevenueTotalBalance</property>
+ <property name="dataType">float</property>
+ <property name="aggregateFunction">SUM</property>
+ <list-property name="arguments">
+ <structure>
+ <property name="name">Expression</property>
+ <expression name="value" type="javascript">row["balance"]</expression>
+ </structure>
+ </list-property>
+ </structure>
+ </list-property>
+ <column id="179">
+ <property name="width">1.3020833333333333in</property>
+ </column>
+ <column id="180">
+ <property name="width">4.71875in</property>
+ </column>
+ <column id="181">
+ <property name="width">1.7916666666666667in</property>
+ </column>
+ <header>
+ <row id="155">
+ <property name="backgroundColor">#BFBFBF</property>
+ <property name="fontWeight">bold</property>
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <property name="textAlign">center</property>
+ <cell id="158">
+ <label id="159">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method>
+ <text-property name="text">Account Code</text-property>
+ </label>
+ </cell>
+ <cell id="160">
+ <label id="161">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method>
+ <text-property name="text">Account Name</text-property>
+ </label>
+ </cell>
+ <cell id="162">
+ <label id="163">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_balance");]]></method>
+ <text-property name="text">Balance</text-property>
+ </label>
+ </cell>
+ </row>
+ </header>
+ <detail>
+ <row id="164">
+ <cell id="167">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <data id="168">
+ <property name="resultSetColumn">accountCode</property>
+ </data>
+ </cell>
+ <cell id="169">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <data id="170">
+ <property name="resultSetColumn">accountName</property>
+ </data>
+ </cell>
+ <cell id="171">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <data id="172">
+ <structure name="numberFormat">
+ <property name="category">Currency</property>
+ <property name="pattern">#,##0.00</property>
+ </structure>
+ <property name="textAlign">right</property>
+ <property name="resultSetColumn">balance</property>
+ </data>
+ </cell>
+ </row>
+ </detail>
+ </table>
+ <label id="182">
+ <property name="fontWeight">bold</property>
+ <property name="fontStyle">italic</property>
+ <property name="paddingTop">10pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingExpenses");]]></method>
+ <text-property name="text">Expenses</text-property>
+ </label>
+ <table id="183">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <property name="width">7.947916666666667in</property>
+ <property name="dataSet">Expense</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">glAccountId</property>
+ <text-property name="displayName">Account ID</text-property>
+ <expression name="expression">dataSetRow["glAccountId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">accountCode</property>
+ <text-property name="displayName">Account Code</text-property>
+ <expression name="expression" type="javascript">dataSetRow["accountCode"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">accountName</property>
+ <text-property name="displayName">Account Name</text-property>
+ <expression name="expression" type="javascript">dataSetRow["accountName"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">balance</property>
+ <text-property name="displayName">Balance</text-property>
+ <expression name="expression">dataSetRow["balance"]</expression>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="name">ExpenseTotalBalance</property>
+ <property name="dataType">float</property>
+ <property name="aggregateFunction">SUM</property>
+ <list-property name="arguments">
+ <structure>
+ <property name="name">Expression</property>
+ <expression name="value" type="javascript">row["balance"]</expression>
+ </structure>
+ </list-property>
+ </structure>
+ </list-property>
+ <column id="208">
+ <property name="width">1.3125in</property>
+ </column>
+ <column id="209">
+ <property name="width">4.802083333333333in</property>
+ </column>
+ <column id="210">
+ <property name="width">1.7916666666666667in</property>
+ </column>
+ <header>
+ <row id="184">
+ <property name="backgroundColor">#BFBFBF</property>
+ <property name="fontWeight">bold</property>
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <property name="textAlign">center</property>
+ <cell id="187">
+ <label id="188">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method>
+ <text-property name="text">Account Code</text-property>
+ </label>
+ </cell>
+ <cell id="189">
+ <label id="190">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method>
+ <text-property name="text">Account Name</text-property>
+ </label>
+ </cell>
+ <cell id="191">
+ <label id="192">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_balance");]]></method>
+ <text-property name="text">Balance</text-property>
+ </label>
+ </cell>
+ </row>
+ </header>
+ <detail>
+ <row id="193">
+ <cell id="196">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <data id="197">
+ <property name="resultSetColumn">accountCode</property>
+ </data>
+ </cell>
+ <cell id="198">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <data id="199">
+ <property name="resultSetColumn">accountName</property>
+ </data>
+ </cell>
+ <cell id="200">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <data id="201">
+ <structure name="numberFormat">
+ <property name="category">Currency</property>
+ <property name="pattern">#,##0.00</property>
+ </structure>
+ <property name="textAlign">right</property>
+ <property name="resultSetColumn">balance</property>
+ </data>
+ </cell>
+ </row>
+ </detail>
+ </table>
+ <label id="211">
+ <property name="fontWeight">bold</property>
+ <property name="fontStyle">italic</property>
+ <property name="paddingTop">10pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingIncome");]]></method>
+ <text-property name="text">Incomes</text-property>
+ </label>
+ <table id="212">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <property name="width">7.947916666666667in</property>
+ <property name="dataSet">Income</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">glAccountId</property>
+ <text-property name="displayName">Account ID</text-property>
+ <expression name="expression">dataSetRow["glAccountId"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">accountCode</property>
+ <text-property name="displayName">Account Code</text-property>
+ <expression name="expression" type="javascript">dataSetRow["accountCode"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">accountName</property>
+ <text-property name="displayName">Account Name</text-property>
+ <expression name="expression" type="javascript">dataSetRow["accountName"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">balance</property>
+ <text-property name="displayName">Balance</text-property>
+ <expression name="expression">dataSetRow["balance"]</expression>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property name="name">IncomeTotalBalance</property>
+ <property name="dataType">float</property>
+ <property name="aggregateFunction">SUM</property>
+ <list-property name="arguments">
+ <structure>
+ <property name="name">Expression</property>
+ <expression name="value" type="javascript">row["balance"]</expression>
+ </structure>
+ </list-property>
+ </structure>
+ </list-property>
+ <column id="237">
+ <property name="width">1.28125in</property>
+ </column>
+ <column id="238">
+ <property name="width">4.75in</property>
+ </column>
+ <column id="239">
+ <property name="width">1.78125in</property>
+ </column>
+ <header>
+ <row id="213">
+ <property name="backgroundColor">#BFBFBF</property>
+ <property name="fontWeight">bold</property>
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <property name="textAlign">center</property>
+ <cell id="216">
+ <label id="217">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method>
+ <text-property name="text">Account Code</text-property>
+ </label>
+ </cell>
+ <cell id="218">
+ <label id="219">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method>
+ <text-property name="text">Account Name</text-property>
+ </label>
+ </cell>
+ <cell id="220">
+ <label id="221">
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_balance");]]></method>
+ <text-property name="text">Balance</text-property>
+ </label>
+ </cell>
+ </row>
+ </header>
+ <detail>
+ <row id="222">
+ <cell id="225">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <data id="226">
+ <property name="resultSetColumn">accountCode</property>
+ </data>
+ </cell>
+ <cell id="227">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <data id="228">
+ <property name="resultSetColumn">accountName</property>
+ </data>
+ </cell>
+ <cell id="229">
+ <property name="borderBottomColor">#000000</property>
+ <property name="borderBottomStyle">solid</property>
+ <property name="borderBottomWidth">thin</property>
+ <property name="borderLeftColor">#000000</property>
+ <property name="borderLeftStyle">solid</property>
+ <property name="borderLeftWidth">thin</property>
+ <property name="borderRightColor">#000000</property>
+ <property name="borderRightStyle">solid</property>
+ <property name="borderRightWidth">thin</property>
+ <property name="borderTopColor">#000000</property>
+ <property name="borderTopStyle">solid</property>
+ <property name="borderTopWidth">thin</property>
+ <data id="230">
+ <structure name="numberFormat">
+ <property name="category">Currency</property>
+ <property name="pattern">#,##0.00</property>
+ </structure>
+ <property name="textAlign">right</property>
+ <property name="resultSetColumn">balance</property>
+ </data>
+ </cell>
+ </row>
+ </detail>
+ </table>
+ <label id="261">
+ <property name="fontSize">10pt</property>
+ <property name="fontWeight">bold</property>
+ <property name="fontStyle">italic</property>
+ <property name="paddingTop">10pt</property>
+ <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonTotal");]]></method>
+ <text-property name="text">Total</text-property>
+ </label>
+ <table id="262">
+ <property name="width">7.959595959595959in</property>
+ <property name="dataSet">BalanceTotal</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property name="name">totalName</property>
+ <text-property name="displayName">Total Name</text-property>
+ <expression name="expression">dataSetRow["totalName"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property name="name">balance</property>
+ <text-property name="displayName">Balance</text-property>
+ <expression name="expression">dataSetRow["balance"]</expression>
+ <property name="dataType">decimal</property>
+ </structure>
+ </list-property>
+ <column id="276">
+ <property name="width">2.8585858585858586in</property>
+ </column>
+ <column id="277">
+ <property name="width">5.101010101010101in</property>
+ </column>
+ <detail>
+ <row id="268">
+ <cell id="269">
+ <data id="270">
+ <method name="onRender"><![CDATA[var text = uiLabelMap.get(this.getValue());
+this.setDisplayValue(text);]]></method>
+ <property name="resultSetColumn">totalName</property>
+ </data>
+ </cell>
+ <cell id="271">
+ <data id="272">
+ <structure name="numberFormat">
+ <property name="category">Currency</property>
+ <property name="pattern">#,##0.00</property>
+ </structure>
+ <property name="resultSetColumn">balance</property>
+ </data>
+ </cell>
+ </row>
+ </detail>
+ <footer>
+ <row id="273">
+ <cell id="274"/>
+ <cell id="275"/>
+ </row>
+ </footer>
+ </table>
+ </body>
+</report>