Fixes Issue 23328: Customer Statement Report.
authorDavid Miguelez <david.miguelez@openbravo.com>
Thu, 21 Mar 2013 10:09:14 +0100
changeset 19945 f76c31b8b96b
parent 19944 e8bb45179747
child 19946 a5faac704852
Fixes Issue 23328: Customer Statement Report.
src-db/database/sourcedata/AD_MENU.xml
src-db/database/sourcedata/AD_PROCESS.xml
src-db/database/sourcedata/AD_PROCESS_PARA.xml
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
src-db/database/sourcedata/AD_TREENODE.xml
src-db/database/sourcedata/AD_VAL_RULE.xml
src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml
--- a/src-db/database/sourcedata/AD_MENU.xml	Thu Mar 21 01:30:07 2013 +0100
+++ b/src-db/database/sourcedata/AD_MENU.xml	Thu Mar 21 10:09:14 2013 +0100
@@ -4642,6 +4642,19 @@
 <!--BE86736DF4AB4568A316A3922E6D6B7B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--BE86736DF4AB4568A316A3922E6D6B7B--></AD_MENU>
 
+<!--C073633F0AFF4A93B17C13F239DE9613--><AD_MENU>
+<!--C073633F0AFF4A93B17C13F239DE9613-->  <AD_MENU_ID><![CDATA[C073633F0AFF4A93B17C13F239DE9613]]></AD_MENU_ID>
+<!--C073633F0AFF4A93B17C13F239DE9613-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C073633F0AFF4A93B17C13F239DE9613-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C073633F0AFF4A93B17C13F239DE9613-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C073633F0AFF4A93B17C13F239DE9613-->  <NAME><![CDATA[Customer Statement]]></NAME>
+<!--C073633F0AFF4A93B17C13F239DE9613-->  <DESCRIPTION><![CDATA[Customer Statement]]></DESCRIPTION>
+<!--C073633F0AFF4A93B17C13F239DE9613-->  <ISSUMMARY><![CDATA[N]]></ISSUMMARY>
+<!--C073633F0AFF4A93B17C13F239DE9613-->  <ACTION><![CDATA[P]]></ACTION>
+<!--C073633F0AFF4A93B17C13F239DE9613-->  <AD_PROCESS_ID><![CDATA[D234AE084F7040DCB66E281A4237FF99]]></AD_PROCESS_ID>
+<!--C073633F0AFF4A93B17C13F239DE9613-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C073633F0AFF4A93B17C13F239DE9613--></AD_MENU>
+
 <!--C14426B2503546788BE2BAEBA2BE81DC--><AD_MENU>
 <!--C14426B2503546788BE2BAEBA2BE81DC-->  <AD_MENU_ID><![CDATA[C14426B2503546788BE2BAEBA2BE81DC]]></AD_MENU_ID>
 <!--C14426B2503546788BE2BAEBA2BE81DC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_PROCESS.xml	Thu Mar 21 01:30:07 2013 +0100
+++ b/src-db/database/sourcedata/AD_PROCESS.xml	Thu Mar 21 10:09:14 2013 +0100
@@ -6357,6 +6357,29 @@
 <!--CD7283DF804B449C97DA09446669EEEF-->  <PREVENTCONCURRENT><![CDATA[N]]></PREVENTCONCURRENT>
 <!--CD7283DF804B449C97DA09446669EEEF--></AD_PROCESS>
 
+<!--D234AE084F7040DCB66E281A4237FF99--><AD_PROCESS>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <AD_PROCESS_ID><![CDATA[D234AE084F7040DCB66E281A4237FF99]]></AD_PROCESS_ID>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <VALUE><![CDATA[JR_CustomerStatement]]></VALUE>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <NAME><![CDATA[Customer Statement]]></NAME>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <DESCRIPTION><![CDATA[Customer Statement]]></DESCRIPTION>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <HELP><![CDATA[Customer Statement]]></HELP>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <ACCESSLEVEL><![CDATA[3]]></ACCESSLEVEL>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <ISUSERSTARTABLE><![CDATA[N]]></ISUSERSTARTABLE>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <ISREPORT><![CDATA[N]]></ISREPORT>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <ISDIRECTPRINT><![CDATA[N]]></ISDIRECTPRINT>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <ISBACKGROUND><![CDATA[N]]></ISBACKGROUND>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <ISJASPER><![CDATA[Y]]></ISJASPER>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <JRNAME><![CDATA[@basedesign@/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></JRNAME>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <ISEXTERNALSERVICE><![CDATA[N]]></ISEXTERNALSERVICE>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <UIPATTERN><![CDATA[S]]></UIPATTERN>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <ISADVANCEDFEATURE><![CDATA[N]]></ISADVANCEDFEATURE>
+<!--D234AE084F7040DCB66E281A4237FF99-->  <PREVENTCONCURRENT><![CDATA[N]]></PREVENTCONCURRENT>
+<!--D234AE084F7040DCB66E281A4237FF99--></AD_PROCESS>
+
 <!--D56220370A774B7FA51323BE3C6E0F22--><AD_PROCESS>
 <!--D56220370A774B7FA51323BE3C6E0F22-->  <AD_PROCESS_ID><![CDATA[D56220370A774B7FA51323BE3C6E0F22]]></AD_PROCESS_ID>
 <!--D56220370A774B7FA51323BE3C6E0F22-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_PROCESS_PARA.xml	Thu Mar 21 01:30:07 2013 +0100
+++ b/src-db/database/sourcedata/AD_PROCESS_PARA.xml	Thu Mar 21 10:09:14 2013 +0100
@@ -4063,6 +4063,26 @@
 <!--33829BDE12A849CE8CF9CBF773DE556A-->  <AD_ELEMENT_ID><![CDATA[126]]></AD_ELEMENT_ID>
 <!--33829BDE12A849CE8CF9CBF773DE556A--></AD_PROCESS_PARA>
 
+<!--28C2574FC1AD4980810D4F07FDC7FCD4--><AD_PROCESS_PARA>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <AD_PROCESS_PARA_ID><![CDATA[28C2574FC1AD4980810D4F07FDC7FCD4]]></AD_PROCESS_PARA_ID>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <NAME><![CDATA[Output type]]></NAME>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <HELP><![CDATA[Defines the output format type from the available list.]]></HELP>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <AD_PROCESS_ID><![CDATA[D234AE084F7040DCB66E281A4237FF99]]></AD_PROCESS_ID>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <AD_REFERENCE_VALUE_ID><![CDATA[800104]]></AD_REFERENCE_VALUE_ID>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <COLUMNNAME><![CDATA[outputType]]></COLUMNNAME>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <ISRANGE><![CDATA[N]]></ISRANGE>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <DEFAULTVALUE><![CDATA[pdf]]></DEFAULTVALUE>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4-->  <AD_ELEMENT_ID><![CDATA[800812]]></AD_ELEMENT_ID>
+<!--28C2574FC1AD4980810D4F07FDC7FCD4--></AD_PROCESS_PARA>
+
 <!--3401DE925FBB4A3AAC72E914595E1C71--><AD_PROCESS_PARA>
 <!--3401DE925FBB4A3AAC72E914595E1C71-->  <AD_PROCESS_PARA_ID><![CDATA[3401DE925FBB4A3AAC72E914595E1C71]]></AD_PROCESS_PARA_ID>
 <!--3401DE925FBB4A3AAC72E914595E1C71-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -4180,6 +4200,25 @@
 <!--62D937E6DE704AD98DEE705A732D6786-->  <AD_ELEMENT_ID><![CDATA[4275E22E56264665A5036996A8045C8D]]></AD_ELEMENT_ID>
 <!--62D937E6DE704AD98DEE705A732D6786--></AD_PROCESS_PARA>
 
+<!--6928C4E56A7F4760839813474B8B3451--><AD_PROCESS_PARA>
+<!--6928C4E56A7F4760839813474B8B3451-->  <AD_PROCESS_PARA_ID><![CDATA[6928C4E56A7F4760839813474B8B3451]]></AD_PROCESS_PARA_ID>
+<!--6928C4E56A7F4760839813474B8B3451-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6928C4E56A7F4760839813474B8B3451-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6928C4E56A7F4760839813474B8B3451-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6928C4E56A7F4760839813474B8B3451-->  <NAME><![CDATA[Starting Date]]></NAME>
+<!--6928C4E56A7F4760839813474B8B3451-->  <DESCRIPTION><![CDATA[A parameter stating the starting time range related to a specified request.]]></DESCRIPTION>
+<!--6928C4E56A7F4760839813474B8B3451-->  <HELP><![CDATA[The Date From indicates the starting date of a range.]]></HELP>
+<!--6928C4E56A7F4760839813474B8B3451-->  <AD_PROCESS_ID><![CDATA[D234AE084F7040DCB66E281A4237FF99]]></AD_PROCESS_ID>
+<!--6928C4E56A7F4760839813474B8B3451-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--6928C4E56A7F4760839813474B8B3451-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
+<!--6928C4E56A7F4760839813474B8B3451-->  <COLUMNNAME><![CDATA[DateFrom]]></COLUMNNAME>
+<!--6928C4E56A7F4760839813474B8B3451-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--6928C4E56A7F4760839813474B8B3451-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
+<!--6928C4E56A7F4760839813474B8B3451-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--6928C4E56A7F4760839813474B8B3451-->  <ISRANGE><![CDATA[N]]></ISRANGE>
+<!--6928C4E56A7F4760839813474B8B3451-->  <AD_ELEMENT_ID><![CDATA[1581]]></AD_ELEMENT_ID>
+<!--6928C4E56A7F4760839813474B8B3451--></AD_PROCESS_PARA>
+
 <!--6E19A05CE9564C15BA5FAA118C005859--><AD_PROCESS_PARA>
 <!--6E19A05CE9564C15BA5FAA118C005859-->  <AD_PROCESS_PARA_ID><![CDATA[6E19A05CE9564C15BA5FAA118C005859]]></AD_PROCESS_PARA_ID>
 <!--6E19A05CE9564C15BA5FAA118C005859-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -4278,6 +4317,68 @@
 <!--74099FB272564084889C4ED8F12E91A1-->  <AD_ELEMENT_ID><![CDATA[113]]></AD_ELEMENT_ID>
 <!--74099FB272564084889C4ED8F12E91A1--></AD_PROCESS_PARA>
 
+<!--7CD372E32A3840FDBF8B9023A944ACB3--><AD_PROCESS_PARA>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <AD_PROCESS_PARA_ID><![CDATA[7CD372E32A3840FDBF8B9023A944ACB3]]></AD_PROCESS_PARA_ID>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <NAME><![CDATA[General Ledger]]></NAME>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <DESCRIPTION><![CDATA[The book containing all financial transactions recorded for the legal entity.]]></DESCRIPTION>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <HELP><![CDATA[The book containing all financial transactions recorded for the legal entity.]]></HELP>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <AD_PROCESS_ID><![CDATA[D234AE084F7040DCB66E281A4237FF99]]></AD_PROCESS_ID>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <COLUMNNAME><![CDATA[C_AcctSchema_ID]]></COLUMNNAME>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <ISRANGE><![CDATA[N]]></ISRANGE>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <DEFAULTVALUE><![CDATA[@C_AcctSchema_ID@]]></DEFAULTVALUE>
+<!--7CD372E32A3840FDBF8B9023A944ACB3-->  <AD_ELEMENT_ID><![CDATA[181]]></AD_ELEMENT_ID>
+<!--7CD372E32A3840FDBF8B9023A944ACB3--></AD_PROCESS_PARA>
+
+<!--7DB2B69C38D34885B71030245668674E--><AD_PROCESS_PARA>
+<!--7DB2B69C38D34885B71030245668674E-->  <AD_PROCESS_PARA_ID><![CDATA[7DB2B69C38D34885B71030245668674E]]></AD_PROCESS_PARA_ID>
+<!--7DB2B69C38D34885B71030245668674E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7DB2B69C38D34885B71030245668674E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7DB2B69C38D34885B71030245668674E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7DB2B69C38D34885B71030245668674E-->  <NAME><![CDATA[Organization]]></NAME>
+<!--7DB2B69C38D34885B71030245668674E-->  <DESCRIPTION><![CDATA[Organizational entity within client]]></DESCRIPTION>
+<!--7DB2B69C38D34885B71030245668674E-->  <HELP><![CDATA[An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.]]></HELP>
+<!--7DB2B69C38D34885B71030245668674E-->  <AD_PROCESS_ID><![CDATA[D234AE084F7040DCB66E281A4237FF99]]></AD_PROCESS_ID>
+<!--7DB2B69C38D34885B71030245668674E-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--7DB2B69C38D34885B71030245668674E-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--7DB2B69C38D34885B71030245668674E-->  <AD_VAL_RULE_ID><![CDATA[0C754881EAD94243A161111916E9B9C6]]></AD_VAL_RULE_ID>
+<!--7DB2B69C38D34885B71030245668674E-->  <COLUMNNAME><![CDATA[AD_Org_ID]]></COLUMNNAME>
+<!--7DB2B69C38D34885B71030245668674E-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--7DB2B69C38D34885B71030245668674E-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
+<!--7DB2B69C38D34885B71030245668674E-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--7DB2B69C38D34885B71030245668674E-->  <ISRANGE><![CDATA[N]]></ISRANGE>
+<!--7DB2B69C38D34885B71030245668674E-->  <DEFAULTVALUE><![CDATA[@AD_Org_ID@]]></DEFAULTVALUE>
+<!--7DB2B69C38D34885B71030245668674E-->  <AD_ELEMENT_ID><![CDATA[113]]></AD_ELEMENT_ID>
+<!--7DB2B69C38D34885B71030245668674E--></AD_PROCESS_PARA>
+
+<!--7F06BC5C7987471FB57499C3CF647788--><AD_PROCESS_PARA>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <AD_PROCESS_PARA_ID><![CDATA[7F06BC5C7987471FB57499C3CF647788]]></AD_PROCESS_PARA_ID>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <NAME><![CDATA[Business Partner]]></NAME>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <DESCRIPTION><![CDATA[Anyone who takes part in daily business operations by acting as a customer, employee, etc.]]></DESCRIPTION>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <HELP><![CDATA[A Business Partner is anyone with whom you transact.  This can include a customer, vendor, employee or any combination of these.]]></HELP>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <AD_PROCESS_ID><![CDATA[D234AE084F7040DCB66E281A4237FF99]]></AD_PROCESS_ID>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <AD_VAL_RULE_ID><![CDATA[95548E7077124EB7A83F85A000CB2350]]></AD_VAL_RULE_ID>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <COLUMNNAME><![CDATA[C_BPartner_ID]]></COLUMNNAME>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <ISRANGE><![CDATA[N]]></ISRANGE>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <DEFAULTVALUE><![CDATA[@C_BPartner_ID@]]></DEFAULTVALUE>
+<!--7F06BC5C7987471FB57499C3CF647788-->  <AD_ELEMENT_ID><![CDATA[187]]></AD_ELEMENT_ID>
+<!--7F06BC5C7987471FB57499C3CF647788--></AD_PROCESS_PARA>
+
 <!--7F940C10CC42401DBBCE7834A96DCE61--><AD_PROCESS_PARA>
 <!--7F940C10CC42401DBBCE7834A96DCE61-->  <AD_PROCESS_PARA_ID><![CDATA[7F940C10CC42401DBBCE7834A96DCE61]]></AD_PROCESS_PARA_ID>
 <!--7F940C10CC42401DBBCE7834A96DCE61-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -4339,6 +4440,25 @@
 <!--959B501B597940E8AC00F9587D83CB2D-->  <AD_ELEMENT_ID><![CDATA[102]]></AD_ELEMENT_ID>
 <!--959B501B597940E8AC00F9587D83CB2D--></AD_PROCESS_PARA>
 
+<!--8EB04CCC31FE41A3898688438944CBEE--><AD_PROCESS_PARA>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <AD_PROCESS_PARA_ID><![CDATA[8EB04CCC31FE41A3898688438944CBEE]]></AD_PROCESS_PARA_ID>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <NAME><![CDATA[Ending Date]]></NAME>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <DESCRIPTION><![CDATA[A parameter stating the ending time range related for a specified request, query, etc.]]></DESCRIPTION>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <HELP><![CDATA[The Date To indicates the end date of a range (inclusive)]]></HELP>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <AD_PROCESS_ID><![CDATA[D234AE084F7040DCB66E281A4237FF99]]></AD_PROCESS_ID>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <COLUMNNAME><![CDATA[DateTo]]></COLUMNNAME>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <ISRANGE><![CDATA[N]]></ISRANGE>
+<!--8EB04CCC31FE41A3898688438944CBEE-->  <AD_ELEMENT_ID><![CDATA[1582]]></AD_ELEMENT_ID>
+<!--8EB04CCC31FE41A3898688438944CBEE--></AD_PROCESS_PARA>
+
 <!--97266E0DF6A24EC0BC6845B9E305F307--><AD_PROCESS_PARA>
 <!--97266E0DF6A24EC0BC6845B9E305F307-->  <AD_PROCESS_PARA_ID><![CDATA[97266E0DF6A24EC0BC6845B9E305F307]]></AD_PROCESS_PARA_ID>
 <!--97266E0DF6A24EC0BC6845B9E305F307-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_TEXTINTERFACES.xml	Thu Mar 21 01:30:07 2013 +0100
+++ b/src-db/database/sourcedata/AD_TEXTINTERFACES.xml	Thu Mar 21 10:09:14 2013 +0100
@@ -12890,6 +12890,17 @@
 <!--0CF0FA57833E4877B90C04CBA7423FAC-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--0CF0FA57833E4877B90C04CBA7423FAC--></AD_TEXTINTERFACES>
 
+<!--0D0E63F8C8944528B91D233ADD229558--><AD_TEXTINTERFACES>
+<!--0D0E63F8C8944528B91D233ADD229558-->  <AD_TEXTINTERFACES_ID><![CDATA[0D0E63F8C8944528B91D233ADD229558]]></AD_TEXTINTERFACES_ID>
+<!--0D0E63F8C8944528B91D233ADD229558-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0D0E63F8C8944528B91D233ADD229558-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0D0E63F8C8944528B91D233ADD229558-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0D0E63F8C8944528B91D233ADD229558-->  <TEXT><![CDATA[Check:]]></TEXT>
+<!--0D0E63F8C8944528B91D233ADD229558-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--0D0E63F8C8944528B91D233ADD229558-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--0D0E63F8C8944528B91D233ADD229558-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0D0E63F8C8944528B91D233ADD229558--></AD_TEXTINTERFACES>
+
 <!--0DC6787C63254C90841C71EFF51A4618--><AD_TEXTINTERFACES>
 <!--0DC6787C63254C90841C71EFF51A4618-->  <AD_TEXTINTERFACES_ID><![CDATA[0DC6787C63254C90841C71EFF51A4618]]></AD_TEXTINTERFACES_ID>
 <!--0DC6787C63254C90841C71EFF51A4618-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -12967,6 +12978,17 @@
 <!--1239DDC8CC1D46DFA50936AB7B448DC5-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--1239DDC8CC1D46DFA50936AB7B448DC5--></AD_TEXTINTERFACES>
 
+<!--1246699444004FFA8CA99142DDDCF980--><AD_TEXTINTERFACES>
+<!--1246699444004FFA8CA99142DDDCF980-->  <AD_TEXTINTERFACES_ID><![CDATA[1246699444004FFA8CA99142DDDCF980]]></AD_TEXTINTERFACES_ID>
+<!--1246699444004FFA8CA99142DDDCF980-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--1246699444004FFA8CA99142DDDCF980-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--1246699444004FFA8CA99142DDDCF980-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--1246699444004FFA8CA99142DDDCF980-->  <TEXT><![CDATA[If you have any questions, comments or concerns regarding this document, please contact us.]]></TEXT>
+<!--1246699444004FFA8CA99142DDDCF980-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--1246699444004FFA8CA99142DDDCF980-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--1246699444004FFA8CA99142DDDCF980-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--1246699444004FFA8CA99142DDDCF980--></AD_TEXTINTERFACES>
+
 <!--15155BC7060D432E86869136477D8C65--><AD_TEXTINTERFACES>
 <!--15155BC7060D432E86869136477D8C65-->  <AD_TEXTINTERFACES_ID><![CDATA[15155BC7060D432E86869136477D8C65]]></AD_TEXTINTERFACES_ID>
 <!--15155BC7060D432E86869136477D8C65-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -13055,6 +13077,17 @@
 <!--1AAE3A265FF94E2094B04B0C9C3F521E-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--1AAE3A265FF94E2094B04B0C9C3F521E--></AD_TEXTINTERFACES>
 
+<!--1B14E1743A3D46C29DE783279D03259E--><AD_TEXTINTERFACES>
+<!--1B14E1743A3D46C29DE783279D03259E-->  <AD_TEXTINTERFACES_ID><![CDATA[1B14E1743A3D46C29DE783279D03259E]]></AD_TEXTINTERFACES_ID>
+<!--1B14E1743A3D46C29DE783279D03259E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--1B14E1743A3D46C29DE783279D03259E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--1B14E1743A3D46C29DE783279D03259E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--1B14E1743A3D46C29DE783279D03259E-->  <TEXT><![CDATA[Net]]></TEXT>
+<!--1B14E1743A3D46C29DE783279D03259E-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--1B14E1743A3D46C29DE783279D03259E-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--1B14E1743A3D46C29DE783279D03259E-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--1B14E1743A3D46C29DE783279D03259E--></AD_TEXTINTERFACES>
+
 <!--1BA2D3538589464DBA2858B42E69A945--><AD_TEXTINTERFACES>
 <!--1BA2D3538589464DBA2858B42E69A945-->  <AD_TEXTINTERFACES_ID><![CDATA[1BA2D3538589464DBA2858B42E69A945]]></AD_TEXTINTERFACES_ID>
 <!--1BA2D3538589464DBA2858B42E69A945-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -13275,6 +13308,17 @@
 <!--222BFD8719D647B59942214EACDCC867-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--222BFD8719D647B59942214EACDCC867--></AD_TEXTINTERFACES>
 
+<!--2525BBCF627B433DAC4D8A1124F7418B--><AD_TEXTINTERFACES>
+<!--2525BBCF627B433DAC4D8A1124F7418B-->  <AD_TEXTINTERFACES_ID><![CDATA[2525BBCF627B433DAC4D8A1124F7418B]]></AD_TEXTINTERFACES_ID>
+<!--2525BBCF627B433DAC4D8A1124F7418B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2525BBCF627B433DAC4D8A1124F7418B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2525BBCF627B433DAC4D8A1124F7418B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2525BBCF627B433DAC4D8A1124F7418B-->  <TEXT><![CDATA[Credit card:]]></TEXT>
+<!--2525BBCF627B433DAC4D8A1124F7418B-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--2525BBCF627B433DAC4D8A1124F7418B-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--2525BBCF627B433DAC4D8A1124F7418B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--2525BBCF627B433DAC4D8A1124F7418B--></AD_TEXTINTERFACES>
+
 <!--25AA0658849611DDB88C001B388C05F0--><AD_TEXTINTERFACES>
 <!--25AA0658849611DDB88C001B388C05F0-->  <AD_TEXTINTERFACES_ID><![CDATA[25AA0658849611DDB88C001B388C05F0]]></AD_TEXTINTERFACES_ID>
 <!--25AA0658849611DDB88C001B388C05F0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -13835,6 +13879,17 @@
 <!--47EC4287C7434F7E9B40EC039FAF3D9D-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--47EC4287C7434F7E9B40EC039FAF3D9D--></AD_TEXTINTERFACES>
 
+<!--48314631C2E84CD8B54F313DAB6B1EDE--><AD_TEXTINTERFACES>
+<!--48314631C2E84CD8B54F313DAB6B1EDE-->  <AD_TEXTINTERFACES_ID><![CDATA[48314631C2E84CD8B54F313DAB6B1EDE]]></AD_TEXTINTERFACES_ID>
+<!--48314631C2E84CD8B54F313DAB6B1EDE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--48314631C2E84CD8B54F313DAB6B1EDE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--48314631C2E84CD8B54F313DAB6B1EDE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--48314631C2E84CD8B54F313DAB6B1EDE-->  <TEXT><![CDATA[to]]></TEXT>
+<!--48314631C2E84CD8B54F313DAB6B1EDE-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--48314631C2E84CD8B54F313DAB6B1EDE-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--48314631C2E84CD8B54F313DAB6B1EDE-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--48314631C2E84CD8B54F313DAB6B1EDE--></AD_TEXTINTERFACES>
+
 <!--483E37C7AC3744EF9EA1ED58DBA10DD9--><AD_TEXTINTERFACES>
 <!--483E37C7AC3744EF9EA1ED58DBA10DD9-->  <AD_TEXTINTERFACES_ID><![CDATA[483E37C7AC3744EF9EA1ED58DBA10DD9]]></AD_TEXTINTERFACES_ID>
 <!--483E37C7AC3744EF9EA1ED58DBA10DD9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -16585,6 +16640,17 @@
 <!--6C33A3117F6947CB8BA439FB694A0905-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--6C33A3117F6947CB8BA439FB694A0905--></AD_TEXTINTERFACES>
 
+<!--6C386F43438840F3B0625E000F4BE40F--><AD_TEXTINTERFACES>
+<!--6C386F43438840F3B0625E000F4BE40F-->  <AD_TEXTINTERFACES_ID><![CDATA[6C386F43438840F3B0625E000F4BE40F]]></AD_TEXTINTERFACES_ID>
+<!--6C386F43438840F3B0625E000F4BE40F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6C386F43438840F3B0625E000F4BE40F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6C386F43438840F3B0625E000F4BE40F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6C386F43438840F3B0625E000F4BE40F-->  <TEXT><![CDATA[PAYMENT METHODS]]></TEXT>
+<!--6C386F43438840F3B0625E000F4BE40F-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--6C386F43438840F3B0625E000F4BE40F-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--6C386F43438840F3B0625E000F4BE40F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--6C386F43438840F3B0625E000F4BE40F--></AD_TEXTINTERFACES>
+
 <!--6C686CCD6CF94FF69CCF009E8549D849--><AD_TEXTINTERFACES>
 <!--6C686CCD6CF94FF69CCF009E8549D849-->  <AD_TEXTINTERFACES_ID><![CDATA[6C686CCD6CF94FF69CCF009E8549D849]]></AD_TEXTINTERFACES_ID>
 <!--6C686CCD6CF94FF69CCF009E8549D849-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -16607,6 +16673,17 @@
 <!--6C917BC895CB41199D4C6825D5D23403-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--6C917BC895CB41199D4C6825D5D23403--></AD_TEXTINTERFACES>
 
+<!--6CBCF40359924453B2AAE6C38F4C2B53--><AD_TEXTINTERFACES>
+<!--6CBCF40359924453B2AAE6C38F4C2B53-->  <AD_TEXTINTERFACES_ID><![CDATA[6CBCF40359924453B2AAE6C38F4C2B53]]></AD_TEXTINTERFACES_ID>
+<!--6CBCF40359924453B2AAE6C38F4C2B53-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6CBCF40359924453B2AAE6C38F4C2B53-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6CBCF40359924453B2AAE6C38F4C2B53-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6CBCF40359924453B2AAE6C38F4C2B53-->  <TEXT><![CDATA[SIL VLY BK]]></TEXT>
+<!--6CBCF40359924453B2AAE6C38F4C2B53-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--6CBCF40359924453B2AAE6C38F4C2B53-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--6CBCF40359924453B2AAE6C38F4C2B53-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--6CBCF40359924453B2AAE6C38F4C2B53--></AD_TEXTINTERFACES>
+
 <!--6D7469B473B7418A95D0237421B610F0--><AD_TEXTINTERFACES>
 <!--6D7469B473B7418A95D0237421B610F0-->  <AD_TEXTINTERFACES_ID><![CDATA[6D7469B473B7418A95D0237421B610F0]]></AD_TEXTINTERFACES_ID>
 <!--6D7469B473B7418A95D0237421B610F0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -17685,6 +17762,17 @@
 <!--85D608DDFC8D4E63B0844B6BB0707E78-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--85D608DDFC8D4E63B0844B6BB0707E78--></AD_TEXTINTERFACES>
 
+<!--85E95F281E054ACE8A48B3A18221F05F--><AD_TEXTINTERFACES>
+<!--85E95F281E054ACE8A48B3A18221F05F-->  <AD_TEXTINTERFACES_ID><![CDATA[85E95F281E054ACE8A48B3A18221F05F]]></AD_TEXTINTERFACES_ID>
+<!--85E95F281E054ACE8A48B3A18221F05F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--85E95F281E054ACE8A48B3A18221F05F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--85E95F281E054ACE8A48B3A18221F05F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--85E95F281E054ACE8A48B3A18221F05F-->  <TEXT><![CDATA[Email:]]></TEXT>
+<!--85E95F281E054ACE8A48B3A18221F05F-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--85E95F281E054ACE8A48B3A18221F05F-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--85E95F281E054ACE8A48B3A18221F05F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--85E95F281E054ACE8A48B3A18221F05F--></AD_TEXTINTERFACES>
+
 <!--865772D226ED40CF94D061EF1D508BE8--><AD_TEXTINTERFACES>
 <!--865772D226ED40CF94D061EF1D508BE8-->  <AD_TEXTINTERFACES_ID><![CDATA[865772D226ED40CF94D061EF1D508BE8]]></AD_TEXTINTERFACES_ID>
 <!--865772D226ED40CF94D061EF1D508BE8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -18464,6 +18552,17 @@
 <!--8E2EEBC582974948836ACA2751E8A103-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--8E2EEBC582974948836ACA2751E8A103--></AD_TEXTINTERFACES>
 
+<!--8F61C64E96094002854B8E2B549E351C--><AD_TEXTINTERFACES>
+<!--8F61C64E96094002854B8E2B549E351C-->  <AD_TEXTINTERFACES_ID><![CDATA[8F61C64E96094002854B8E2B549E351C]]></AD_TEXTINTERFACES_ID>
+<!--8F61C64E96094002854B8E2B549E351C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--8F61C64E96094002854B8E2B549E351C-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--8F61C64E96094002854B8E2B549E351C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--8F61C64E96094002854B8E2B549E351C-->  <TEXT><![CDATA[Account #: 3300912605]]></TEXT>
+<!--8F61C64E96094002854B8E2B549E351C-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--8F61C64E96094002854B8E2B549E351C-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--8F61C64E96094002854B8E2B549E351C-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--8F61C64E96094002854B8E2B549E351C--></AD_TEXTINTERFACES>
+
 <!--90333AD8F13346419056F038E249A6C4--><AD_TEXTINTERFACES>
 <!--90333AD8F13346419056F038E249A6C4-->  <AD_TEXTINTERFACES_ID><![CDATA[90333AD8F13346419056F038E249A6C4]]></AD_TEXTINTERFACES_ID>
 <!--90333AD8F13346419056F038E249A6C4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -18475,6 +18574,17 @@
 <!--90333AD8F13346419056F038E249A6C4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--90333AD8F13346419056F038E249A6C4--></AD_TEXTINTERFACES>
 
+<!--915603E70BA645AA8B0CB555CE5E9FE0--><AD_TEXTINTERFACES>
+<!--915603E70BA645AA8B0CB555CE5E9FE0-->  <AD_TEXTINTERFACES_ID><![CDATA[915603E70BA645AA8B0CB555CE5E9FE0]]></AD_TEXTINTERFACES_ID>
+<!--915603E70BA645AA8B0CB555CE5E9FE0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--915603E70BA645AA8B0CB555CE5E9FE0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--915603E70BA645AA8B0CB555CE5E9FE0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--915603E70BA645AA8B0CB555CE5E9FE0-->  <TEXT><![CDATA[Swift code: SVBKUS6S]]></TEXT>
+<!--915603E70BA645AA8B0CB555CE5E9FE0-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--915603E70BA645AA8B0CB555CE5E9FE0-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--915603E70BA645AA8B0CB555CE5E9FE0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--915603E70BA645AA8B0CB555CE5E9FE0--></AD_TEXTINTERFACES>
+
 <!--91C8B575671B7107E040007F0100283A--><AD_TEXTINTERFACES>
 <!--91C8B575671B7107E040007F0100283A-->  <AD_TEXTINTERFACES_ID><![CDATA[91C8B575671B7107E040007F0100283A]]></AD_TEXTINTERFACES_ID>
 <!--91C8B575671B7107E040007F0100283A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -18574,6 +18684,17 @@
 <!--9278F647262448F089D8EA7D3957D4BA-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--9278F647262448F089D8EA7D3957D4BA--></AD_TEXTINTERFACES>
 
+<!--92E84ED4466A44F8844C59B72C2E191B--><AD_TEXTINTERFACES>
+<!--92E84ED4466A44F8844C59B72C2E191B-->  <AD_TEXTINTERFACES_ID><![CDATA[92E84ED4466A44F8844C59B72C2E191B]]></AD_TEXTINTERFACES_ID>
+<!--92E84ED4466A44F8844C59B72C2E191B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--92E84ED4466A44F8844C59B72C2E191B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--92E84ED4466A44F8844C59B72C2E191B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--92E84ED4466A44F8844C59B72C2E191B-->  <TEXT><![CDATA[Document Type]]></TEXT>
+<!--92E84ED4466A44F8844C59B72C2E191B-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--92E84ED4466A44F8844C59B72C2E191B-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--92E84ED4466A44F8844C59B72C2E191B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--92E84ED4466A44F8844C59B72C2E191B--></AD_TEXTINTERFACES>
+
 <!--92F888AFA3FD4E8DBA0DAA44B6CC6A21--><AD_TEXTINTERFACES>
 <!--92F888AFA3FD4E8DBA0DAA44B6CC6A21-->  <AD_TEXTINTERFACES_ID><![CDATA[92F888AFA3FD4E8DBA0DAA44B6CC6A21]]></AD_TEXTINTERFACES_ID>
 <!--92F888AFA3FD4E8DBA0DAA44B6CC6A21-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -19146,6 +19267,17 @@
 <!--9A026A2660054037B3A0E55A8FFE3FA4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--9A026A2660054037B3A0E55A8FFE3FA4--></AD_TEXTINTERFACES>
 
+<!--9B5239B5A5B2401FA58B56FEC96565EF--><AD_TEXTINTERFACES>
+<!--9B5239B5A5B2401FA58B56FEC96565EF-->  <AD_TEXTINTERFACES_ID><![CDATA[9B5239B5A5B2401FA58B56FEC96565EF]]></AD_TEXTINTERFACES_ID>
+<!--9B5239B5A5B2401FA58B56FEC96565EF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9B5239B5A5B2401FA58B56FEC96565EF-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9B5239B5A5B2401FA58B56FEC96565EF-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9B5239B5A5B2401FA58B56FEC96565EF-->  <TEXT><![CDATA[Wire:]]></TEXT>
+<!--9B5239B5A5B2401FA58B56FEC96565EF-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--9B5239B5A5B2401FA58B56FEC96565EF-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--9B5239B5A5B2401FA58B56FEC96565EF-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9B5239B5A5B2401FA58B56FEC96565EF--></AD_TEXTINTERFACES>
+
 <!--9B926CFD21334E8991EF48C89971F139--><AD_TEXTINTERFACES>
 <!--9B926CFD21334E8991EF48C89971F139-->  <AD_TEXTINTERFACES_ID><![CDATA[9B926CFD21334E8991EF48C89971F139]]></AD_TEXTINTERFACES_ID>
 <!--9B926CFD21334E8991EF48C89971F139-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -19278,6 +19410,17 @@
 <!--9F749B6889814698B50D9701AD7A9AA0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--9F749B6889814698B50D9701AD7A9AA0--></AD_TEXTINTERFACES>
 
+<!--9FBBD13DF7BB4D1483F9130DAEF55D0A--><AD_TEXTINTERFACES>
+<!--9FBBD13DF7BB4D1483F9130DAEF55D0A-->  <AD_TEXTINTERFACES_ID><![CDATA[9FBBD13DF7BB4D1483F9130DAEF55D0A]]></AD_TEXTINTERFACES_ID>
+<!--9FBBD13DF7BB4D1483F9130DAEF55D0A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9FBBD13DF7BB4D1483F9130DAEF55D0A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9FBBD13DF7BB4D1483F9130DAEF55D0A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9FBBD13DF7BB4D1483F9130DAEF55D0A-->  <TEXT><![CDATA[Address to RocketSpace]]></TEXT>
+<!--9FBBD13DF7BB4D1483F9130DAEF55D0A-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--9FBBD13DF7BB4D1483F9130DAEF55D0A-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--9FBBD13DF7BB4D1483F9130DAEF55D0A-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9FBBD13DF7BB4D1483F9130DAEF55D0A--></AD_TEXTINTERFACES>
+
 <!--A065F543F8A448ABA1C1A583C0B0CBA8--><AD_TEXTINTERFACES>
 <!--A065F543F8A448ABA1C1A583C0B0CBA8-->  <AD_TEXTINTERFACES_ID><![CDATA[A065F543F8A448ABA1C1A583C0B0CBA8]]></AD_TEXTINTERFACES_ID>
 <!--A065F543F8A448ABA1C1A583C0B0CBA8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -19311,6 +19454,17 @@
 <!--A25FFD50C924486E93F3A39A593C5C20-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--A25FFD50C924486E93F3A39A593C5C20--></AD_TEXTINTERFACES>
 
+<!--A2AD8A231B844A179BF7B6EFA91E16CB--><AD_TEXTINTERFACES>
+<!--A2AD8A231B844A179BF7B6EFA91E16CB-->  <AD_TEXTINTERFACES_ID><![CDATA[A2AD8A231B844A179BF7B6EFA91E16CB]]></AD_TEXTINTERFACES_ID>
+<!--A2AD8A231B844A179BF7B6EFA91E16CB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A2AD8A231B844A179BF7B6EFA91E16CB-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A2AD8A231B844A179BF7B6EFA91E16CB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A2AD8A231B844A179BF7B6EFA91E16CB-->  <TEXT><![CDATA[Issued]]></TEXT>
+<!--A2AD8A231B844A179BF7B6EFA91E16CB-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--A2AD8A231B844A179BF7B6EFA91E16CB-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--A2AD8A231B844A179BF7B6EFA91E16CB-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A2AD8A231B844A179BF7B6EFA91E16CB--></AD_TEXTINTERFACES>
+
 <!--A2EBE0F15C424862BE4C861A50ADAE7D--><AD_TEXTINTERFACES>
 <!--A2EBE0F15C424862BE4C861A50ADAE7D-->  <AD_TEXTINTERFACES_ID><![CDATA[A2EBE0F15C424862BE4C861A50ADAE7D]]></AD_TEXTINTERFACES_ID>
 <!--A2EBE0F15C424862BE4C861A50ADAE7D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20037,6 +20191,17 @@
 <!--BC2ADB71F77CFC33E040A8C064002DA8-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--BC2ADB71F77CFC33E040A8C064002DA8--></AD_TEXTINTERFACES>
 
+<!--BEFE5902CF7F49BBAFB0617C2EF23DFB--><AD_TEXTINTERFACES>
+<!--BEFE5902CF7F49BBAFB0617C2EF23DFB-->  <AD_TEXTINTERFACES_ID><![CDATA[BEFE5902CF7F49BBAFB0617C2EF23DFB]]></AD_TEXTINTERFACES_ID>
+<!--BEFE5902CF7F49BBAFB0617C2EF23DFB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--BEFE5902CF7F49BBAFB0617C2EF23DFB-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--BEFE5902CF7F49BBAFB0617C2EF23DFB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--BEFE5902CF7F49BBAFB0617C2EF23DFB-->  <TEXT><![CDATA[Balance:]]></TEXT>
+<!--BEFE5902CF7F49BBAFB0617C2EF23DFB-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--BEFE5902CF7F49BBAFB0617C2EF23DFB-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--BEFE5902CF7F49BBAFB0617C2EF23DFB-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--BEFE5902CF7F49BBAFB0617C2EF23DFB--></AD_TEXTINTERFACES>
+
 <!--BFB26FEF2745470C8456D5A1434DC1D3--><AD_TEXTINTERFACES>
 <!--BFB26FEF2745470C8456D5A1434DC1D3-->  <AD_TEXTINTERFACES_ID><![CDATA[BFB26FEF2745470C8456D5A1434DC1D3]]></AD_TEXTINTERFACES_ID>
 <!--BFB26FEF2745470C8456D5A1434DC1D3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20048,6 +20213,28 @@
 <!--BFB26FEF2745470C8456D5A1434DC1D3-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--BFB26FEF2745470C8456D5A1434DC1D3--></AD_TEXTINTERFACES>
 
+<!--BFFB37AB0703400CA3292EEBF14B5C94--><AD_TEXTINTERFACES>
+<!--BFFB37AB0703400CA3292EEBF14B5C94-->  <AD_TEXTINTERFACES_ID><![CDATA[BFFB37AB0703400CA3292EEBF14B5C94]]></AD_TEXTINTERFACES_ID>
+<!--BFFB37AB0703400CA3292EEBF14B5C94-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--BFFB37AB0703400CA3292EEBF14B5C94-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--BFFB37AB0703400CA3292EEBF14B5C94-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--BFFB37AB0703400CA3292EEBF14B5C94-->  <TEXT><![CDATA[Customer Statement]]></TEXT>
+<!--BFFB37AB0703400CA3292EEBF14B5C94-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--BFFB37AB0703400CA3292EEBF14B5C94-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--BFFB37AB0703400CA3292EEBF14B5C94-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--BFFB37AB0703400CA3292EEBF14B5C94--></AD_TEXTINTERFACES>
+
+<!--C02A5FD6EB60463BAFFD22170160BA85--><AD_TEXTINTERFACES>
+<!--C02A5FD6EB60463BAFFD22170160BA85-->  <AD_TEXTINTERFACES_ID><![CDATA[C02A5FD6EB60463BAFFD22170160BA85]]></AD_TEXTINTERFACES_ID>
+<!--C02A5FD6EB60463BAFFD22170160BA85-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C02A5FD6EB60463BAFFD22170160BA85-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C02A5FD6EB60463BAFFD22170160BA85-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C02A5FD6EB60463BAFFD22170160BA85-->  <TEXT><![CDATA[Phone:]]></TEXT>
+<!--C02A5FD6EB60463BAFFD22170160BA85-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--C02A5FD6EB60463BAFFD22170160BA85-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--C02A5FD6EB60463BAFFD22170160BA85-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C02A5FD6EB60463BAFFD22170160BA85--></AD_TEXTINTERFACES>
+
 <!--C25EA66C5D9841209AE6AB7F11AE2F27--><AD_TEXTINTERFACES>
 <!--C25EA66C5D9841209AE6AB7F11AE2F27-->  <AD_TEXTINTERFACES_ID><![CDATA[C25EA66C5D9841209AE6AB7F11AE2F27]]></AD_TEXTINTERFACES_ID>
 <!--C25EA66C5D9841209AE6AB7F11AE2F27-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20202,6 +20389,17 @@
 <!--C97A2FF6B2C647178B3B54FD4BBC8D40-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--C97A2FF6B2C647178B3B54FD4BBC8D40--></AD_TEXTINTERFACES>
 
+<!--C99FE3974E0141EC97EE167B36082BDC--><AD_TEXTINTERFACES>
+<!--C99FE3974E0141EC97EE167B36082BDC-->  <AD_TEXTINTERFACES_ID><![CDATA[C99FE3974E0141EC97EE167B36082BDC]]></AD_TEXTINTERFACES_ID>
+<!--C99FE3974E0141EC97EE167B36082BDC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C99FE3974E0141EC97EE167B36082BDC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C99FE3974E0141EC97EE167B36082BDC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C99FE3974E0141EC97EE167B36082BDC-->  <TEXT><![CDATA[Contact us for more information]]></TEXT>
+<!--C99FE3974E0141EC97EE167B36082BDC-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--C99FE3974E0141EC97EE167B36082BDC-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--C99FE3974E0141EC97EE167B36082BDC-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C99FE3974E0141EC97EE167B36082BDC--></AD_TEXTINTERFACES>
+
 <!--C9E7449ECD8E42BE8413D8521C4779A8--><AD_TEXTINTERFACES>
 <!--C9E7449ECD8E42BE8413D8521C4779A8-->  <AD_TEXTINTERFACES_ID><![CDATA[C9E7449ECD8E42BE8413D8521C4779A8]]></AD_TEXTINTERFACES_ID>
 <!--C9E7449ECD8E42BE8413D8521C4779A8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20499,6 +20697,17 @@
 <!--D9E52AB5AEAF4D2995B9852E4C8C8F8F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--D9E52AB5AEAF4D2995B9852E4C8C8F8F--></AD_TEXTINTERFACES>
 
+<!--DA15DC833DDE425E8B15DB24A6DA43A3--><AD_TEXTINTERFACES>
+<!--DA15DC833DDE425E8B15DB24A6DA43A3-->  <AD_TEXTINTERFACES_ID><![CDATA[DA15DC833DDE425E8B15DB24A6DA43A3]]></AD_TEXTINTERFACES_ID>
+<!--DA15DC833DDE425E8B15DB24A6DA43A3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--DA15DC833DDE425E8B15DB24A6DA43A3-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--DA15DC833DDE425E8B15DB24A6DA43A3-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--DA15DC833DDE425E8B15DB24A6DA43A3-->  <TEXT><![CDATA[Routing and transit #: 121140399]]></TEXT>
+<!--DA15DC833DDE425E8B15DB24A6DA43A3-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--DA15DC833DDE425E8B15DB24A6DA43A3-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--DA15DC833DDE425E8B15DB24A6DA43A3-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--DA15DC833DDE425E8B15DB24A6DA43A3--></AD_TEXTINTERFACES>
+
 <!--DA35BAB2B783408EADC9E615FF99AED7--><AD_TEXTINTERFACES>
 <!--DA35BAB2B783408EADC9E615FF99AED7-->  <AD_TEXTINTERFACES_ID><![CDATA[DA35BAB2B783408EADC9E615FF99AED7]]></AD_TEXTINTERFACES_ID>
 <!--DA35BAB2B783408EADC9E615FF99AED7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20576,6 +20785,17 @@
 <!--DEE3E51681A84564B1E2D0C1EE2DAE44-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--DEE3E51681A84564B1E2D0C1EE2DAE44--></AD_TEXTINTERFACES>
 
+<!--DF8C3682D3614A1C92A03BE0E4A8F217--><AD_TEXTINTERFACES>
+<!--DF8C3682D3614A1C92A03BE0E4A8F217-->  <AD_TEXTINTERFACES_ID><![CDATA[DF8C3682D3614A1C92A03BE0E4A8F217]]></AD_TEXTINTERFACES_ID>
+<!--DF8C3682D3614A1C92A03BE0E4A8F217-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--DF8C3682D3614A1C92A03BE0E4A8F217-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--DF8C3682D3614A1C92A03BE0E4A8F217-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--DF8C3682D3614A1C92A03BE0E4A8F217-->  <TEXT><![CDATA[If you have any questions, comments or concerns regarding this invoice, please contact us.]]></TEXT>
+<!--DF8C3682D3614A1C92A03BE0E4A8F217-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--DF8C3682D3614A1C92A03BE0E4A8F217-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--DF8C3682D3614A1C92A03BE0E4A8F217-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--DF8C3682D3614A1C92A03BE0E4A8F217--></AD_TEXTINTERFACES>
+
 <!--E0CBE4F115604DAB9E4F285D17E27057--><AD_TEXTINTERFACES>
 <!--E0CBE4F115604DAB9E4F285D17E27057-->  <AD_TEXTINTERFACES_ID><![CDATA[E0CBE4F115604DAB9E4F285D17E27057]]></AD_TEXTINTERFACES_ID>
 <!--E0CBE4F115604DAB9E4F285D17E27057-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20587,6 +20807,17 @@
 <!--E0CBE4F115604DAB9E4F285D17E27057-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--E0CBE4F115604DAB9E4F285D17E27057--></AD_TEXTINTERFACES>
 
+<!--E20E95D58C254FA798EE6EBE67CDF197--><AD_TEXTINTERFACES>
+<!--E20E95D58C254FA798EE6EBE67CDF197-->  <AD_TEXTINTERFACES_ID><![CDATA[E20E95D58C254FA798EE6EBE67CDF197]]></AD_TEXTINTERFACES_ID>
+<!--E20E95D58C254FA798EE6EBE67CDF197-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E20E95D58C254FA798EE6EBE67CDF197-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E20E95D58C254FA798EE6EBE67CDF197-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E20E95D58C254FA798EE6EBE67CDF197-->  <TEXT><![CDATA[Memo:]]></TEXT>
+<!--E20E95D58C254FA798EE6EBE67CDF197-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml]]></FILENAME>
+<!--E20E95D58C254FA798EE6EBE67CDF197-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--E20E95D58C254FA798EE6EBE67CDF197-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E20E95D58C254FA798EE6EBE67CDF197--></AD_TEXTINTERFACES>
+
 <!--E228440A042711DE90B03B18C9F4D4A2--><AD_TEXTINTERFACES>
 <!--E228440A042711DE90B03B18C9F4D4A2-->  <AD_TEXTINTERFACES_ID><![CDATA[E228440A042711DE90B03B18C9F4D4A2]]></AD_TEXTINTERFACES_ID>
 <!--E228440A042711DE90B03B18C9F4D4A2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_TREENODE.xml	Thu Mar 21 01:30:07 2013 +0100
+++ b/src-db/database/sourcedata/AD_TREENODE.xml	Thu Mar 21 10:09:14 2013 +0100
@@ -4200,6 +4200,17 @@
 <!--EB68A542EF0F4B68B33711E733E850B3-->  <SEQNO><![CDATA[50]]></SEQNO>
 <!--EB68A542EF0F4B68B33711E733E850B3--></AD_TREENODE>
 
+<!--F24C800569CE414FB478097C96EA7E55--><AD_TREENODE>
+<!--F24C800569CE414FB478097C96EA7E55-->  <AD_TREENODE_ID><![CDATA[F24C800569CE414FB478097C96EA7E55]]></AD_TREENODE_ID>
+<!--F24C800569CE414FB478097C96EA7E55-->  <AD_TREE_ID><![CDATA[10]]></AD_TREE_ID>
+<!--F24C800569CE414FB478097C96EA7E55-->  <NODE_ID><![CDATA[C073633F0AFF4A93B17C13F239DE9613]]></NODE_ID>
+<!--F24C800569CE414FB478097C96EA7E55-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F24C800569CE414FB478097C96EA7E55-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F24C800569CE414FB478097C96EA7E55-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F24C800569CE414FB478097C96EA7E55-->  <PARENT_ID><![CDATA[280]]></PARENT_ID>
+<!--F24C800569CE414FB478097C96EA7E55-->  <SEQNO><![CDATA[110]]></SEQNO>
+<!--F24C800569CE414FB478097C96EA7E55--></AD_TREENODE>
+
 <!--F97035E495D911DDB78D001B388C05F0--><AD_TREENODE>
 <!--F97035E495D911DDB78D001B388C05F0-->  <AD_TREENODE_ID><![CDATA[F97035E495D911DDB78D001B388C05F0]]></AD_TREENODE_ID>
 <!--F97035E495D911DDB78D001B388C05F0-->  <AD_TREE_ID><![CDATA[10]]></AD_TREE_ID>
--- a/src-db/database/sourcedata/AD_VAL_RULE.xml	Thu Mar 21 01:30:07 2013 +0100
+++ b/src-db/database/sourcedata/AD_VAL_RULE.xml	Thu Mar 21 10:09:14 2013 +0100
@@ -1753,6 +1753,17 @@
 <!--90EECFEEA13B4B8B98E252D2904FA876-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--90EECFEEA13B4B8B98E252D2904FA876--></AD_VAL_RULE>
 
+<!--95548E7077124EB7A83F85A000CB2350--><AD_VAL_RULE>
+<!--95548E7077124EB7A83F85A000CB2350-->  <AD_VAL_RULE_ID><![CDATA[95548E7077124EB7A83F85A000CB2350]]></AD_VAL_RULE_ID>
+<!--95548E7077124EB7A83F85A000CB2350-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--95548E7077124EB7A83F85A000CB2350-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--95548E7077124EB7A83F85A000CB2350-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--95548E7077124EB7A83F85A000CB2350-->  <NAME><![CDATA[C_BPartnerCustomerAndInOrg]]></NAME>
+<!--95548E7077124EB7A83F85A000CB2350-->  <TYPE><![CDATA[S]]></TYPE>
+<!--95548E7077124EB7A83F85A000CB2350-->  <CODE><![CDATA[C_BPartner.iscustomer = 'Y' AND (AD_ISORGINCLUDED(@AD_Org_ID@,C_BPartner.AD_Org_ID, @AD_Client_ID@) <> '-1')]]></CODE>
+<!--95548E7077124EB7A83F85A000CB2350-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--95548E7077124EB7A83F85A000CB2350--></AD_VAL_RULE>
+
 <!--988E8605A37D465D8D0AEA968ABCB2AE--><AD_VAL_RULE>
 <!--988E8605A37D465D8D0AEA968ABCB2AE-->  <AD_VAL_RULE_ID><![CDATA[988E8605A37D465D8D0AEA968ABCB2AE]]></AD_VAL_RULE_ID>
 <!--988E8605A37D465D8D0AEA968ABCB2AE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml	Thu Mar 21 10:09:14 2013 +0100
@@ -0,0 +1,364 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Customer Statement" pageWidth="595" pageHeight="842" whenNoDataType="BlankPage" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
+	<property name="ireport.scriptlethandling" value="0"/>
+	<property name="ireport.encoding" value="UTF-8"/>
+	<property name="ireport.zoom" value="1.5"/>
+	<property name="ireport.x" value="0"/>
+	<property name="ireport.y" value="0"/>
+	<import value="net.sf.jasperreports.engine.*"/>
+	<import value="java.util.*"/>
+	<import value="net.sf.jasperreports.engine.data.*"/>
+	<style name="default" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="10"/>
+	<style name="Report_Title" fontName="Bitstream Vera Sans" fontSize="18">
+		<box leftPadding="5"/>
+	</style>
+	<style name="Group_Data_Label" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/>
+	<style name="Report_Subtitle" forecolor="#555555" fontName="Bitstream Vera Sans" fontSize="14">
+		<box leftPadding="5"/>
+	</style>
+	<style name="Total_Field" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC" vAlign="Middle">
+		<box leftPadding="5"/>
+	</style>
+	<style name="Detail_Header" mode="Opaque" forecolor="#FFFFFF" backcolor="#555555" vAlign="Middle">
+		<box leftPadding="5">
+			<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
+			<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
+		</box>
+	</style>
+	<style name="GroupHeader_DarkGray" mode="Opaque" forecolor="#FFFFFF" backcolor="#555555" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="14">
+		<box leftPadding="5"/>
+	</style>
+	<style name="GroupHeader_Gray" mode="Opaque" backcolor="#999999"/>
+	<style name="Detail_Line">
+		<conditionalStyle>
+			<conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==1)]]></conditionExpression>
+			<style mode="Opaque" backcolor="#CCCCCC"/>
+		</conditionalStyle>
+	</style>
+	<style name="Total_Gray" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC"/>
+	<parameter name="ATTACH" class="java.lang.String" isForPrompting="false"/>
+	<parameter name="BASE_WEB" class="java.lang.String" isForPrompting="false">
+		<defaultValueExpression><![CDATA["http://localhost:8080/openbravo/web"]]></defaultValueExpression>
+	</parameter>
+	<parameter name="BASE_DESIGN" class="java.lang.String" isForPrompting="false">
+		<defaultValueExpression><![CDATA["/home/openbravo/servers/tomcat6/webapps/openbravo/src-loc/design"]]></defaultValueExpression>
+	</parameter>
+	<parameter name="LANGUAGE" class="java.lang.String" isForPrompting="false">
+		<defaultValueExpression><![CDATA["en_US"]]></defaultValueExpression>
+	</parameter>
+	<parameter name="USER_CLIENT" class="java.lang.String" isForPrompting="false">
+		<defaultValueExpression><![CDATA["('1000000')"]]></defaultValueExpression>
+	</parameter>
+	<parameter name="USER_ORG" class="java.lang.String" isForPrompting="false">
+		<defaultValueExpression><![CDATA["('0')"]]></defaultValueExpression>
+	</parameter>
+	<parameter name="REPORT_TITLE" class="java.lang.String" isForPrompting="false">
+		<defaultValueExpression><![CDATA["REPORT TITLE"]]></defaultValueExpression>
+	</parameter>
+	<parameter name="REPORT_SUBTITLE" class="java.lang.String" isForPrompting="false"/>
+	<parameter name="LOCALE" class="java.util.Locale" isForPrompting="false"/>
+	<parameter name="NUMBERFORMAT" class="java.text.DecimalFormat" isForPrompting="false"/>
+	<parameter name="C_BPartner_ID" class="java.lang.String"/>
+	<parameter name="C_AcctSchema_ID" class="java.lang.String"/>
+	<parameter name="DateFrom" class="java.lang.String"/>
+	<parameter name="DateTo" class="java.lang.String"/>
+	<parameter name="AD_Org_ID" class="java.lang.String"/>
+	<parameter name="DATEFORMAT" class="java.text.DateFormat">
+		<defaultValueExpression><![CDATA[$P{REPORT_FORMAT_FACTORY}.createDateFormat("", $P{REPORT_LOCALE}, $P{REPORT_TIME_ZONE})]]></defaultValueExpression>
+	</parameter>
+	<queryString>
+		<![CDATA[SELECT trunc(f.dateacct) as date,
+        CASE WHEN f.c_doctype_id IS NOT NULL THEN (SELECT MIN(name)
+                                       FROM c_doctype
+                                       WHERE c_doctype_id = f.c_doctype_id)
+        ELSE (SELECT MIN(name)
+              FROM ad_ref_list
+              WHERE ad_reference_id = '183'
+              AND value = f.docbasetype)
+        END as documenttype,
+    f.description,
+    f.amtacctdr as debit,
+    f.amtacctcr as credit,
+    (f.amtacctdr-f.amtacctcr) as net,
+    bp.name as bpname, o.ad_org_id as organizationid,
+    loc.address1 || COALESCE(' ' || loc.address2, '') as org_address,
+    loc.city || ', ' || ad_column_identifier('C_Region', loc.c_region_id, 'en_US') || ' ' || loc.postal
+    || ' ' || ad_column_identifier('C_Country', loc.c_country_id, 'en_US') AS org_postal,
+    (SELECT MAX(email) FROM ad_user WHERE ad_user_id=oinfo.ad_user_id) as email,
+    (SELECT MAX(phone) FROM ad_user WHERE ad_user_id=oinfo.ad_user_id) as phone
+FROM fact_acct f
+    LEFT JOIN c_acctschema acct ON (f.c_acctschema_id=acct.c_acctschema_id)
+    LEFT JOIN c_bpartner bp ON (f.c_bpartner_id=bp.c_bpartner_id), ad_org o
+    LEFT JOIN ad_orginfo oinfo ON (o.ad_org_id=oinfo.ad_org_id)
+    LEFT JOIN c_location loc ON (oinfo.c_location_id=loc.c_location_id)
+WHERE o.ad_org_id=$P{AD_Org_ID}
+    AND account_id IN
+        (SELECT account_id
+         FROM c_validcombination
+         WHERE c_acctschema_id = $P{C_AcctSchema_ID}
+             AND (c_validcombination_id IN
+                (SELECT c_receivable_acct
+                 FROM c_bp_customer_acct
+                 WHERE c_bpartner_id = $P{C_BPartner_ID}
+                 AND c_acctschema_id = $P{C_AcctSchema_ID})
+             OR c_validcombination_id IN
+                (SELECT c_prepayment_acct
+                 FROM c_bp_customer_acct
+                 WHERE c_bpartner_id = $P{C_BPartner_ID}
+                 AND c_acctschema_id = $P{C_AcctSchema_ID})))
+    AND f.c_bpartner_id =  $P{C_BPartner_ID}
+    AND f.c_acctschema_id = $P{C_AcctSchema_ID}
+    AND CASE WHEN ($P{DateFrom} IS NULL OR $P{DateFrom}='') THEN trunc(f.dateacct) >= TO_DATE('01-01-0001')
+        ELSE trunc(f.dateacct) >=TO_DATE($P{DateFrom}) END
+    AND CASE WHEN ($P{DateTo} IS NULL OR $P{DateTo}='') THEN trunc(f.dateacct) <= TO_DATE('09-09-9999')
+        ELSE trunc(f.dateacct) <=TO_DATE($P{DateTo}) END
+    AND f.ad_table_id IN ('318','D1A97202E832470285C9B1EB026D54E2','4D8C3B3C31D1410DA046140C9F024D17','B1B7075C46934F0A9FD4C4D0F1457B42')
+ORDER BY f.dateacct, f.created]]>
+	</queryString>
+	<field name="org_address" class="java.lang.String"/>
+	<field name="org_postal" class="java.lang.String"/>
+	<field name="date" class="java.util.Date"/>
+	<field name="organizationid" class="java.lang.String"/>
+	<field name="documenttype" class="java.lang.String"/>
+	<field name="description" class="java.lang.String"/>
+	<field name="bpname" class="java.lang.String"/>
+	<field name="email" class="java.lang.String"/>
+	<field name="phone" class="java.lang.String"/>
+	<field name="debit" class="java.math.BigDecimal"/>
+	<field name="credit" class="java.math.BigDecimal"/>
+	<field name="net" class="java.math.BigDecimal"/>
+	<variable name="SUM" class="java.math.BigDecimal" calculation="Sum">
+		<variableExpression><![CDATA[$F{net}]]></variableExpression>
+	</variable>
+	<variable name="DateFrom" class="java.util.Date" calculation="Lowest">
+		<variableExpression><![CDATA[$F{date}]]></variableExpression>
+	</variable>
+	<variable name="DateTo" class="java.util.Date" calculation="Highest">
+		<variableExpression><![CDATA[$F{date}]]></variableExpression>
+	</variable>
+	<group name="PrintLarge" isReprintHeaderOnEachPage="true">
+		<groupExpression><![CDATA[]]></groupExpression>
+	</group>
+	<group name="PrintMedium" isReprintHeaderOnEachPage="true">
+		<groupExpression><![CDATA[]]></groupExpression>
+	</group>
+	<background>
+		<band splitType="Stretch"/>
+	</background>
+	<title>
+		<band splitType="Stretch"/>
+	</title>
+	<pageHeader>
+		<band height="161" splitType="Stretch">
+			<rectangle>
+				<reportElement x="0" y="0" width="559" height="77" forecolor="#FFFFFF" backcolor="#FFFFFF"/>
+			</rectangle>
+			<image scaleImage="RetainShape" hAlign="Center" vAlign="Middle" isUsingCache="true">
+				<reportElement key="image-1" x="10" y="4" width="205" height="55"/>
+				<imageExpression class="java.net.URL"><![CDATA[new java.net.URL($P{BASE_WEB}+"/../utility/ShowImageLogo?logo=yourcompanydoc&orgId="+$F{organizationid})]]></imageExpression>
+			</image>
+			<textField>
+				<reportElement x="490" y="48" width="59" height="11"/>
+				<textElement textAlignment="Right" verticalAlignment="Bottom">
+					<font fontName="DejaVu Sans" size="9" isBold="true"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[DateFormat.getDateInstance(DateFormat.SHORT,
+        $P{LOCALE}).format(new Date())]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="0" y="101" width="235" height="12"/>
+				<textElement textAlignment="Left" verticalAlignment="Bottom">
+					<font fontName="DejaVu Sans" size="10" isBold="true"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[$F{bpname}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="10" y="59" width="301" height="12" isPrintInFirstWholeBand="true" isPrintWhenDetailOverflows="true" forecolor="#595959"/>
+				<textElement>
+					<font fontName="DejaVu Sans" size="9"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[$F{org_address} + " " + $F{org_postal}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="371" y="4" width="178" height="20" forecolor="#595959"/>
+				<textElement textAlignment="Right">
+					<font fontName="DejaVu Sans" size="16"/>
+				</textElement>
+				<text><![CDATA[Customer Statement]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="371" y="48" width="119" height="11" forecolor="#595959"/>
+				<textElement textAlignment="Right">
+					<font fontName="DejaVu Sans" size="9"/>
+				</textElement>
+				<text><![CDATA[Issued]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="515" y="101" width="12" height="12"/>
+				<textElement textAlignment="Center" verticalAlignment="Bottom">
+					<font fontName="DejaVu Sans" size="8"/>
+				</textElement>
+				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="483" y="101" width="32" height="12"/>
+				<textElement textAlignment="Center" verticalAlignment="Bottom">
+					<font fontName="DejaVu Sans" size="8"/>
+				</textElement>
+				<text><![CDATA[Page]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="527" y="101" width="11" height="12"/>
+				<textElement textAlignment="Justified" verticalAlignment="Bottom">
+					<font fontName="DejaVu Sans" size="8"/>
+				</textElement>
+				<text><![CDATA[of]]></text>
+			</staticText>
+			<textField evaluationTime="Report">
+				<reportElement positionType="Float" x="538" y="101" width="12" height="12"/>
+				<textElement textAlignment="Justified" verticalAlignment="Bottom">
+					<font fontName="DejaVu Sans" size="8"/>
+				</textElement>
+				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="128" y="148" width="202" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
+				<textElement textAlignment="Left" verticalAlignment="Top">
+					<font fontName="DejaVu Sans" size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Description]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="-1" y="148" width="48" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
+				<textElement verticalAlignment="Top">
+					<font fontName="DejaVu Sans" size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Date]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="47" y="148" width="81" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
+				<textElement textAlignment="Left" verticalAlignment="Top">
+					<font fontName="DejaVu Sans" size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Document Type]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="330" y="148" width="75" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
+				<textElement textAlignment="Right" verticalAlignment="Top">
+					<font fontName="DejaVu Sans" size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Debit]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="405" y="148" width="75" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
+				<textElement textAlignment="Right" verticalAlignment="Top">
+					<font fontName="DejaVu Sans" size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Credit]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="480" y="148" width="75" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
+				<textElement textAlignment="Right" verticalAlignment="Top">
+					<font fontName="DejaVu Sans" size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Net]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="0" y="124" width="32" height="12"/>
+				<textElement verticalAlignment="Bottom">
+					<font fontName="DejaVu Sans" size="10" isBold="false"/>
+				</textElement>
+				<text><![CDATA[From]]></text>
+			</staticText>
+			<textField evaluationTime="Report">
+				<reportElement x="33" y="124" width="45" height="12"/>
+				<textElement textAlignment="Right" verticalAlignment="Bottom">
+					<font fontName="DejaVu Sans" size="10" isBold="false"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[$P{DateFrom} != null ? DateFormat.getDateInstance(DateFormat.SHORT,$P{LOCALE}).format($P{DATEFORMAT}.parse($P{DateFrom}))  : DateFormat.getDateInstance(DateFormat.SHORT,$P{LOCALE}).format($V{DateFrom})]]></textFieldExpression>
+			</textField>
+			<textField evaluationTime="Report">
+				<reportElement x="96" y="124" width="45" height="12"/>
+				<textElement verticalAlignment="Bottom">
+					<font fontName="DejaVu Sans" size="10" isBold="false"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[$P{DateTo}  != null ? DateFormat.getDateInstance(DateFormat.SHORT,$P{LOCALE}).format($P{DATEFORMAT}.parse($P{DateTo})) : DateFormat.getDateInstance(DateFormat.SHORT,$P{LOCALE}).format($V{DateTo})]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="78" y="124" width="18" height="12"/>
+				<textElement textAlignment="Center" verticalAlignment="Bottom">
+					<font fontName="DejaVu Sans" size="10" isBold="false"/>
+				</textElement>
+				<text><![CDATA[to]]></text>
+			</staticText>
+		</band>
+	</pageHeader>
+	<detail>
+		<band height="14">
+			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
+				<reportElement style="Detail_Line" stretchType="RelativeToTallestObject" x="0" y="0" width="47" height="14"/>
+				<box leftPadding="3"/>
+				<textElement verticalAlignment="Middle">
+					<font fontName="DejaVu Sans" size="8"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[DateFormat.getDateInstance(DateFormat.SHORT,
+        $P{LOCALE}).format($F{date})]]></textFieldExpression>
+			</textField>
+			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
+				<reportElement style="Detail_Line" stretchType="RelativeToTallestObject" x="47" y="0" width="81" height="14"/>
+				<textElement verticalAlignment="Middle">
+					<font fontName="DejaVu Sans" size="8"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[$F{documenttype}]]></textFieldExpression>
+			</textField>
+			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
+				<reportElement style="Detail_Line" stretchType="RelativeToTallestObject" x="128" y="0" width="202" height="14"/>
+				<textElement verticalAlignment="Middle">
+					<font fontName="DejaVu Sans" size="8"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[$F{description}]]></textFieldExpression>
+			</textField>
+			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
+				<reportElement style="Detail_Line" stretchType="RelativeToTallestObject" x="405" y="0" width="75" height="14"/>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font fontName="DejaVu Sans" size="8"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[$F{credit}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($F{credit}.abs()) + ")" : $P{NUMBERFORMAT}.format($F{credit})]]></textFieldExpression>
+			</textField>
+			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
+				<reportElement style="Detail_Line" stretchType="RelativeToTallestObject" x="330" y="0" width="75" height="14"/>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font fontName="DejaVu Sans" size="8"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[$F{debit}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($F{debit}.abs()) + ")" : $P{NUMBERFORMAT}.format($F{debit})]]></textFieldExpression>
+			</textField>
+			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
+				<reportElement style="Detail_Line" stretchType="RelativeToTallestObject" x="480" y="0" width="75" height="14"/>
+				<box rightPadding="3"/>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font fontName="DejaVu Sans" size="8"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[$V{SUM}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($V{SUM}.abs()) + ")" : $P{NUMBERFORMAT}.format($V{SUM})]]></textFieldExpression>
+			</textField>
+		</band>
+	</detail>
+	<summary>
+		<band height="66" splitType="Stretch">
+			<textField evaluationTime="Report">
+				<reportElement positionType="Float" mode="Opaque" x="395" y="19" width="160" height="43" forecolor="#FFFFFF" backcolor="#4E6230"/>
+				<box rightPadding="5"/>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font fontName="DejaVu Sans" size="18" isBold="true"/>
+				</textElement>
+				<textFieldExpression class="java.lang.String"><![CDATA[$V{SUM}.compareTo(BigDecimal.ZERO) < 0 ? "(" + $P{NUMBERFORMAT}.format($V{SUM}.abs()) + ")" : $P{NUMBERFORMAT}.format($V{SUM})]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement positionType="Float" mode="Opaque" x="299" y="19" width="96" height="43" forecolor="#FFFFFF" backcolor="#4E6230"/>
+				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" lineSpacing="Single" markup="none">
+					<font fontName="DejaVu Sans" size="18" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
+				</textElement>
+				<text><![CDATA[Balance:]]></text>
+			</staticText>
+		</band>
+	</summary>
+</jasperReport>