details:   https://code.openbravo.com/erp/devel/main/rev/0175279b4dbe
changeset: 20177:0175279b4dbe
user:      Augusto Mauch <augusto.mauch <at> openbravo.com>
date:      Tue Apr 23 10:54:40 2013 +0200
summary:   Related to issue 20422: Adds the new Insert Audits fields

This changeset contains all the changes related to the addition of the new 
Insert Audits field:
- Creation of the new column in the database
- Changes in the Application Dictionary (AD_COLUMN, AD_FIELD; AD_ELEMENT)
- It is a mandatory column, so it has been created in all AD_TABLES with its 
default value ('Y')

details:   https://code.openbravo.com/erp/devel/main/rev/d8c6a9c2b6ac
changeset: 20178:d8c6a9c2b6ac
user:      Augusto Mauch <augusto.mauch <at> openbravo.com>
date:      Tue Apr 23 11:03:37 2013 +0200
summary:   Related to issue 20422: Updates the ad_create_audit_triggers SQL 
function

The ad_create_audit_triggers SQL function has been updated to use the new 
AD_TABLE.ISAUDITINSERTS column,

The behaviour of the triggers when a record is updated or deleted has not been 
changed. When a record is inserted, if the ISAUDITINSERTS column of the audit 
column is'Y' (default value), the behaviour will be the same as the previous 
one. If ISAUDITINSERTS is 'N', then only the key column of the audited table 
will be inserted in the audit table.

details:   https://code.openbravo.com/erp/devel/main/rev/c33d0871c1d8
changeset: 20179:c33d0871c1d8
user:      Augusto Mauch <augusto.mauch <at> openbravo.com>
date:      Tue Apr 23 11:08:42 2013 +0200
summary:   Related to issue 20422: Updates AD_TABLE_MOD_TRG trigger

The AD_TABLE_MOD_TRG has been updated, so that the Updated column of the table 
is not changed if the only modified column is ISFULLYAUDITED or ISAUDITINSERTS.

details:   https://code.openbravo.com/erp/devel/main/rev/c0c3d4e9feab
changeset: 20180:c0c3d4e9feab
user:      Augusto Mauch <augusto.mauch <at> openbravo.com>
date:      Tue Apr 23 11:12:29 2013 +0200
summary:   Fixes issue 20422: Updates the AuditTrailPopup to consider show ID 
column

The AuditTrailPopup has been updated to show the ID column of the audit table. 
This is needed because now if an audited table is flagged as 
ISAUDITINSERTS='N', only the ID column of the table will be inserted in the 
audit table. Originally the popup did not show the records of the audit table 
belonging to its id column.

details:   https://code.openbravo.com/erp/devel/main/rev/423380e4f7ea
changeset: 20181:423380e4f7ea
user:      David Miguelez <david.miguelez <at> openbravo.com>
date:      Tue Apr 23 12:52:24 2013 +0200
summary:   Related to Issue 23012: Orders Accounting Tab below Transactions
Tab by Debit and Credit.

details:   https://code.openbravo.com/erp/devel/main/rev/e1f39d8fd8c2
changeset: 20182:e1f39d8fd8c2
user:      Sandra Huguet <sandra.huguet <at> openbravo.com>
date:      Fri Apr 19 15:01:29 2013 +0200
summary:   Fixed bug 23593

details:   https://code.openbravo.com/erp/devel/main/rev/51ad74e87865
changeset: 20183:51ad74e87865
user:      Sandra Huguet <sandra.huguet <at> openbravo.com>
date:      Mon Apr 22 13:21:47 2013 +0200
summary:   Related to issue 23593

details:   https://code.openbravo.com/erp/devel/main/rev/a9de8a0c8af8
changeset: 20184:a9de8a0c8af8
user:      Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date:      Tue Apr 23 13:23:20 2013 +0200
summary:   Fixes bug 23110

details:   https://code.openbravo.com/erp/devel/main/rev/d4a9088f6a09
changeset: 20185:d4a9088f6a09
user:      Augusto Mauch <augusto.mauch <at> openbravo.com>
date:      Tue Apr 23 16:14:34 2013 +0200
summary:   Fixes issue 23619: P&E grids remember the selection when grid is 
sorted

details:   https://code.openbravo.com/erp/devel/main/rev/f2798a936ca5
changeset: 20186:f2798a936ca5
user:      David Miguelez <david.miguelez <at> openbravo.com>
date:      Tue Apr 23 17:26:44 2013 +0200
summary:   Fixes Issue 23610. Fixes Query so it retrieves values correctly.

details:   https://code.openbravo.com/erp/devel/main/rev/c4cdf13ff45e
changeset: 20187:c4cdf13ff45e
user:      David Miguelez <david.miguelez <at> openbravo.com>
date:      Thu Apr 18 18:27:14 2013 +0200
summary:   Fixes Issue 23584. Creates a new OBUISel_Selector for Element Values.

details:   https://code.openbravo.com/erp/devel/main/rev/98249a01fff0
changeset: 20188:98249a01fff0
user:      Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> 
openbravo.com>
date:      Thu Apr 18 10:17:54 2013 +0530
summary:   Fixes Issue 23540: Combo boxes that load huge data are causing 
performance issue

details:   https://code.openbravo.com/erp/devel/main/rev/03f22c0f86a0
changeset: 20189:03f22c0f86a0
user:      Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date:      Tue Apr 23 19:28:04 2013 +0200
summary:   Fixes bug 23590

details:   https://code.openbravo.com/erp/devel/main/rev/4d9fc1600da5
changeset: 20190:4d9fc1600da5
user:      RM packaging bot <staff.rm <at> openbravo.com>
date:      Tue Apr 23 21:03:07 2013 +0200
summary:   CI: merge back from main

details:   https://code.openbravo.com/erp/devel/main/rev/fe669254024a
changeset: 20191:fe669254024a
user:      Javier Etxarri <javier.echarri <at> openbravo.com>
date:      Wed Apr 24 00:58:21 2013 +0200
summary:   Fixes issue 23235: Wrong selector in Product BOM tab

details:   https://code.openbravo.com/erp/devel/main/rev/0136b85e15e3
changeset: 20192:0136b85e15e3
user:      Javier Etxarri <javier.echarri <at> openbravo.com>
date:      Wed Apr 24 01:20:49 2013 +0200
summary:   Fixes issue 23164: It is possible to create a two price list versions
with same name and same valid from date

details:   https://code.openbravo.com/erp/devel/main/rev/53ca1adce250
changeset: 20193:53ca1adce250
user:      Javier Etxarri <javier.echarri <at> openbravo.com>
date:      Wed Apr 24 10:27:58 2013 +0200
summary:   backout issue issue 23164: It is possible to create a two price list
version with same name and validfrom date

details:   https://code.openbravo.com/erp/devel/main/rev/b1183f88c4a6
changeset: 20194:b1183f88c4a6
user:      Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> 
openbravo.com>
date:      Tue Apr 23 22:28:03 2013 +0530
summary:   Fixes issue 23376: Exchange rate is rounded when adding payment for 
a transaction

details:   https://code.openbravo.com/erp/devel/main/rev/8add402536e8
changeset: 20195:8add402536e8
user:      Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date:      Wed Apr 24 11:48:55 2013 +0200
summary:   Adds matching logic for Standard matching algorithm when using 
GLItems

details:   https://code.openbravo.com/erp/devel/main/rev/ae04c3e9f188
changeset: 20196:ae04c3e9f188
user:      Sandra Huguet <sandra.huguet <at> openbravo.com>
date:      Thu Apr 18 16:59:28 2013 +0200
summary:   Fixed issue 23559 Sample data (F&B client) monthly update

details:   https://code.openbravo.com/erp/devel/main/rev/ae68a1eca827
changeset: 20197:ae68a1eca827
user:      Sandra Huguet <sandra.huguet <at> openbravo.com>
date:      Fri Apr 19 09:35:38 2013 +0200
summary:   Fixed issue 23225 Change Profit & Loss structure of F&B International
Change Profit & Loss structure of F&B International and close 2012 year

details:   https://code.openbravo.com/erp/devel/main/rev/533959c7261a
changeset: 20198:533959c7261a
user:      Sandra Huguet <sandra.huguet <at> openbravo.com>
date:      Wed Apr 24 08:59:48 2013 +0200
summary:   Fixed bug 23537 Increase the frequency of background processes

details:   https://code.openbravo.com/erp/devel/main/rev/ff801b2d25fa
changeset: 20199:ff801b2d25fa
user:      Sandra Huguet <sandra.huguet <at> openbravo.com>
date:      Wed Apr 24 09:03:13 2013 +0200
summary:   Related to bug 23537 Increase the frequency of background processes

details:   https://code.openbravo.com/erp/devel/main/rev/9d69821c5afd
changeset: 20200:9d69821c5afd
user:      Sandra Huguet <sandra.huguet <at> openbravo.com>
date:      Wed Apr 24 12:15:08 2013 +0200
summary:   Related to issue 23593

details:   https://code.openbravo.com/erp/devel/main/rev/574c4d2cb52c
changeset: 20201:574c4d2cb52c
user:      Sandra Huguet <sandra.huguet <at> openbravo.com>
date:      Wed Apr 24 12:26:03 2013 +0200
summary:   Fixed bug 23425 Uncheck central maintenance in F&B EspaƱa

details:   https://code.openbravo.com/erp/devel/main/rev/9fa1ecafd560
changeset: 20202:9fa1ecafd560
user:      RM packaging bot <staff.rm <at> openbravo.com>
date:      Thu Apr 25 01:10:32 2013 +0200
summary:   CI: update AD_MODULE to version 20201

diffstat:

 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml   
                                      |        2 +-
 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml 
                                      |        2 +-
 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml  
                                      |        2 +-
 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                             |        4 +-
 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml
                                     |       12 +
 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml     
                                      |        2 +-
 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml   
                                      |        7 +
 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_VAL_RULE.xml 
                                     |        2 +-
 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
                                 |       15 +
 
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/MatchTransaction.java
          |       31 +-
 
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/algorithm/StandardMatchingAlgorithm.java
       |       18 +-
 
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_PaymentProcess.java
                |        6 +-
 
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_ReconciliationProcess.java
         |       23 +
 
modules/org.openbravo.advpaymentmngt/web/org.openbravo.advpaymentmngt/FIN_Utilities.js
                               |       10 +-
 modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE.xml       
                                      |        2 +-
 
modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                                  |        2 +-
 
modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MODULE.xml
                                    |        2 +-
 
modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                         |        8 +-
 
modules/org.openbravo.client.application/src-db/database/sourcedata/AD_TABLE.xml
                                     |       13 +
 
modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-grid.js
 |        2 +-
 
modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/AD_MODULE.xml
                                     |        2 +-
 
modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                          |        2 +-
 modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_MODULE.xml   
                                      |        2 +-
 
modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                              |        6 +-
 modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_TABLE.xml    
                                      |        4 +
 modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_MODULE.xml     
                                      |        2 +-
 
modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                                |        4 +-
 modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_TABLE.xml      
                                      |        9 +
 
modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_MODULE.xml 
                                     |        2 +-
 
modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                           |        2 +-
 modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_TABLE.xml 
                                      |        3 +
 modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE.xml  
                                      |        2 +-
 
modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                             |        2 +-
 
modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MODULE.xml
                               |        2 +-
 
modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                    |        2 +-
 
modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_MODULE.xml
                        |        2 +-
 
modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
             |        2 +-
 
modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_MODULE.xml
                                    |        2 +-
 
modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                         |       10 +-
 
modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_TABLE.xml
                                     |        2 +
 
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE.xml
                            |        2 +-
 
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                 |        4 +-
 
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_TABLE.xml
                             |        1 +
 
modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_MODULE.xml
                            |        2 +-
 
modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                 |        2 +-
 
modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_TABLE.xml
                             |        1 +
 modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MODULE.xml    
                                      |        2 +-
 
modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                               |        2 +-
 
modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_MODULE.xml
                                |        2 +-
 
modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                     |       12 +-
 
modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_TABLE.xml
                                 |        4 +
 
modules/org.openbravo.userinterface.skin.250to300Comp/src-db/database/sourcedata/AD_MODULE.xml
                       |        2 +-
 
modules/org.openbravo.userinterface.skin.250to300Comp/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
            |        2 +-
 
modules/org.openbravo.userinterface.smartclient/src-db/database/sourcedata/AD_MODULE.xml
                             |        2 +-
 
modules/org.openbravo.userinterface.smartclient/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                  |        6 +-
 modules/org.openbravo.v3.datasets/src-db/database/sourcedata/AD_MODULE.xml     
                                      |        2 +-
 
modules/org.openbravo.v3.datasets/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                                |        6 +-
 modules/org.openbravo.v3.framework/src-db/database/sourcedata/AD_MODULE.xml    
                                      |        2 +-
 
modules/org.openbravo.v3.framework/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
                               |       24 +-
 modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE.xml              
                                      |        2 +-
 modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml   
                                      |       18 +-
 referencedata/sampledata/F_B_International_Group.xml                           
                                      |  1385322 +++++----
 src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml                  
                                      |       11 +-
 src-db/database/model/postscript-Oracle.sql                                    
                                      |       14 +
 src-db/database/model/postscript-PostgreSql.sql                                
                                      |       14 +
 src-db/database/model/tables/AD_TABLE.xml                                      
                                      |        5 +
 src-db/database/model/triggers/AD_TABLE_MOD_TRG.xml                            
                                      |        2 +-
 src-db/database/sourcedata/AD_COLUMN.xml                                       
                                      |       65 +-
 src-db/database/sourcedata/AD_ELEMENT.xml                                      
                                      |       14 +
 src-db/database/sourcedata/AD_FIELD.xml                                        
                                      |       29 +
 src-db/database/sourcedata/AD_MODULE.xml                                       
                                      |        4 +-
 src-db/database/sourcedata/AD_REFERENCE.xml                                    
                                      |       48 +
 src-db/database/sourcedata/AD_TABLE.xml                                        
                                      |      483 +
 src-db/database/sourcedata/OBUISEL_SELECTOR.xml                                
                                      |       63 +
 src-db/database/sourcedata/referencedData/AD_PROCESS_REQUEST.xml               
                                      |        5 +-
 
src-util/modulescript/src/org/openbravo/modulescript/UpdateOpenClosePeriodsButton_data.xsql
                          |       18 +-
 src/org/openbravo/erpCommon/businessUtility/AuditTrailPopup.java               
                                      |        3 +-
 src/org/openbravo/erpCommon/businessUtility/EndYearCloseUtility.java           
                                      |        4 +-
 78 files changed, 728430 insertions(+), 658003 deletions(-)

diffs (truncated from 1463295 to 300 lines):

diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml  
    Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml  
    Thu Apr 25 01:10:32 2013 +0200
@@ -7878,7 +7878,7 @@
 <!--7DFD1BBEC2F60C48E040007F01004674-->  
<AD_COLUMN_ID><![CDATA[7DC34559B3F2B45BE040007F0100784A]]></AD_COLUMN_ID>
 <!--7DFD1BBEC2F60C48E040007F01004674-->  
<IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--7DFD1BBEC2F60C48E040007F01004674-->  
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--7DFD1BBEC2F60C48E040007F01004674-->  
<DISPLAYLOGIC><![CDATA[@Processed@='Y' & @Status@!'RPVOID']]></DISPLAYLOGIC>
+<!--7DFD1BBEC2F60C48E040007F01004674-->  
<DISPLAYLOGIC><![CDATA[@Processed@='Y' & @Status@!'RPVOID' & 
@FIN_Rev_Payment_ID@ = '']]></DISPLAYLOGIC>
 <!--7DFD1BBEC2F60C48E040007F01004674-->  
<DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
 <!--7DFD1BBEC2F60C48E040007F01004674-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--7DFD1BBEC2F60C48E040007F01004674-->  <SEQNO><![CDATA[130]]></SEQNO>
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml
    Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml
    Thu Apr 25 01:10:32 2013 +0200
@@ -294,7 +294,7 @@
 <!--48898A3B7F9141C0B9BFBDD9AE5FCF8F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--48898A3B7F9141C0B9BFBDD9AE5FCF8F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--48898A3B7F9141C0B9BFBDD9AE5FCF8F-->  
<VALUE><![CDATA[APRM_PeriodNotAvailableClearedItem]]></VALUE>
-<!--48898A3B7F9141C0B9BFBDD9AE5FCF8F-->  <MSGTEXT><![CDATA[The period of the 
cleared item (%s) is not open or available.]]></MSGTEXT>
+<!--48898A3B7F9141C0B9BFBDD9AE5FCF8F-->  <MSGTEXT><![CDATA[The reconciliation 
cannot be completed because it contains one or more items in a closed 
period.<BR>The period of the cleared item (%s) is not open or 
available.]]></MSGTEXT>
 <!--48898A3B7F9141C0B9BFBDD9AE5FCF8F-->  <MSGTYPE><![CDATA[E]]></MSGTYPE>
 <!--48898A3B7F9141C0B9BFBDD9AE5FCF8F-->  
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
 <!--48898A3B7F9141C0B9BFBDD9AE5FCF8F-->  
<ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N>
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml 
    Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml 
    Thu Apr 25 01:10:32 2013 +0200
@@ -6,7 +6,7 @@
 <!--A918E3331C404B889D69AA9BFAFB23AC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--A918E3331C404B889D69AA9BFAFB23AC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--A918E3331C404B889D69AA9BFAFB23AC-->  <NAME><![CDATA[Advanced Payables and 
Receivables Mngmt]]></NAME>
-<!--A918E3331C404B889D69AA9BFAFB23AC-->  
<VERSION><![CDATA[3.0.20165]]></VERSION>
+<!--A918E3331C404B889D69AA9BFAFB23AC-->  
<VERSION><![CDATA[3.0.20201]]></VERSION>
 <!--A918E3331C404B889D69AA9BFAFB23AC-->  <DESCRIPTION><![CDATA[Managing your 
finances with an ERP does not have to be difficult. Enjoy a radically improved 
user experience that combines the power of an enterprise grade financial 
application with the simplicity and ease of a web 2.0 personal accounting 
service.]]></DESCRIPTION>
 <!--A918E3331C404B889D69AA9BFAFB23AC-->  <HELP><![CDATA[Advanced Payables and 
Receivables Management simplifies and automates the business processes around 
the management of financial accounts, from the receipt and issue of payment, to 
the reconciliation of those events with bank statements.
 If you would like to help shape this module you are welcome to take part in 
the forum discussions or register feature requests or issues in the 
corresponding (Forum and Bug Tracking) sections in the Advanced Payables and 
Receivable project in the OB Forge.]]></HELP>
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
  Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
  Thu Apr 25 01:10:32 2013 +0200
@@ -7,7 +7,7 @@
 <!--89326AE95DAD449D85DFAB2C5B1C6683-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--89326AE95DAD449D85DFAB2C5B1C6683-->  
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
 <!--89326AE95DAD449D85DFAB2C5B1C6683-->  
<AD_DEPENDENT_MODULE_ID><![CDATA[5EB4F15C80684ACA904756BDC12ADBE5]]></AD_DEPENDENT_MODULE_ID>
-<!--89326AE95DAD449D85DFAB2C5B1C6683-->  
<STARTVERSION><![CDATA[2.1.20165]]></STARTVERSION>
+<!--89326AE95DAD449D85DFAB2C5B1C6683-->  
<STARTVERSION><![CDATA[2.1.20201]]></STARTVERSION>
 <!--89326AE95DAD449D85DFAB2C5B1C6683-->  <ISINCLUDED><![CDATA[N]]></ISINCLUDED>
 <!--89326AE95DAD449D85DFAB2C5B1C6683-->  <DEPENDANT_MODULE_NAME><![CDATA[User 
Interface Selector]]></DEPENDANT_MODULE_NAME>
 <!--89326AE95DAD449D85DFAB2C5B1C6683-->  
<DEPENDENCY_ENFORCEMENT><![CDATA[MAJOR]]></DEPENDENCY_ENFORCEMENT>
@@ -21,7 +21,7 @@
 <!--B97FC854C6DD41E692161585645A900F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--B97FC854C6DD41E692161585645A900F-->  
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
 <!--B97FC854C6DD41E692161585645A900F-->  
<AD_DEPENDENT_MODULE_ID><![CDATA[0]]></AD_DEPENDENT_MODULE_ID>
-<!--B97FC854C6DD41E692161585645A900F-->  
<STARTVERSION><![CDATA[3.0.20165]]></STARTVERSION>
+<!--B97FC854C6DD41E692161585645A900F-->  
<STARTVERSION><![CDATA[3.0.20201]]></STARTVERSION>
 <!--B97FC854C6DD41E692161585645A900F-->  <ISINCLUDED><![CDATA[N]]></ISINCLUDED>
 <!--B97FC854C6DD41E692161585645A900F-->  
<DEPENDANT_MODULE_NAME><![CDATA[core]]></DEPENDANT_MODULE_NAME>
 <!--B97FC854C6DD41E692161585645A900F-->  
<DEPENDENCY_ENFORCEMENT><![CDATA[MAJOR]]></DEPENDENCY_ENFORCEMENT>
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml
  Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml
  Thu Apr 25 01:10:32 2013 +0200
@@ -157,6 +157,18 @@
 <!--DB71FC312327430EAEACF42918405BF9-->  
<ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--DB71FC312327430EAEACF42918405BF9--></AD_REFERENCE>
 
+<!--E1C0B1C7D7C84E85903409A39A53E855--><AD_REFERENCE>
+<!--E1C0B1C7D7C84E85903409A39A53E855-->  
<AD_REFERENCE_ID><![CDATA[E1C0B1C7D7C84E85903409A39A53E855]]></AD_REFERENCE_ID>
+<!--E1C0B1C7D7C84E85903409A39A53E855-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E1C0B1C7D7C84E85903409A39A53E855-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E1C0B1C7D7C84E85903409A39A53E855-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E1C0B1C7D7C84E85903409A39A53E855-->  <NAME><![CDATA[FIN_Payment no 
combo]]></NAME>
+<!--E1C0B1C7D7C84E85903409A39A53E855-->  
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--E1C0B1C7D7C84E85903409A39A53E855-->  
<ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--E1C0B1C7D7C84E85903409A39A53E855-->  
<PARENTREFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></PARENTREFERENCE_ID>
+<!--E1C0B1C7D7C84E85903409A39A53E855-->  
<ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--E1C0B1C7D7C84E85903409A39A53E855--></AD_REFERENCE>
+
 <!--E91B038ABF4F4A2280264C4A475852A4--><AD_REFERENCE>
 <!--E91B038ABF4F4A2280264C4A475852A4-->  
<AD_REFERENCE_ID><![CDATA[E91B038ABF4F4A2280264C4A475852A4]]></AD_REFERENCE_ID>
 <!--E91B038ABF4F4A2280264C4A475852A4-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml    
    Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml    
    Thu Apr 25 01:10:32 2013 +0200
@@ -85,7 +85,7 @@
 <!--2A9BA5FDA0F8470D881F8EA9DEDCC598-->  <ISSORTTAB><![CDATA[N]]></ISSORTTAB>
 <!--2A9BA5FDA0F8470D881F8EA9DEDCC598-->  
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
 <!--2A9BA5FDA0F8470D881F8EA9DEDCC598-->  <UIPATTERN><![CDATA[RO]]></UIPATTERN>
-<!--2A9BA5FDA0F8470D881F8EA9DEDCC598-->  
<HQLORDERBYCLAUSE><![CDATA[-accountingDate,financialAccountTransaction,groupID,-sequenceNumber]]></HQLORDERBYCLAUSE>
+<!--2A9BA5FDA0F8470D881F8EA9DEDCC598-->  
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit) 
desc, credit desc, value]]></HQLORDERBYCLAUSE>
 <!--2A9BA5FDA0F8470D881F8EA9DEDCC598-->  
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
 <!--2A9BA5FDA0F8470D881F8EA9DEDCC598-->  
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
 <!--2A9BA5FDA0F8470D881F8EA9DEDCC598-->  
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml  
    Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml  
    Thu Apr 25 01:10:32 2013 +0200
@@ -19,6 +19,7 @@
 <!--0DFF5BACFB964FDABAA5042C8809C813-->  
<ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--0DFF5BACFB964FDABAA5042C8809C813-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--0DFF5BACFB964FDABAA5042C8809C813-->  
<AD_PACKAGE_ID><![CDATA[AC33B2262748414A816510545755435A]]></AD_PACKAGE_ID>
+<!--0DFF5BACFB964FDABAA5042C8809C813-->  
<ISAUDITINSERTS><![CDATA[Y]]></ISAUDITINSERTS>
 <!--0DFF5BACFB964FDABAA5042C8809C813--></AD_TABLE>
 
 <!--1BAA61D216CB4A62838AA785658EE092--><AD_TABLE>
@@ -42,6 +43,7 @@
 <!--1BAA61D216CB4A62838AA785658EE092-->  
<ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--1BAA61D216CB4A62838AA785658EE092-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--1BAA61D216CB4A62838AA785658EE092-->  
<AD_PACKAGE_ID><![CDATA[AC33B2262748414A816510545755435A]]></AD_PACKAGE_ID>
+<!--1BAA61D216CB4A62838AA785658EE092-->  
<ISAUDITINSERTS><![CDATA[Y]]></ISAUDITINSERTS>
 <!--1BAA61D216CB4A62838AA785658EE092--></AD_TABLE>
 
 <!--5AAFAB80FB6740D2A6190CB3939D90EC--><AD_TABLE>
@@ -63,6 +65,7 @@
 <!--5AAFAB80FB6740D2A6190CB3939D90EC-->  
<ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--5AAFAB80FB6740D2A6190CB3939D90EC-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--5AAFAB80FB6740D2A6190CB3939D90EC-->  
<AD_PACKAGE_ID><![CDATA[AC33B2262748414A816510545755435A]]></AD_PACKAGE_ID>
+<!--5AAFAB80FB6740D2A6190CB3939D90EC-->  
<ISAUDITINSERTS><![CDATA[Y]]></ISAUDITINSERTS>
 <!--5AAFAB80FB6740D2A6190CB3939D90EC--></AD_TABLE>
 
 <!--DC814AB3BC84486CA5411131724BC95A--><AD_TABLE>
@@ -84,6 +87,7 @@
 <!--DC814AB3BC84486CA5411131724BC95A-->  
<ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--DC814AB3BC84486CA5411131724BC95A-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--DC814AB3BC84486CA5411131724BC95A-->  
<AD_PACKAGE_ID><![CDATA[AC33B2262748414A816510545755435A]]></AD_PACKAGE_ID>
+<!--DC814AB3BC84486CA5411131724BC95A-->  
<ISAUDITINSERTS><![CDATA[Y]]></ISAUDITINSERTS>
 <!--DC814AB3BC84486CA5411131724BC95A--></AD_TABLE>
 
 <!--FF8080812FFEC82D012FFECCE3400030--><AD_TABLE>
@@ -105,6 +109,7 @@
 <!--FF8080812FFEC82D012FFECCE3400030-->  
<ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--FF8080812FFEC82D012FFECCE3400030-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--FF8080812FFEC82D012FFECCE3400030-->  
<AD_PACKAGE_ID><![CDATA[AC33B2262748414A816510545755435A]]></AD_PACKAGE_ID>
+<!--FF8080812FFEC82D012FFECCE3400030-->  
<ISAUDITINSERTS><![CDATA[Y]]></ISAUDITINSERTS>
 <!--FF8080812FFEC82D012FFECCE3400030--></AD_TABLE>
 
 <!--FF80808130BB89090130BB8E3D7E0012--><AD_TABLE>
@@ -128,6 +133,7 @@
 <!--FF80808130BB89090130BB8E3D7E0012-->  
<ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--FF80808130BB89090130BB8E3D7E0012-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--FF80808130BB89090130BB8E3D7E0012-->  
<AD_PACKAGE_ID><![CDATA[AC33B2262748414A816510545755435A]]></AD_PACKAGE_ID>
+<!--FF80808130BB89090130BB8E3D7E0012-->  
<ISAUDITINSERTS><![CDATA[Y]]></ISAUDITINSERTS>
 <!--FF80808130BB89090130BB8E3D7E0012--></AD_TABLE>
 
 <!--FF808081331848750133184B38D20009--><AD_TABLE>
@@ -148,6 +154,7 @@
 <!--FF808081331848750133184B38D20009-->  
<ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--FF808081331848750133184B38D20009-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--FF808081331848750133184B38D20009-->  
<AD_PACKAGE_ID><![CDATA[AC33B2262748414A816510545755435A]]></AD_PACKAGE_ID>
+<!--FF808081331848750133184B38D20009-->  
<ISAUDITINSERTS><![CDATA[Y]]></ISAUDITINSERTS>
 <!--FF808081331848750133184B38D20009--></AD_TABLE>
 
 </data>
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_VAL_RULE.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_VAL_RULE.xml
   Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_VAL_RULE.xml
   Thu Apr 25 01:10:32 2013 +0200
@@ -51,7 +51,7 @@
 <!--575E470ABADB4C278132C957A78C47E3-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--575E470ABADB4C278132C957A78C47E3-->  <NAME><![CDATA[Process Payment valid 
actions]]></NAME>
 <!--575E470ABADB4C278132C957A78C47E3-->  <TYPE><![CDATA[S]]></TYPE>
-<!--575E470ABADB4C278132C957A78C47E3-->  
<CODE><![CDATA[((@EM_APRM_Process_Payment@ = 'P' AND AD_Ref_List.value='P') OR 
(@EM_APRM_Process_Payment@ in ('R','RE') AND AD_Ref_List.value IN ('RE','R')) 
OR (@EM_APRM_Process_Payment@ in ('R','RE') AND AD_Ref_List.value IN ('V') AND 
@Status@='RPAE') OR (@EM_APRM_Process_Payment@ is null)) AND 
AD_Ref_List.IsActive = 'Y']]></CODE>
+<!--575E470ABADB4C278132C957A78C47E3-->  
<CODE><![CDATA[((@EM_APRM_Process_Payment@ = 'P' AND AD_Ref_List.value='P') OR 
(@EM_APRM_Process_Payment@ in ('R','RE') AND AD_Ref_List.value IN ('RE','R') 
AND NOT EXISTS (SELECT 1 FROM FIN_PAYMENT WHERE FIN_Rev_Payment_ID = 
@FIN_Payment_ID@)) OR (@EM_APRM_Process_Payment@ in ('R','RE') AND 
AD_Ref_List.value IN ('R') AND EXISTS (SELECT 1 FROM FIN_PAYMENT WHERE 
FIN_Rev_Payment_ID = @FIN_Payment_ID@)) OR (@EM_APRM_Process_Payment@ in 
('R','RE') AND AD_Ref_List.value IN ('V') AND @Status@='RPAE') OR 
(@EM_APRM_Process_Payment@ is null)) AND AD_Ref_List.IsActive = 'Y']]></CODE>
 <!--575E470ABADB4C278132C957A78C47E3-->  
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
 <!--575E470ABADB4C278132C957A78C47E3--></AD_VAL_RULE>
 
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
      Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
      Thu Apr 25 01:10:32 2013 +0200
@@ -38,6 +38,21 @@
 <!--9FAD469CE4414A25974CF45C0AD22D35-->  
<CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--9FAD469CE4414A25974CF45C0AD22D35--></OBUISEL_SELECTOR>
 
+<!--A021037EAFFA49D299E4B6886E6A811C--><OBUISEL_SELECTOR>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  
<OBUISEL_SELECTOR_ID><![CDATA[A021037EAFFA49D299E4B6886E6A811C]]></OBUISEL_SELECTOR_ID>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  <NAME><![CDATA[FIN_Payment no 
combo]]></NAME>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  
<AD_REFERENCE_ID><![CDATA[E1C0B1C7D7C84E85903409A39A53E855]]></AD_REFERENCE_ID>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  
<AD_TABLE_ID><![CDATA[D1A97202E832470285C9B1EB026D54E2]]></AD_TABLE_ID>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  
<OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  
<SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  
<POPUPTEXTMATCHSTYLE><![CDATA[substring]]></POPUPTEXTMATCHSTYLE>
+<!--A021037EAFFA49D299E4B6886E6A811C-->  
<CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
+<!--A021037EAFFA49D299E4B6886E6A811C--></OBUISEL_SELECTOR>
+
 <!--A98899B1C75A4F4EBD3414F1B654EFAB--><OBUISEL_SELECTOR>
 <!--A98899B1C75A4F4EBD3414F1B654EFAB-->  
<OBUISEL_SELECTOR_ID><![CDATA[A98899B1C75A4F4EBD3414F1B654EFAB]]></OBUISEL_SELECTOR_ID>
 <!--A98899B1C75A4F4EBD3414F1B654EFAB-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/MatchTransaction.java
--- 
a/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/MatchTransaction.java
       Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/MatchTransaction.java
       Thu Apr 25 01:10:32 2013 +0200
@@ -40,6 +40,7 @@
 import org.openbravo.advpaymentmngt.dao.MatchTransactionDao;
 import org.openbravo.advpaymentmngt.dao.TransactionsDao;
 import org.openbravo.advpaymentmngt.process.FIN_AddPayment;
+import org.openbravo.advpaymentmngt.process.FIN_ReconciliationProcess;
 import org.openbravo.advpaymentmngt.process.FIN_TransactionProcess;
 import org.openbravo.advpaymentmngt.utility.FIN_MatchedTransaction;
 import org.openbravo.advpaymentmngt.utility.FIN_MatchingTransaction;
@@ -317,12 +318,21 @@
           .getBankStatementLineMaxDate(financialAccount));
       reconciliation.setTransactionDate(MatchTransactionDao
           .getBankStatementLineMaxDate(financialAccount));
-      reconciliation.setProcessed(process);
-      reconciliation.setDocumentStatus(process ? "CO" : "DR");
-      reconciliation.setAPRMProcessReconciliation(process ? "R" : "P");
-      reconciliation.setAprmProcessRec(process ? "R" : "P");
+      if (!process) {
+        reconciliation.setProcessed(false);
+        reconciliation.setDocumentStatus("DR");
+        reconciliation.setAPRMProcessReconciliation("P");
+        reconciliation.setAprmProcessRec("P");
+      }
       OBDal.getInstance().save(reconciliation);
       OBDal.getInstance().flush();
+      if (process) {
+        // Process Reconciliation
+        OBError myError = processReconciliation(this, "P", reconciliation);
+        if (myError != null && myError.getType().equalsIgnoreCase("error")) {
+          throw new OBException(myError.getMessage());
+        }
+      }
     } catch (Exception ex) {
       OBError menssage = Utility.translateError(this, vars, 
vars.getLanguage(), ex.getMessage());
       vars.setMessage(strTabId, menssage);
@@ -1267,6 +1277,19 @@
     return false;
   }
 
+  private OBError processReconciliation(ConnectionProvider conn, String 
strAction,
+      FIN_Reconciliation reconciliation) throws Exception {
+    ProcessBundle pb = new ProcessBundle("FF8080812E2F8EAE012E2F94CF470014", 
vars).init(conn);
+    HashMap<String, Object> parameters = new HashMap<String, Object>();
+    parameters.put("action", strAction);
+    parameters.put("FIN_Reconciliation_ID", reconciliation.getId());
+    pb.setParams(parameters);
+    OBError myMessage = null;
+    new FIN_ReconciliationProcess().execute(pb);
+    myMessage = (OBError) pb.getResult();
+    return myMessage;
+  }
+
   public String getServletInfo() {
     return "This servlet match imported bank statement lines for a financial 
account";
   }
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/algorithm/StandardMatchingAlgorithm.java
--- 
a/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/algorithm/StandardMatchingAlgorithm.java
    Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/algorithm/StandardMatchingAlgorithm.java
    Thu Apr 25 01:10:32 2013 +0200
@@ -19,6 +19,7 @@
 
 package org.openbravo.advpaymentmngt.algorithm;
 
+import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
 
@@ -41,7 +42,22 @@
     Date transactionDate = (algorithm.isMatchtransactiondate()) ? 
line.getTransactionDate() : null;
     String reference = (algorithm.isMatchreference()) ? line.getReferenceNo() 
: "";
 
-    List<FIN_FinaccTransaction> transactions;
+    List<FIN_FinaccTransaction> transactions = new 
ArrayList<FIN_FinaccTransaction>();
+    if (line.getGLItem() != null) {
+      transactions = 
MatchTransactionDao.getMatchingGLItemTransaction(line.getBankStatement()
+          .getAccount().getId(), line.getGLItem(), line.getTransactionDate(),
+          (line.getCramount().subtract(line.getDramount())), excluded);
+      if (transactions.isEmpty()) {
+        transactions = 
MatchTransactionDao.getMatchingGLItemTransaction(line.getBankStatement()
+            .getAccount().getId(), line.getGLItem(), null,
+            (line.getCramount().subtract(line.getDramount())), excluded);
+        if (!transactions.isEmpty()) {
+          return new FIN_MatchedTransaction(transactions.get(0), 
FIN_MatchedTransaction.WEAK);
+        }
+      } else {
+        return new FIN_MatchedTransaction(transactions.get(0), 
FIN_MatchedTransaction.STRONG);
+      }
+    }
     if (algorithm.isMatchbpname()) {
       transactions = 
MatchTransactionDao.getMatchingFinancialTransaction(line.getBankStatement()
           .getAccount().getId(), transactionDate, reference,
diff -r 191b774fbb86 -r 9fa1ecafd560 
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_PaymentProcess.java
--- 
a/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_PaymentProcess.java
     Mon Apr 22 19:17:06 2013 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_PaymentProcess.java
     Thu Apr 25 01:10:32 2013 +0200
@@ -604,7 +604,7 @@
           return;
         }
         // Reverse Payment
-        if (FIN_Utility.isReversePayment(payment)) {
+        if (strAction.equals("RE") && FIN_Utility.isReversePayment(payment)) {
           msg.setType("Error");
           msg.setTitle(Utility.messageBD(conProvider, "Error", language));
           msg.setMessage(Utility.parseTranslation(conProvider, vars, language,
@@ -793,6 +793,10 @@
                   && BigDecimal.ZERO.compareTo(psd.getWriteoffAmount()) == 0) {
                 paymentDetail.getFINPaymentScheduleDetailList().remove(psd);
                 OBDal.getInstance().getSession().refresh(paymentDetail);
+                psd.getInvoicePaymentSchedule()
+                    
.getFINPaymentScheduleDetailInvoicePaymentScheduleList().remove(psd);
+                
psd.getOrderPaymentSchedule().getFINPaymentScheduleDetailOrderPaymentScheduleList()
+                    .remove(psd);
                 OBDal.getInstance().remove(psd);

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to