<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 4.7.0.v201706222054</property>
    <list-property name="propertyBindings">
        <structure>
            <property name="name">odaURL</property>
            <property name="id">209</property>
            <expression name="value" type="javascript">params["DBName"].value</expression>
        </structure>
        <structure>
            <property name="name">odaUser</property>
            <property name="id">209</property>
            <expression name="value" type="javascript">params["UserName"].value</expression>
        </structure>
        <structure>
            <property name="name">odaPassword</property>
            <property name="id">209</property>
            <expression name="value" type="javascript">params["Password"].value</expression>
        </structure>
    </list-property>
    <property name="units">in</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="layoutPreference">fixed layout</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <parameters>
        <scalar-parameter name="AccountingReportId" id="570">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">true</property>
            <property name="dataType">decimal</property>
            <property name="distinct">true</property>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="concealValue">false</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="DBName" id="3033">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">jdbc:postgresql://localhost:5432/axelor-open-suite</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="UserName" id="3034">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">axelor</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="Password" id="3035">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="Locale" id="4050">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">fr</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="AttachmentPath" id="3818">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant"></value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="209">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>disabledMetadataBidiFormatStr</name>
                </ex-property>
                <ex-property>
                    <name>disabledContentBidiFormatStr</name>
                </ex-property>
                <ex-property>
                    <name>contentBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>metadataBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
            </list-property>
            <property name="odaDriverClass">org.postgresql.Driver</property>
            <property name="odaURL">jdbc:postgresql://localhost:5432/axelor-open-suite</property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="MoveLineDS" id="210">
            <property name="nullsOrdering">nulls lowest</property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">moveline_id</property>
                    <property name="alias">moveline_id</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">moveline_id</text-property>
                    <property name="onColumnLayout">false</property>
                    <text-property name="heading">moveline_id</text-property>
                </structure>
                <structure>
                    <property name="columnName">move_line_name</property>
                    <property name="alias">move_line_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">move_line_name</text-property>
                    <property name="onColumnLayout">false</property>
                    <text-property name="heading">move_line_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">move_line_description</property>
                    <property name="alias">move_line_description</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">move_line_description</text-property>
                    <property name="onColumnLayout">false</property>
                    <text-property name="heading">move_line_description</text-property>
                </structure>
                <structure>
                    <property name="columnName">date_val</property>
                    <property name="alias">date_val</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">date_val</text-property>
                    <property name="onColumnLayout">false</property>
                    <text-property name="heading">date_val</text-property>
                </structure>
                <structure>
                    <property name="columnName">partner</property>
                    <property name="alias">partner</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">partner</text-property>
                    <property name="onColumnLayout">false</property>
                    <text-property name="heading">partner</text-property>
                </structure>
                <structure>
                    <property name="columnName">account</property>
                    <property name="alias">account</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">account</text-property>
                    <property name="onColumnLayout">false</property>
                    <text-property name="heading">account</text-property>
                </structure>
                <structure>
                    <property name="columnName">debit</property>
                    <property name="alias">debit</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">debit</text-property>
                    <property name="onColumnLayout">false</property>
                    <text-property name="heading">debit</text-property>
                </structure>
                <structure>
                    <property name="columnName">credit</property>
                    <property name="alias">credit</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">credit</text-property>
                    <property name="onColumnLayout">false</property>
                    <text-property name="heading">credit</text-property>
                </structure>
                <structure>
                    <property name="columnName">reconcile_group_code</property>
                    <property name="alias">reconcile_group_code</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">reconcile_group_code</text-property>
                    <text-property name="heading">reconcile_group_code</text-property>
                </structure>
                <structure>
                    <property name="columnName">due_date</property>
                    <property name="alias">due_date</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">due_date</text-property>
                    <text-property name="heading">due_date</text-property>
                </structure>
                <structure>
                    <property name="columnName">journal_code</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">journal_code</text-property>
                    <text-property name="heading">journal_code</text-property>
                </structure>
                <structure>
                    <property name="columnName">amount_remaining</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">amount_remaining</text-property>
                    <text-property name="heading">amount_remaining</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">AccountingReportId</property>
                    <property name="nativeName"></property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                    <property name="position">1</property>
                    <property name="isOptional">false</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">moveline_id</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">move_line_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">move_line_description</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">date_val</property>
                        <property name="dataType">date</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">partner</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">account</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">debit</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">credit</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">reconcile_group_code</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">due_date</property>
                        <property name="dataType">date</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">journal_code</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">amount_remaining</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="rowFetchLimit">0</property>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">moveline_id</property>
                    <property name="nativeName">moveline_id</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">move_line_name</property>
                    <property name="nativeName">move_line_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">move_line_description</property>
                    <property name="nativeName">move_line_description</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">date_val</property>
                    <property name="nativeName">date_val</property>
                    <property name="dataType">date</property>
                    <property name="nativeDataType">91</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">partner</property>
                    <property name="nativeName">partner</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">account</property>
                    <property name="nativeName">account</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">debit</property>
                    <property name="nativeName">debit</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">2</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">credit</property>
                    <property name="nativeName">credit</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">2</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">reconcile_group_code</property>
                    <property name="nativeName">reconcile_group_code</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">due_date</property>
                    <property name="nativeName">due_date</property>
                    <property name="dataType">date</property>
                    <property name="nativeDataType">91</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">journal_code</property>
                    <property name="nativeName">journal_code</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">amount_remaining</property>
                    <property name="nativeName">amount_remaining</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">2</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select DISTINCT MoveLine.id as moveLine_id, MoveLine.name as move_line_name, MoveLine.description as move_line_description,
MoveLine.date_val, MoveLine.partner_full_name as partner,
CONCAT(MoveLine.account_code, ' ', MoveLine.account_name) as account,
MoveLine.debit, MoveLine.credit, ReconcileGroup.code as reconcile_group_code, MoveLine.due_date, Journal.code as journal_code,
MoveLine.amount_remaining

from public.account_accounting_report as AccountingReport
left outer join public.account_move_line as MoveLine on (AccountingReport.id = ?)
left outer join public.account_move as Move on (MoveLine.move = Move.id  AND Move.ignore_in_accounting_ok = false) 
left outer join public.account_reconcile_group as ReconcileGroup on (ReconcileGroup.id = MoveLine.reconcile_group)

left outer join public.account_account as Account on (MoveLine.account  = Account.id )
left outer join public.account_account as ParentAccount on (Account.parent_account  = ParentAccount.id )
left outer join public.account_account as ParentAccount2 on (ParentAccount.parent_account  = ParentAccount2.id )
left outer join public.account_account as ParentAccount3 on (ParentAccount2.parent_account  = ParentAccount3.id )
left outer join public.account_account as ParentAccount4 on (ParentAccount3.parent_account  = ParentAccount4.id )
left outer join public.account_account as ParentAccount5 on (ParentAccount4.parent_account  = ParentAccount5.id )
left outer join public.account_account as ParentAccount6 on (ParentAccount5.parent_account  = ParentAccount6.id )

left outer join public.account_accounting_report_account_set as AccountSet on (AccountSet.account_accounting_report = AccountingReport.id)
left outer join public.account_accounting_report_partner_set as PartnerSet on (PartnerSet.account_accounting_report = AccountingReport.id)

left outer join public.base_company as Company on (AccountingReport.company = Company.id)
left outer join public.account_account_config as AccountConfig on (AccountConfig.company = Company.id)
left outer join public.base_period as Period on (Move.period = Period.id) 
left outer join public.account_journal as Journal on (Move.journal = Journal.id) 
where 
(AccountingReport.currency = Move.company_currency) AND
(AccountingReport.date_from IS NULL OR MoveLine.date_val >= AccountingReport.date_from) AND
(AccountingReport.date_to IS NULL OR MoveLine.date_val <= AccountingReport.date_to) AND
MoveLine.date_val <= AccountingReport.date_val AND
Move.company = AccountingReport.company AND
(AccountSet.account_set IS NULL OR AccountSet.account_set = Account.id or AccountSet.account_set = ParentAccount.id 
    or AccountSet.account_set = ParentAccount2.id or AccountSet.account_set = ParentAccount3.id
    or AccountSet.account_set = ParentAccount4.id or AccountSet.account_set = ParentAccount5.id 
    or AccountSet.account_set = ParentAccount6.id or AccountSet.account_set = ParentAccount6.parent_account) AND(PartnerSet.partner_set IS NULL OR PartnerSet.partner_set = MoveLine.partner) AND
(AccountingReport.period IS NULL OR AccountingReport.period  = Move.period) AND
(AccountingReport.journal IS NULL OR AccountingReport.journal  = Move.journal) AND
(AccountingReport.payment_mode IS  NULL OR (AccountingReport.payment_mode = Move.payment_mode)) AND
Move.ignore_in_accounting_ok = false AND (Move.status_select = 3 OR Move.status_select = 2)
AND (AccountingReport.type_select = 1 OR (AccountingReport.type_select != 1 AND Account.use_for_partner_balance is true))
AND (AccountingReport.display_closing_accounting_moves is true 
	OR(AccountingReport.display_closing_accounting_moves is false 
		AND (Move.functional_origin_select IS NULL OR Move.functional_origin_select != 2)))
AND (AccountingReport.display_opening_accounting_moves is true 
	OR(AccountingReport.display_opening_accounting_moves is false 
		AND (Move.functional_origin_select IS NULL OR Move.functional_origin_select != 1)))
order by account, MoveLine.date_val, MoveLine.name]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="AccountingReportDS" id="489">
            <property name="nullsOrdering">nulls lowest</property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">company_name</property>
                    <property name="alias">company_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">company_name</text-property>
                    <text-property name="heading">company_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">date_from</property>
                    <property name="alias">date_from</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">date_from</text-property>
                    <text-property name="heading">date_from</text-property>
                </structure>
                <structure>
                    <property name="columnName">date_to</property>
                    <property name="alias">date_to</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">date_to</text-property>
                    <text-property name="heading">date_to</text-property>
                </structure>
                <structure>
                    <property name="columnName">report_date</property>
                    <property name="alias">report_date</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">report_date</text-property>
                    <text-property name="heading">report_date</text-property>
                </structure>
                <structure>
                    <property name="columnName">report_date_edition</property>
                    <property name="alias">report_date_edition</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">report_date_edition</text-property>
                    <text-property name="heading">report_date_edition</text-property>
                </structure>
                <structure>
                    <property name="columnName">logo_path</property>
                    <property name="alias">logo_path</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">logo_path</text-property>
                    <text-property name="heading">logo_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">period_name</property>
                    <property name="alias">period_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">period_name</text-property>
                    <text-property name="heading">period_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">journal_name</property>
                    <property name="alias">journal_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">journal_name</text-property>
                    <text-property name="heading">journal_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">global</property>
                    <property name="alias">global</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">global</text-property>
                    <text-property name="heading">global</text-property>
                </structure>
                <structure>
                    <property name="columnName">global_by_date</property>
                    <property name="alias">global_by_date</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">global_by_date</text-property>
                    <text-property name="heading">global_by_date</text-property>
                </structure>
                <structure>
                    <property name="columnName">global_by_partner</property>
                    <property name="alias">global_by_partner</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">global_by_partner</text-property>
                    <text-property name="heading">global_by_partner</text-property>
                </structure>
                <structure>
                    <property name="columnName">display_only_not_completely_lettered_move_lines</property>
                    <property name="alias">display_only_not_completely_lettered_move_lines</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">display_only_not_completely_lettered_move_lines</text-property>
                    <text-property name="heading">display_only_not_completely_lettered_move_lines</text-property>
                </structure>
                <structure>
                    <property name="columnName">payment_mode</property>
                    <property name="alias">payment_mode</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">payment_mode</text-property>
                    <text-property name="heading">payment_mode</text-property>
                </structure>
                <structure>
                    <property name="columnName">currency</property>
                    <property name="alias">currency</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">currency</text-property>
                    <text-property name="heading">currency</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">AccountingReportId</property>
                    <property name="nativeName"></property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                    <property name="position">1</property>
                    <property name="isOptional">false</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">company_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">date_from</property>
                        <property name="dataType">date</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">date_to</property>
                        <property name="dataType">date</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">report_date</property>
                        <property name="dataType">date</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">report_date_edition</property>
                        <property name="dataType">date-time</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">logo_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">period_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">journal_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">global</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">global_by_date</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">global_by_partner</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">display_only_not_completely_lettered_move_lines</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">13</property>
                        <property name="name">display_cumulative_balance</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">14</property>
                        <property name="name">payment_mode</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">15</property>
                        <property name="name">currency</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">company_name</property>
                    <property name="nativeName">company_name</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">date_from</property>
                    <property name="nativeName">date_from</property>
                    <property name="dataType">date</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">date_to</property>
                    <property name="nativeName">date_to</property>
                    <property name="dataType">date</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">report_date</property>
                    <property name="nativeName">report_date</property>
                    <property name="dataType">date</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">report_date_edition</property>
                    <property name="nativeName">report_date_edition</property>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">logo_path</property>
                    <property name="nativeName">logo_path</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">period_name</property>
                    <property name="nativeName">period_name</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">journal_name</property>
                    <property name="nativeName">journal_name</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">global</property>
                    <property name="nativeName">global</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">global_by_date</property>
                    <property name="nativeName">global_by_date</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">global_by_partner</property>
                    <property name="nativeName">global_by_partner</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">display_only_not_completely_lettered_move_lines</property>
                    <property name="nativeName">display_only_not_completely_lettered_move_lines</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">13</property>
                    <property name="name">display_cumulative_balance</property>
                    <property name="nativeName">display_cumulative_balance</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">14</property>
                    <property name="name">payment_mode</property>
                    <property name="nativeName">payment_mode</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">15</property>
                    <property name="name">currency</property>
                    <property name="nativeName">currency</property>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select 
Company.name as company_name, 
AccountingReport.date_from, 
AccountingReport.date_to, 
AccountingReport.date_val as report_date,
AccountingReport.publication_date_time as report_date_edition, 
MetaFile.file_path as logo_path,
Period.name as period_name, 
Journal.name as journal_name, 
AccountingReport.global, 
AccountingReport.global_by_date,
AccountingReport.global_by_partner,
AccountingReport.display_only_not_completely_lettered_move_lines,
AccountingReport.display_cumulative_balance,
PaymentMode.name as payment_mode, 
Currency.code as currency
from public.account_accounting_report as AccountingReport
inner join public.base_company as Company on (AccountingReport.company = Company.id)
left outer join meta_file as MetaFile on (MetaFile.id = Company.logo)
left outer join public.account_payment_mode as PaymentMode on (AccountingReport.payment_mode = PaymentMode.id)
left outer join public.account_journal as Journal on (AccountingReport.journal = Journal.id)
left outer join public.base_period as Period on (AccountingReport.period = Period.id)
left outer join base_currency as Currency on AccountingReport.currency = Currency.id
where AccountingReport.id = ? ]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="TranslateDS" id="3669">
            <property name="nullsOrdering">nulls lowest</property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">message_key</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">message_key</text-property>
                    <text-property name="heading">message_key</text-property>
                </structure>
                <structure>
                    <property name="columnName">translation</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">translation</text-property>
                    <text-property name="heading">translation</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">-1</property>
                    <property name="position">1</property>
                    <property name="isInput">true</property>
                </structure>
                <structure>
                    <property name="name">param_2</property>
                    <property name="paramName">Locale</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">-1</property>
                    <property name="position">2</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">message_key</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">translation</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">message_key</property>
                    <property name="nativeName">message_key</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">translation</property>
                    <property name="nativeName">translation</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select LangTranslate.message_key, LangTranslate.message_value as "translation" 
from meta_translation as LangTranslate 
where LangTranslate.message_key = ? and LangTranslate.language = ?]]></xml-property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>2.0</Version>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>-1</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>2</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>-1</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
</model:DesignValues>]]></xml-property>
        </oda-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="type">a4</property>
            <property name="orientation">landscape</property>
            <property name="headerHeight">0.5in</property>
            <property name="footerHeight">0.33in</property>
            <page-header>
                <grid id="3117">
                    <property name="width">11.033333333333333in</property>
                    <property name="dataSet">AccountingReportDS</property>
                    <list-property name="boundDataColumns">
                        <structure>
                            <property name="name">company_name</property>
                            <text-property name="displayName">company_name</text-property>
                            <expression name="expression" type="javascript">dataSetRow["company_name"]</expression>
                            <property name="dataType">string</property>
                        </structure>
                        <structure>
                            <property name="name">date_from</property>
                            <text-property name="displayName">date_from</text-property>
                            <expression name="expression" type="javascript">dataSetRow["date_from"]</expression>
                            <property name="dataType">date</property>
                        </structure>
                        <structure>
                            <property name="name">date_to</property>
                            <text-property name="displayName">date_to</text-property>
                            <expression name="expression" type="javascript">dataSetRow["date_to"]</expression>
                            <property name="dataType">date</property>
                        </structure>
                        <structure>
                            <property name="name">report_date</property>
                            <text-property name="displayName">report_date</text-property>
                            <expression name="expression" type="javascript">dataSetRow["report_date"]</expression>
                            <property name="dataType">date</property>
                        </structure>
                        <structure>
                            <property name="name">report_date_edition</property>
                            <text-property name="displayName">report_date_edition</text-property>
                            <expression name="expression" type="javascript">dataSetRow["report_date_edition"]</expression>
                            <property name="dataType">date-time</property>
                        </structure>
                        <structure>
                            <property name="name">period_name</property>
                            <text-property name="displayName">period_name</text-property>
                            <expression name="expression" type="javascript">dataSetRow["period_name"]</expression>
                            <property name="dataType">string</property>
                        </structure>
                        <structure>
                            <property name="name">journal_name</property>
                            <text-property name="displayName">journal_name</text-property>
                            <expression name="expression" type="javascript">dataSetRow["journal_name"]</expression>
                            <property name="dataType">string</property>
                        </structure>
                        <structure>
                            <property name="name">global</property>
                            <text-property name="displayName">global</text-property>
                            <expression name="expression" type="javascript">dataSetRow["global"]</expression>
                            <property name="dataType">integer</property>
                        </structure>
                        <structure>
                            <property name="name">global_by_date</property>
                            <text-property name="displayName">global_by_date</text-property>
                            <expression name="expression" type="javascript">dataSetRow["global_by_date"]</expression>
                            <property name="dataType">integer</property>
                        </structure>
                        <structure>
                            <property name="name">payment_mode</property>
                            <text-property name="displayName">payment_mode</text-property>
                            <expression name="expression" type="javascript">dataSetRow["payment_mode"]</expression>
                            <property name="dataType">string</property>
                        </structure>
                        <structure>
                            <property name="name">logo_path</property>
                            <text-property name="displayName">logo_path</text-property>
                            <expression name="expression" type="javascript">dataSetRow["logo_path"]</expression>
                            <property name="dataType">string</property>
                        </structure>
                    </list-property>
                    <column id="4158">
                        <property name="width">2in</property>
                    </column>
                    <column id="3118">
                        <property name="width">7.9in</property>
                    </column>
                    <column id="3119">
                        <property name="width">1.1333333333333333in</property>
                    </column>
                    <row id="3120">
                        <property name="height">36px</property>
                        <cell id="4157">
                            <image id="3419">
                                <property name="overflow">hidden</property>
                                <property name="height">35px</property>
                                <property name="width">154px</property>
                                <structure name="toc"/>
                                <property name="source">file</property>
                                <property name="proportionalScale">true</property>
                                <expression name="uri" type="javascript">params["AttachmentPath"]+row["logo_path"]</expression>
                            </image>
                        </cell>
                        <cell id="3121">
                            <property name="verticalAlign">top</property>
                            <label id="3123">
                                <property name="fontSize">9pt</property>
                                <property name="textAlign">right</property>
                                <text-property name="text">Date d'édition : </text-property>
                            </label>
                        </cell>
                        <cell id="3122">
                            <property name="verticalAlign">top</property>
                            <text id="3128">
                                <property name="fontSize">9pt</property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF>row["report_date_edition"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                    </row>
                </grid>
            </page-header>
            <page-footer>
                <grid id="3098">
                    <property name="width">11.033333333333333in</property>
                    <column id="3099">
                        <property name="width">10.022222222222222in</property>
                    </column>
                    <column id="3100">
                        <property name="width">1.011111111111111in</property>
                    </column>
                    <row id="3101">
                        <cell id="3102"/>
                        <cell id="3103">
                            <grid id="3104">
                                <property name="textAlign">right</property>
                                <property name="height">0.3in</property>
                                <column id="3105"/>
                                <column id="3106"/>
                                <column id="3107"/>
                                <row id="3108">
                                    <property name="height">0.3333333333333333in</property>
                                    <cell id="3109">
                                        <property name="paddingTop">0pt</property>
                                        <property name="paddingLeft">0pt</property>
                                        <property name="paddingBottom">0pt</property>
                                        <property name="paddingRight">0pt</property>
                                        <auto-text id="3110">
                                            <property name="fontSize">9pt</property>
                                            <property name="type">page-number</property>
                                        </auto-text>
                                    </cell>
                                    <cell id="3111">
                                        <property name="paddingTop">0pt</property>
                                        <property name="paddingLeft">0pt</property>
                                        <property name="paddingBottom">0pt</property>
                                        <property name="paddingRight">0pt</property>
                                        <text id="3112">
                                            <property name="fontSize">9pt</property>
                                            <property name="textAlign">center</property>
                                            <property name="contentType">plain</property>
                                            <text-property name="content"><![CDATA[/]]></text-property>
                                        </text>
                                    </cell>
                                    <cell id="3113">
                                        <property name="paddingTop">0pt</property>
                                        <property name="paddingLeft">0pt</property>
                                        <property name="paddingBottom">0pt</property>
                                        <property name="paddingRight">0pt</property>
                                        <auto-text id="3114">
                                            <property name="fontSize">9pt</property>
                                            <property name="textAlign">left</property>
                                            <property name="type">total-page</property>
                                        </auto-text>
                                    </cell>
                                </row>
                            </grid>
                        </cell>
                    </row>
                </grid>
            </page-footer>
        </simple-master-page>
    </page-setup>
    <body>
        <grid id="491">
            <property name="width">11.1in</property>
            <property name="dataSet">AccountingReportDS</property>
            <list-property name="visibility"/>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">company_name</property>
                    <text-property name="displayName">company_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["company_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">date_from</property>
                    <text-property name="displayName">date_from</text-property>
                    <expression name="expression" type="javascript">dataSetRow["date_from"]</expression>
                    <property name="dataType">date</property>
                </structure>
                <structure>
                    <property name="name">date_to</property>
                    <text-property name="displayName">date_to</text-property>
                    <expression name="expression" type="javascript">dataSetRow["date_to"]</expression>
                    <property name="dataType">date</property>
                </structure>
                <structure>
                    <property name="name">report_date</property>
                    <text-property name="displayName">report_date</text-property>
                    <expression name="expression" type="javascript">dataSetRow["report_date"]</expression>
                    <property name="dataType">date</property>
                </structure>
                <structure>
                    <property name="name">report_date_edition</property>
                    <text-property name="displayName">report_date_edition</text-property>
                    <expression name="expression" type="javascript">dataSetRow["report_date_edition"]</expression>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="name">period_name</property>
                    <text-property name="displayName">period_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["period_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">journal_name</property>
                    <text-property name="displayName">journal_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["journal_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">global</property>
                    <text-property name="displayName">global</text-property>
                    <expression name="expression" type="javascript">dataSetRow["global"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">global_by_date</property>
                    <text-property name="displayName">global_by_date</text-property>
                    <expression name="expression" type="javascript">dataSetRow["global_by_date"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">payment_mode</property>
                    <text-property name="displayName">payment_mode</text-property>
                    <expression name="expression" type="javascript">dataSetRow["payment_mode"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">logo_path</property>
                    <text-property name="displayName">logo_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["logo_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">currency</property>
                    <text-property name="displayName">currency</text-property>
                    <expression name="expression" type="javascript">dataSetRow["currency"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">global_by_partner</property>
                    <text-property name="displayName">global_by_partner</text-property>
                    <expression name="expression" type="javascript">dataSetRow["global_by_partner"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">display_only_not_completely_lettered_move_lines</property>
                    <text-property name="displayName">display_only_not_completely_lettered_move_lines</text-property>
                    <expression name="expression" type="javascript">dataSetRow["display_only_not_completely_lettered_move_lines"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">display_cumulative_balance</property>
                    <text-property name="displayName">display_cumulative_balance</text-property>
                    <expression name="expression" type="javascript">dataSetRow["display_cumulative_balance"]</expression>
                    <property name="dataType">integer</property>
                </structure>
            </list-property>
            <column id="492">
                <property name="width">1.6in</property>
            </column>
            <column id="3072">
                <property name="width">1.6in</property>
            </column>
            <column id="493">
                <property name="width">1.6in</property>
            </column>
            <column id="4126">
                <property name="width">1.6in</property>
            </column>
            <column id="4137">
                <property name="width">1.6in</property>
            </column>
            <column id="494">
                <property name="width">1.6in</property>
            </column>
            <column id="495">
                <property name="width">1.6in</property>
            </column>
            <row id="1246">
                <property name="height">0.3020833333333333in</property>
                <cell id="1247">
                    <property name="colSpan">7</property>
                    <property name="rowSpan">1</property>
                    <text id="4001">
                        <property name="fontSize">14pt</property>
                        <property name="fontWeight">bold</property>
                        <property name="borderBottomStyle">none</property>
                        <property name="borderLeftStyle">none</property>
                        <property name="borderRightStyle">none</property>
                        <property name="borderTopStyle">none</property>
                        <property name="textAlign">center</property>
                        <property name="dataSet">TranslateDS</property>
                        <list-property name="paramBindings">
                            <structure>
                                <property name="paramName">param_1</property>
                                <simple-property-list name="expression">
                                    <value type="javascript">'AccountingReportType7.title'</value>
                                </simple-property-list>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">key</property>
                                <text-property name="displayName">key</text-property>
                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">translation</property>
                                <text-property name="displayName">translation</text-property>
                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                    </text>
                </cell>
            </row>
            <row id="549">
                <property name="height">0.1in</property>
                <cell id="550"/>
                <cell id="3062"/>
                <cell id="551"/>
                <cell id="4117"/>
                <cell id="4128"/>
                <cell id="552"/>
                <cell id="553"/>
            </row>
            <row id="496">
                <property name="height">0.2604166666666667in</property>
                <cell id="497">
                    <text id="4192">
                        <property name="fontSize">10pt</property>
                        <property name="fontWeight">normal</property>
                        <property name="borderBottomStyle">none</property>
                        <property name="borderLeftStyle">none</property>
                        <property name="borderRightStyle">none</property>
                        <property name="borderTopStyle">none</property>
                        <property name="textAlign">right</property>
                        <property name="dataSet">TranslateDS</property>
                        <list-property name="paramBindings">
                            <structure>
                                <property name="paramName">param_1</property>
                                <simple-property-list name="expression">
                                    <value type="javascript">'AccountingReportType7.company'</value>
                                </simple-property-list>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">key</property>
                                <text-property name="displayName">key</text-property>
                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">translation</property>
                                <text-property name="displayName">translation</text-property>
                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
                    </text>
                </cell>
                <cell id="3063">
                    <text id="554">
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["company_name"]</VALUE-OF>]]></text-property>
                    </text>
                </cell>
                <cell id="498"/>
                <cell id="4118">
                    <text id="4193">
                        <property name="fontSize">10pt</property>
                        <property name="fontWeight">normal</property>
                        <property name="borderBottomStyle">none</property>
                        <property name="borderLeftStyle">none</property>
                        <property name="borderRightStyle">none</property>
                        <property name="borderTopStyle">none</property>
                        <property name="textAlign">right</property>
                        <property name="dataSet">TranslateDS</property>
                        <list-property name="paramBindings">
                            <structure>
                                <property name="paramName">param_1</property>
                                <simple-property-list name="expression">
                                    <value type="javascript">'AccountingReportType7.endDate'</value>
                                </simple-property-list>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">key</property>
                                <text-property name="displayName">key</text-property>
                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">translation</property>
                                <text-property name="displayName">translation</text-property>
                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
                    </text>
                </cell>
                <cell id="4129">
                    <text id="3078">
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF format="dd/MM/yyyy">row["report_date"]</VALUE-OF>]]></text-property>
                    </text>
                </cell>
                <cell id="499">
                    <text id="4196">
                        <property name="fontSize">10pt</property>
                        <property name="fontWeight">normal</property>
                        <property name="borderBottomStyle">none</property>
                        <property name="borderLeftStyle">none</property>
                        <property name="borderRightStyle">none</property>
                        <property name="borderTopStyle">none</property>
                        <property name="textAlign">right</property>
                        <property name="dataSet">TranslateDS</property>
                        <list-property name="paramBindings">
                            <structure>
                                <property name="paramName">param_1</property>
                                <simple-property-list name="expression">
                                    <value type="javascript">'AccountingReportType7.period'</value>
                                </simple-property-list>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">key</property>
                                <text-property name="displayName">key</text-property>
                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">translation</property>
                                <text-property name="displayName">translation</text-property>
                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
                    </text>
                </cell>
                <cell id="500">
                    <text id="555">
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["period_name"]</VALUE-OF>]]></text-property>
                    </text>
                </cell>
            </row>
            <row id="501">
                <cell id="502">
                    <text id="4210">
                        <property name="fontSize">10pt</property>
                        <property name="fontWeight">normal</property>
                        <property name="borderBottomStyle">none</property>
                        <property name="borderLeftStyle">none</property>
                        <property name="borderRightStyle">none</property>
                        <property name="borderTopStyle">none</property>
                        <property name="textAlign">right</property>
                        <property name="dataSet">TranslateDS</property>
                        <list-property name="paramBindings">
                            <structure>
                                <property name="paramName">param_1</property>
                                <simple-property-list name="expression">
                                    <value type="javascript">'Currency'</value>
                                </simple-property-list>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">key</property>
                                <text-property name="displayName">key</text-property>
                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">translation</property>
                                <text-property name="displayName">translation</text-property>
                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
                    </text>
                </cell>
                <cell id="3064">
                    <text id="4219">
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["currency"]</VALUE-OF>]]></text-property>
                    </text>
                </cell>
                <cell id="503"/>
                <cell id="4119">
                    <text id="4195">
                        <property name="fontSize">10pt</property>
                        <property name="fontWeight">normal</property>
                        <property name="borderBottomStyle">none</property>
                        <property name="borderLeftStyle">none</property>
                        <property name="borderRightStyle">none</property>
                        <property name="borderTopStyle">none</property>
                        <property name="textAlign">right</property>
                        <property name="dataSet">TranslateDS</property>
                        <list-property name="paramBindings">
                            <structure>
                                <property name="paramName">param_1</property>
                                <simple-property-list name="expression">
                                    <value type="javascript">'AccountingReportType7.from'</value>
                                </simple-property-list>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">key</property>
                                <text-property name="displayName">key</text-property>
                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">translation</property>
                                <text-property name="displayName">translation</text-property>
                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
                    </text>
                </cell>
                <cell id="4130">
                    <text id="556">
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF  format="dd/MM/yyyy">row["date_from"]</VALUE-OF>]]></text-property>
                    </text>
                </cell>
                <cell id="504">
                    <text id="4197">
                        <property name="fontSize">10pt</property>
                        <property name="fontWeight">normal</property>
                        <property name="borderBottomStyle">none</property>
                        <property name="borderLeftStyle">none</property>
                        <property name="borderRightStyle">none</property>
                        <property name="borderTopStyle">none</property>
                        <property name="textAlign">right</property>
                        <property name="dataSet">TranslateDS</property>
                        <list-property name="paramBindings">
                            <structure>
                                <property name="paramName">param_1</property>
                                <simple-property-list name="expression">
                                    <value type="javascript">'AccountingReportType7.to'</value>
                                </simple-property-list>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">key</property>
                                <text-property name="displayName">key</text-property>
                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">translation</property>
                                <text-property name="displayName">translation</text-property>
                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
                    </text>
                </cell>
                <cell id="505">
                    <text id="557">
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF format="dd/MM/yyyy">row["date_to"]</VALUE-OF>]]></text-property>
                    </text>
                </cell>
            </row>
            <row id="4211">
                <cell id="4212">
                    <text id="4191">
                        <property name="fontSize">10pt</property>
                        <property name="fontWeight">normal</property>
                        <property name="borderBottomStyle">none</property>
                        <property name="borderLeftStyle">none</property>
                        <property name="borderRightStyle">none</property>
                        <property name="borderTopStyle">none</property>
                        <property name="textAlign">right</property>
                        <property name="dataSet">TranslateDS</property>
                        <list-property name="visibility">
                            <structure>
                                <property name="format">all</property>
                                <expression name="valueExpr" type="javascript">!row._outer["journal_name"]</expression>
                            </structure>
                        </list-property>
                        <list-property name="paramBindings">
                            <structure>
                                <property name="paramName">param_1</property>
                                <simple-property-list name="expression">
                                    <value type="javascript">'AccountingReportType7.journal'</value>
                                </simple-property-list>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">key</property>
                                <text-property name="displayName">key</text-property>
                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">translation</property>
                                <text-property name="displayName">translation</text-property>
                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> :]]></text-property>
                    </text>
                </cell>
                <cell id="4213">
                    <text id="559">
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["journal_name"]</VALUE-OF>]]></text-property>
                    </text>
                </cell>
                <cell id="4214"/>
                <cell id="4215"/>
                <cell id="4216"/>
                <cell id="4217"/>
                <cell id="4218"/>
            </row>
            <row id="506">
                <cell id="507">
                    <property name="colSpan">2</property>
                    <property name="rowSpan">1</property>
                </cell>
                <cell id="508"/>
                <cell id="4120"/>
                <cell id="4131"/>
                <cell id="509"/>
                <cell id="510"/>
            </row>
            <row id="544">
                <property name="pageBreakAfter">auto</property>
                <property name="pageBreakBefore">auto</property>
                <property name="pageBreakInside">auto</property>
                <cell id="545">
                    <property name="colSpan">7</property>
                    <property name="rowSpan">1</property>
                    <table id="4051">
                        <property name="pageBreakBefore">auto</property>
                        <property name="width">11in</property>
                        <property name="dataSet">MoveLineDS</property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">move_line_name</property>
                                <text-property name="displayName">move_line_name</text-property>
                                <expression name="expression" type="javascript">dataSetRow["move_line_name"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">move_line_description</property>
                                <text-property name="displayName">move_line_description</text-property>
                                <expression name="expression" type="javascript">dataSetRow["move_line_description"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">date_val</property>
                                <text-property name="displayName">date_val</text-property>
                                <expression name="expression" type="javascript">dataSetRow["date_val"]</expression>
                                <property name="dataType">date</property>
                            </structure>
                            <structure>
                                <property name="name">partner</property>
                                <text-property name="displayName">partner</text-property>
                                <expression name="expression" type="javascript">dataSetRow["partner"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">debit</property>
                                <text-property name="displayName">debit</text-property>
                                <expression name="expression" type="javascript">dataSetRow["debit"]</expression>
                                <property name="dataType">decimal</property>
                            </structure>
                            <structure>
                                <property name="name">credit</property>
                                <text-property name="displayName">credit</text-property>
                                <expression name="expression" type="javascript">dataSetRow["credit"]</expression>
                                <property name="dataType">decimal</property>
                            </structure>
                            <structure>
                                <property name="name">moveline_id</property>
                                <text-property name="displayName">moveline_id</text-property>
                                <expression name="expression" type="javascript">dataSetRow["moveline_id"]</expression>
                                <property name="dataType">decimal</property>
                            </structure>
                            <structure>
                                <property name="name">account</property>
                                <text-property name="displayName">account</text-property>
                                <expression name="expression" type="javascript">dataSetRow["account"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">sum_credit</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>account_group</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">row["credit"]</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">sum_debit</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>account_group</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">row["debit"]</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">balance</property>
                                <expression name="expression" type="javascript">if(row._outer["display_cumulative_balance"] == 1){
	vars["PreviousBalance"]+(dataSetRow["debit"]-dataSetRow["credit"])
}
else{
	dataSetRow["debit"]-dataSetRow["credit"]
}</expression>
                                <property name="dataType">float</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">sum_balance</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>account_group</value>
                                </simple-property-list>
                                <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>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">due_date</property>
                                <text-property name="displayName">due_date</text-property>
                                <expression name="expression" type="javascript">dataSetRow["due_date"]</expression>
                                <property name="dataType">date</property>
                            </structure>
                            <structure>
                                <property name="name">reconcile_group_code</property>
                                <text-property name="displayName">reconcile_group_code</text-property>
                                <expression name="expression" type="javascript">dataSetRow["reconcile_group_code"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">journal_code</property>
                                <text-property name="displayName">journal_code</text-property>
                                <expression name="expression" type="javascript">dataSetRow["journal_code"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">journal_code1</property>
                                <text-property name="displayName">journal_code</text-property>
                                <expression name="expression" type="javascript">row["journal_code"]</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">sum_debit_partner</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>partner_group</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">row["debit"]</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">sum_credit_partner</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>partner_group</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">row["credit"]</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">sum_balance_partner</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>partner_group</value>
                                </simple-property-list>
                                <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>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">amount_remaining</property>
                                <text-property name="displayName">amount_remaining</text-property>
                                <expression name="expression" type="javascript">dataSetRow["amount_remaining"]</expression>
                                <property name="dataType">decimal</property>
                            </structure>
                        </list-property>
                        <property name="pageBreakInterval">0</property>
                        <list-property name="filter">
                            <structure>
                                <property name="operator">is-true</property>
                                <expression name="expr" type="javascript">(row["amount_remaining"] > 0 &amp;&amp; row._outer["display_only_not_completely_lettered_move_lines"]) || !row._outer["display_only_not_completely_lettered_move_lines"]</expression>
                                <property name="updateAggregation">true</property>
                            </structure>
                        </list-property>
                        <column id="4147">
                            <property name="width">2%</property>
                        </column>
                        <column id="4090">
                            <property name="width">15%</property>
                        </column>
                        <column id="4091">
                            <property name="width">8%</property>
                        </column>
                        <column id="4237">
                            <property name="width">8%</property>
                        </column>
                        <column id="4249">
                            <property name="width">10%</property>
                        </column>
                        <column id="4092">
                            <property name="width">29%</property>
                        </column>
                        <column id="4093">
                            <list-property name="visibility">
                                <structure>
                                    <property name="format">all</property>
                                    <expression name="valueExpr" type="javascript">row._outer["global_by_partner"]</expression>
                                </structure>
                            </list-property>
                            <property name="width">20%</property>
                        </column>
                        <column id="4095">
                            <property name="width">9%</property>
                        </column>
                        <column id="4096">
                            <property name="width">9%</property>
                        </column>
                        <column id="4153">
                            <property name="width">9%</property>
                        </column>
                        <column id="4225">
                            <property name="width">7%</property>
                        </column>
                        <header>
                            <row id="4052">
                                <cell id="4142"/>
                                <cell id="4053"/>
                                <cell id="4055">
                                    <text id="4207">
                                        <property name="fontSize">9.5pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="borderBottomStyle">none</property>
                                        <property name="borderLeftStyle">none</property>
                                        <property name="borderRightStyle">none</property>
                                        <property name="borderTopStyle">none</property>
                                        <property name="textAlign">center</property>
                                        <property name="dataSet">TranslateDS</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">'AccountingReportType7.date'</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">key</property>
                                                <text-property name="displayName">key</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">translation</property>
                                                <text-property name="displayName">translation</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                                <cell id="4232">
                                    <text id="4240">
                                        <property name="fontSize">9.5pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="borderBottomStyle">none</property>
                                        <property name="borderLeftStyle">none</property>
                                        <property name="borderRightStyle">none</property>
                                        <property name="borderTopStyle">none</property>
                                        <property name="textAlign">center</property>
                                        <property name="dataSet">TranslateDS</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">'AccountingReportType7.dueDate'</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">key</property>
                                                <text-property name="displayName">key</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">translation</property>
                                                <text-property name="displayName">translation</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                                <cell id="4244">
                                    <text id="4250">
                                        <property name="fontSize">9.5pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="borderBottomStyle">none</property>
                                        <property name="borderLeftStyle">none</property>
                                        <property name="borderRightStyle">none</property>
                                        <property name="borderTopStyle">none</property>
                                        <property name="textAlign">left</property>
                                        <property name="dataSet">TranslateDS</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">'AccountingReportType7.journalCode'</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">key</property>
                                                <text-property name="displayName">key</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">translation</property>
                                                <text-property name="displayName">translation</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                                <cell id="4057">
                                    <text id="4208">
                                        <property name="fontSize">9.5pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="borderBottomStyle">none</property>
                                        <property name="borderLeftStyle">none</property>
                                        <property name="borderRightStyle">none</property>
                                        <property name="borderTopStyle">none</property>
                                        <property name="textAlign">left</property>
                                        <property name="dataSet">TranslateDS</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">'AccountingReportType7.description'</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">key</property>
                                                <text-property name="displayName">key</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">translation</property>
                                                <text-property name="displayName">translation</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                                <cell id="4059">
                                    <text id="4209">
                                        <property name="fontSize">9.5pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="borderBottomStyle">none</property>
                                        <property name="borderLeftStyle">none</property>
                                        <property name="borderRightStyle">none</property>
                                        <property name="borderTopStyle">none</property>
                                        <property name="textAlign">left</property>
                                        <property name="dataSet">TranslateDS</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">'AccountingReportType7.partner'</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">key</property>
                                                <text-property name="displayName">key</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">translation</property>
                                                <text-property name="displayName">translation</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                                <cell id="4063">
                                    <text id="4205">
                                        <property name="fontSize">9.5pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="borderBottomStyle">none</property>
                                        <property name="borderLeftStyle">none</property>
                                        <property name="borderRightStyle">none</property>
                                        <property name="borderTopStyle">none</property>
                                        <property name="textAlign">right</property>
                                        <property name="dataSet">TranslateDS</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">'AccountingReportType7.debit'</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">key</property>
                                                <text-property name="displayName">key</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">translation</property>
                                                <text-property name="displayName">translation</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                                <cell id="4065">
                                    <text id="4206">
                                        <property name="fontSize">9.5pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="borderBottomStyle">none</property>
                                        <property name="borderLeftStyle">none</property>
                                        <property name="borderRightStyle">none</property>
                                        <property name="borderTopStyle">none</property>
                                        <property name="textAlign">right</property>
                                        <property name="dataSet">TranslateDS</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">'AccountingReportType7.credit'</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">key</property>
                                                <text-property name="displayName">key</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">translation</property>
                                                <text-property name="displayName">translation</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                                <cell id="4148">
                                    <text id="4204">
                                        <property name="fontSize">9.5pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="borderBottomStyle">none</property>
                                        <property name="borderLeftStyle">none</property>
                                        <property name="borderRightStyle">none</property>
                                        <property name="borderTopStyle">none</property>
                                        <property name="textAlign">right</property>
                                        <property name="dataSet">TranslateDS</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">'AccountingReportType7.balance'</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">key</property>
                                                <text-property name="displayName">key</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">translation</property>
                                                <text-property name="displayName">translation</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                                <cell id="4220">
                                    <text id="4243">
                                        <property name="fontSize">9.5pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="borderBottomStyle">none</property>
                                        <property name="borderLeftStyle">none</property>
                                        <property name="borderRightStyle">none</property>
                                        <property name="borderTopStyle">none</property>
                                        <property name="textAlign">center</property>
                                        <property name="dataSet">TranslateDS</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">'AccountingReportType7.reconcileGroup'</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">key</property>
                                                <text-property name="displayName">key</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">translation</property>
                                                <text-property name="displayName">translation</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                            </row>
                        </header>
                        <group id="4097">
                            <property name="groupName">account_group</property>
                            <expression name="keyExpr" type="javascript">row["account"]</expression>
                            <structure name="toc">
                                <expression name="expressionValue" type="javascript">row["account"]</expression>
                            </structure>
                            <property name="hideDetail">false</property>
                            <header>
                                <row id="4098">
                                    <property name="borderBottomStyle">solid</property>
                                    <property name="borderBottomWidth">thin</property>
                                    <property name="borderTopStyle">solid</property>
                                    <property name="borderTopWidth">thin</property>
                                    <cell id="4143">
                                        <property name="colSpan">11</property>
                                        <property name="rowSpan">1</property>
                                        <data id="4115">
                                            <property name="resultSetColumn">account</property>
                                        </data>
                                    </cell>
                                </row>
                            </header>
                            <footer>
                                <row id="4106">
                                    <cell id="4145">
                                        <property name="colSpan">6</property>
                                        <property name="rowSpan">1</property>
                                        <text-data id="4141">
                                            <property name="fontSize">9.5pt</property>
                                            <property name="fontWeight">bold</property>
                                            <expression name="valueExpr">"Total" + " "+ row["account"]</expression>
                                            <property name="contentType">html</property>
                                        </text-data>
                                    </cell>
                                    <cell id="4110"/>
                                    <cell id="4112">
                                        <data id="4139">
                                            <property name="fontSize">9.5pt</property>
                                            <property name="fontWeight">bold</property>
                                            <structure name="numberFormat">
                                                <property name="category">Custom</property>
                                                <property name="pattern">###,##0.00</property>
                                            </structure>
                                            <property name="textAlign">right</property>
                                            <property name="resultSetColumn">sum_debit</property>
                                        </data>
                                    </cell>
                                    <cell id="4113">
                                        <data id="4138">
                                            <property name="fontSize">9.5pt</property>
                                            <property name="fontWeight">bold</property>
                                            <structure name="numberFormat">
                                                <property name="category">Custom</property>
                                                <property name="pattern">###,##0.00</property>
                                            </structure>
                                            <property name="textAlign">right</property>
                                            <property name="resultSetColumn">sum_credit</property>
                                        </data>
                                    </cell>
                                    <cell id="4151">
                                        <data id="4156">
                                            <property name="fontSize">9.5pt</property>
                                            <property name="fontWeight">bold</property>
                                            <structure name="numberFormat">
                                                <property name="category">Custom</property>
                                                <property name="pattern">###,##0.00</property>
                                            </structure>
                                            <property name="textAlign">right</property>
                                            <list-property name="visibility">
                                                <structure>
                                                    <property name="format">all</property>
                                                    <expression name="valueExpr" type="javascript">row["sum_balance"]==0</expression>
                                                </structure>
                                            </list-property>
                                            <property name="resultSetColumn">sum_balance</property>
                                        </data>
                                    </cell>
                                    <cell id="4223"/>
                                </row>
                            </footer>
                        </group>
                        <group id="4252">
                            <property name="groupName">partner_group</property>
                            <expression name="keyExpr" type="javascript">if(row._outer["global_by_partner"]){
	row["partner"]
}else{
	row["account"]
}</expression>
                            <property name="hideDetail">false</property>
                            <header>
                                <row id="4253">
                                    <list-property name="visibility">
                                        <structure>
                                            <property name="format">all</property>
                                            <expression name="valueExpr" type="javascript">!row._outer["global_by_partner"]</expression>
                                        </structure>
                                    </list-property>
                                    <cell id="4254">
                                        <property name="colSpan">1</property>
                                        <property name="rowSpan">1</property>
                                    </cell>
                                    <cell id="4303">
                                        <property name="colSpan">10</property>
                                        <property name="rowSpan">1</property>
                                        <property name="borderBottomStyle">solid</property>
                                        <property name="borderBottomWidth">thin</property>
                                        <property name="borderTopStyle">solid</property>
                                        <property name="borderTopWidth">thin</property>
                                        <data id="4277">
                                            <property name="resultSetColumn">partner</property>
                                        </data>
                                    </cell>
                                </row>
                            </header>
                            <footer>
                                <row id="4265">
                                    <list-property name="visibility">
                                        <structure>
                                            <property name="format">all</property>
                                            <expression name="valueExpr" type="javascript">!row._outer["global_by_partner"]</expression>
                                        </structure>
                                    </list-property>
                                    <cell id="4266">
                                        <property name="colSpan">1</property>
                                        <property name="rowSpan">1</property>
                                    </cell>
                                    <cell id="4292">
                                        <property name="colSpan">5</property>
                                        <property name="rowSpan">1</property>
                                        <text-data id="4288">
                                            <property name="fontSize">9.5pt</property>
                                            <property name="fontWeight">bold</property>
                                            <expression name="valueExpr">"Total" + " "+ row["partner"]</expression>
                                            <property name="contentType">html</property>
                                        </text-data>
                                    </cell>
                                    <cell id="4272"/>
                                    <cell id="4273">
                                        <data id="4289">
                                            <property name="fontSize">9.5pt</property>
                                            <property name="fontWeight">bold</property>
                                            <structure name="numberFormat">
                                                <property name="category">Currency</property>
                                                <property name="pattern">###0.00{RoundingMode=HALF_UP}</property>
                                            </structure>
                                            <property name="textAlign">right</property>
                                            <property name="resultSetColumn">sum_debit_partner</property>
                                        </data>
                                    </cell>
                                    <cell id="4274">
                                        <property name="fontWeight">bold</property>
                                        <property name="textAlign">right</property>
                                        <data id="4290">
                                            <property name="fontSize">9.5pt</property>
                                            <structure name="numberFormat">
                                                <property name="category">Currency</property>
                                                <property name="pattern">###0.00{RoundingMode=HALF_UP}</property>
                                            </structure>
                                            <property name="resultSetColumn">sum_credit_partner</property>
                                        </data>
                                    </cell>
                                    <cell id="4275">
                                        <property name="fontSize">9.5pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="textAlign">right</property>
                                        <data id="4291">
                                            <structure name="numberFormat">
                                                <property name="category">Currency</property>
                                                <property name="pattern">###0.00{RoundingMode=HALF_UP}</property>
                                            </structure>
                                            <property name="resultSetColumn">sum_balance_partner</property>
                                        </data>
                                    </cell>
                                    <cell id="4276"/>
                                </row>
                            </footer>
                        </group>
                        <detail>
                            <row id="4067">
                                <method name="onCreate"><![CDATA[vars["PreviousBalance"]=row["balance"]]]></method>
                                <cell id="4144"/>
                                <cell id="4068">
                                    <data id="4069">
                                        <property name="fontSize">8.5pt</property>
                                        <property name="resultSetColumn">move_line_name</property>
                                    </data>
                                </cell>
                                <cell id="4070">
                                    <data id="4073">
                                        <property name="fontSize">8.5pt</property>
                                        <structure name="dateTimeFormat">
                                            <property name="category">Short Date</property>
                                            <property name="pattern">Short Date</property>
                                        </structure>
                                        <property name="textAlign">center</property>
                                        <property name="resultSetColumn">date_val</property>
                                    </data>
                                </cell>
                                <cell id="4234">
                                    <data id="4239">
                                        <property name="fontSize">8.5pt</property>
                                        <structure name="dateTimeFormat">
                                            <property name="category">Short Date</property>
                                            <property name="pattern">Short Date</property>
                                        </structure>
                                        <property name="textAlign">center</property>
                                        <property name="resultSetColumn">due_date</property>
                                    </data>
                                </cell>
                                <cell id="4246">
                                    <data id="4251">
                                        <property name="fontSize">8.5pt</property>
                                        <property name="textAlign">left</property>
                                        <property name="resultSetColumn">journal_code1</property>
                                    </data>
                                </cell>
                                <cell id="4072">
                                    <data id="4071">
                                        <property name="fontSize">8.5pt</property>
                                        <property name="resultSetColumn">move_line_description</property>
                                    </data>
                                </cell>
                                <cell id="4074">
                                    <data id="4075">
                                        <property name="fontSize">8.5pt</property>
                                        <property name="resultSetColumn">partner</property>
                                    </data>
                                </cell>
                                <cell id="4078">
                                    <data id="4079">
                                        <property name="fontSize">8.5pt</property>
                                        <structure name="numberFormat">
                                            <property name="category">Custom</property>
                                            <property name="pattern">###,##0.00</property>
                                        </structure>
                                        <property name="textAlign">right</property>
                                        <property name="resultSetColumn">debit</property>
                                    </data>
                                </cell>
                                <cell id="4080">
                                    <data id="4081">
                                        <property name="fontSize">8.5pt</property>
                                        <structure name="numberFormat">
                                            <property name="category">Custom</property>
                                            <property name="pattern">###,##0.00</property>
                                        </structure>
                                        <property name="textAlign">right</property>
                                        <property name="resultSetColumn">credit</property>
                                    </data>
                                </cell>
                                <cell id="4150">
                                    <data id="4155">
                                        <property name="fontSize">8.5pt</property>
                                        <structure name="numberFormat">
                                            <property name="category">Custom</property>
                                            <property name="pattern">###,##0.00</property>
                                        </structure>
                                        <property name="textAlign">right</property>
                                        <list-property name="visibility">
                                            <structure>
                                                <property name="format">all</property>
                                                <expression name="valueExpr" type="javascript">row["balance"]==0</expression>
                                            </structure>
                                        </list-property>
                                        <property name="resultSetColumn">balance</property>
                                    </data>
                                </cell>
                                <cell id="4222">
                                    <data id="4242">
                                        <property name="fontSize">8.5pt</property>
                                        <property name="marginLeft">1pt</property>
                                        <property name="textAlign">center</property>
                                        <property name="resultSetColumn">reconcile_group_code</property>
                                    </data>
                                </cell>
                            </row>
                        </detail>
                        <footer>
                            <row id="4082">
                                <cell id="4146"/>
                                <cell id="4083"/>
                                <cell id="4084"/>
                                <cell id="4236"/>
                                <cell id="4248"/>
                                <cell id="4085"/>
                                <cell id="4086"/>
                                <cell id="4088"/>
                                <cell id="4089"/>
                                <cell id="4152"/>
                                <cell id="4224"/>
                            </row>
                        </footer>
                    </table>
                </cell>
            </row>
        </grid>
    </body>
    <property name="pageVariables">
        <variable-element name="PreviousBalance">
            <property name="type">report</property>
        </variable-element>
    </property>
</report>
