details: https://code.openbravo.com/erp/devel/pi/rev/00bc95491c65
changeset: 23084:00bc95491c65
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Wed May 21 18:00:26 2014 +0200
summary: Fixes bug 26493 Reactivate an old manual Reconciliation
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
| 17 ++++++++++
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
| 6 +-
2 files changed, 20 insertions(+), 3 deletions(-)
diffs (55 lines):
diff -r e3a5d2382b2d -r 00bc95491c65
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
Wed May 21 13:01:40 2014 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
Wed May 21 18:00:26 2014 +0200
@@ -11,6 +11,23 @@
<!--06A84BC3EC66453191652F4F3A6859C1-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
<!--06A84BC3EC66453191652F4F3A6859C1--></AD_AUXILIARINPUT>
+<!--1570DEA796EC4EE0A9AB562BC2E14C66--><AD_AUXILIARINPUT>
+<!--1570DEA796EC4EE0A9AB562BC2E14C66-->
<AD_AUXILIARINPUT_ID><![CDATA[1570DEA796EC4EE0A9AB562BC2E14C66]]></AD_AUXILIARINPUT_ID>
+<!--1570DEA796EC4EE0A9AB562BC2E14C66-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--1570DEA796EC4EE0A9AB562BC2E14C66--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--1570DEA796EC4EE0A9AB562BC2E14C66--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--1570DEA796EC4EE0A9AB562BC2E14C66-->
<AD_TAB_ID><![CDATA[FF8080813320657F0133209DE21B0042]]></AD_TAB_ID>
+<!--1570DEA796EC4EE0A9AB562BC2E14C66--> <NAME><![CDATA[ISMANUAL]]></NAME>
+<!--1570DEA796EC4EE0A9AB562BC2E14C66--> <CODE><![CDATA[@SQL=select case when
max(fin_reconciliation_id) is null then 'N' else 'Y' end
+from fin_reconciliation
+where fin_reconciliation_id = @FIN_RECONCILIATION_ID@
+and processed = 'Y'
+and not exists (select 1 from fin_finacc_transaction, fin_bankstatementline
+ where
fin_finacc_transaction.fin_reconciliation_id =
fin_reconciliation.fin_reconciliation_id
+ and
fin_finacc_transaction.fin_finacc_transaction_id =
fin_bankstatementline.fin_finacc_transaction_id)]]></CODE>
+<!--1570DEA796EC4EE0A9AB562BC2E14C66-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--1570DEA796EC4EE0A9AB562BC2E14C66--></AD_AUXILIARINPUT>
+
<!--21943DF0B89F4AE3AF14A9C06F1181C2--><AD_AUXILIARINPUT>
<!--21943DF0B89F4AE3AF14A9C06F1181C2-->
<AD_AUXILIARINPUT_ID><![CDATA[21943DF0B89F4AE3AF14A9C06F1181C2]]></AD_AUXILIARINPUT_ID>
<!--21943DF0B89F4AE3AF14A9C06F1181C2-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r e3a5d2382b2d -r 00bc95491c65
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
Wed May 21 13:01:40 2014 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
Wed May 21 18:00:26 2014 +0200
@@ -5244,13 +5244,13 @@
<!--5422F2DED3234598A429221281F8B61D-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
<!--5422F2DED3234598A429221281F8B61D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--5422F2DED3234598A429221281F8B61D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--5422F2DED3234598A429221281F8B61D--> <NAME><![CDATA[Reconcile]]></NAME>
-<!--5422F2DED3234598A429221281F8B61D--> <DESCRIPTION><![CDATA[Manages
processing of reconciliation documents]]></DESCRIPTION>
+<!--5422F2DED3234598A429221281F8B61D--> <NAME><![CDATA[Reconciliation Process
Force]]></NAME>
<!--5422F2DED3234598A429221281F8B61D-->
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
<!--5422F2DED3234598A429221281F8B61D-->
<AD_TAB_ID><![CDATA[FF8080813320657F0133209DE21B0042]]></AD_TAB_ID>
<!--5422F2DED3234598A429221281F8B61D-->
<AD_COLUMN_ID><![CDATA[F362B84F4718449EAD840F1C25667B37]]></AD_COLUMN_ID>
<!--5422F2DED3234598A429221281F8B61D-->
<IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
<!--5422F2DED3234598A429221281F8B61D-->
<ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--5422F2DED3234598A429221281F8B61D-->
<DISPLAYLOGIC><![CDATA[@Processed@='Y'&@APRM_LASTREC@!@FIN_Reconciliation_ID@&@ISMANUAL@!'Y']]></DISPLAYLOGIC>
<!--5422F2DED3234598A429221281F8B61D-->
<DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
<!--5422F2DED3234598A429221281F8B61D--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
<!--5422F2DED3234598A429221281F8B61D--> <SEQNO><![CDATA[170]]></SEQNO>
@@ -19475,7 +19475,7 @@
<!--F195EACFC9FD47C6BA15B51B6A10F25E-->
<AD_COLUMN_ID><![CDATA[422F3732DA324AE2AA34AE2E44D42037]]></AD_COLUMN_ID>
<!--F195EACFC9FD47C6BA15B51B6A10F25E-->
<IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
<!--F195EACFC9FD47C6BA15B51B6A10F25E-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--F195EACFC9FD47C6BA15B51B6A10F25E-->
<DISPLAYLOGIC><![CDATA[@Processed@='Y'&@APRM_LASTREC@!@FIN_Reconciliation_ID@]]></DISPLAYLOGIC>
+<!--F195EACFC9FD47C6BA15B51B6A10F25E-->
<DISPLAYLOGIC><![CDATA[@Processed@='Y'&@APRM_LASTREC@!@FIN_Reconciliation_ID@&@ISMANUAL@!'Y']]></DISPLAYLOGIC>
<!--F195EACFC9FD47C6BA15B51B6A10F25E-->
<DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
<!--F195EACFC9FD47C6BA15B51B6A10F25E--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
<!--F195EACFC9FD47C6BA15B51B6A10F25E--> <SEQNO><![CDATA[190]]></SEQNO>
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
