details: https://code.openbravo.com/erp/devel/pi/rev/251ea8a24d39 changeset: 31541:251ea8a24d39 user: Nono Carballo <nonofce <at> gmail.com> date: Thu Dec 08 11:33:43 2016 -0500 summary: Fixed issue 35089: Merged Aging Balance Report into Core
The following actions has been made - Dependencies to 2.5 were removed. - Reports in PDF and XLS format were taken from the module and left unchanged. - Reports in HTML format were modified to allow navigation between reports and export to PDF and XLS format. - Functions AGING_GETDOCNO, AGING_INVOICECURRENCY_RATE, AGING_ISDOUBTFULTDEBT and AGING_PAYMENTCURRENCY_RATE were renamed to FIN_AGING_GETDOCNO, FIN_AGING_INVOICECURRENCY_RATE, FIN_AGING_ISDOUBTFULTDEBT and FIN_AGING_PAYMENTCURRENCY_RATE, and updated the file AgingDao_data.xsql, where were calles. - An index on column FIN_PAYMENT_SCHEDULE_ID was added to table FIN_DOUBTFUL_DEBT - Two new Process Definitions were added, one for Payables Aging Schedule Report and other for Receivables Aging Schedule Report; defined parameters, default values and validation rules for each one. - Two new menu entries were created to invoke the Process Definition. - A new action handler was created (AgingBalanceReportActionHandler), extending BaseReportActionHandler, holding the logic to process both reports. details: https://code.openbravo.com/erp/devel/pi/rev/4d65a65d7a6b changeset: 31542:4d65a65d7a6b user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Tue Jan 31 10:17:23 2017 +0100 summary: Related to issue 35089: code review improvements Simplified exception management. Fixed execution of PDF and XLS in details view. Transform index to partial index for not null values. Fixed DB consistency. Renamed Day One/Two/... by Group One/Two/... Use AMOUNTFORMAT instead of NUMBERFORMAT. Removed useless parameters. Retrieved @basedesign@ from ReportingUtils. details: https://code.openbravo.com/erp/devel/pi/rev/5db62ca1cb14 changeset: 31543:5db62ca1cb14 user: Rafael Queralta Pozo <rqueralta <at> nauta.cu> date: Wed Dec 21 14:06:05 2016 -0500 summary: Fixed issue 35130: Merged Cashflow Forecast Report into Core details: https://code.openbravo.com/erp/devel/pi/rev/9c6dcce3bb77 changeset: 31544:9c6dcce3bb77 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Wed Feb 01 18:01:07 2017 +0100 summary: Related to issue 35130: code review improvements Fixed db consistency. Reused core's messages instead of creating new ones. Deleted 2 jrxml files that are not needed. Properly set menu entry for new report. Fixed issue that hid the first record in HTML/PDF view (not XLS). Usage of AMOUNTFORMAT and patternExpression based on it. Removed useless SQL queries in JRXML files. Make Strings in reports translatable. Several jasper UI improvements: padding, link behavior, borders... details: https://code.openbravo.com/erp/devel/pi/rev/7a0acfb78923 changeset: 31545:7a0acfb78923 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Thu Feb 02 09:50:40 2017 +0100 summary: Related to issue 35089: code review improvements Fixed amounts format in XLS views details: https://code.openbravo.com/erp/devel/pi/rev/f929731149b4 changeset: 31546:f929731149b4 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Thu Feb 02 17:21:08 2017 +0100 summary: Related to issue 35089 and related to issue 35130: Declare merge for modules: * Aging Balance Report * Cashflow Forecast Report Added buildvalidation to check: 1. Both merged modules are not inside modules folder 2. There are no modules in the instance that depend on any of the merged modules details: https://code.openbravo.com/erp/devel/pi/rev/4c7b6e37ceb2 changeset: 31547:4c7b6e37ceb2 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Thu Feb 02 17:40:19 2017 +0100 summary: Related to issue 35089 and related to issue 35130: Added missed subclasses .class files details: https://code.openbravo.com/erp/devel/pi/rev/256a41b3f7dd changeset: 31548:256a41b3f7dd user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Fri Feb 03 11:34:17 2017 +0100 summary: Related to issue 35089 and related to issue 35130: Build Validation shows a warning when Multi Business Partner Selector module is detected as orphan details: https://code.openbravo.com/erp/devel/pi/rev/f48e0974234f changeset: 31549:f48e0974234f user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Mon Feb 06 12:51:50 2017 +0100 summary: Related to issue 35089 and related to issue 35130: Added net.sf.jasperreports.export.xls.detect.cell.type property to properly export numbers in Excel details: https://code.openbravo.com/erp/devel/pi/rev/82e00b639914 changeset: 31550:82e00b639914 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Tue Feb 07 13:54:23 2017 +0100 summary: Related to issue 35089 and related to issue 35130: Fixed db consistency after merge details: https://code.openbravo.com/erp/devel/pi/rev/9610f6267285 changeset: 31551:9610f6267285 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Tue Feb 07 13:56:33 2017 +0100 summary: Related to issue 35089 and related to issue 35130: Updated execution limits details: https://code.openbravo.com/erp/devel/pi/rev/078a7874e6d0 changeset: 31552:078a7874e6d0 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Thu Feb 23 11:32:02 2017 +0100 summary: Fixed issue 35089 and fixed issue 35130: Updated execution limits diffstat: modules/org.openbravo.client.application/web/org.openbravo.client.application/js/utilities/ob-onchange-functions.js | 16 + modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE_MERGE.xml | 20 + src-db/database/model/functions/C_CONVERT_DOC_CURRENCY.xml | 82 + src-db/database/model/functions/FIN_AGING_GETDOCNO.xml | 52 + src-db/database/model/functions/FIN_AGING_INVOICECURRENCY_RATE.xml | 70 + src-db/database/model/functions/FIN_AGING_ISDOUBTFULTDEBT.xml | 53 + src-db/database/model/functions/FIN_AGING_PAYMENTCURRENCY_RATE.xml | 70 + src-db/database/model/tables/FIN_DOUBTFUL_DEBT.xml | 4 + src-db/database/sourcedata/AD_ELEMENT.xml | 276 ++ src-db/database/sourcedata/AD_MENU.xml | 42 + src-db/database/sourcedata/AD_MESSAGE.xml | 60 + src-db/database/sourcedata/AD_REFERENCE.xml | 12 + src-db/database/sourcedata/AD_REF_LIST.xml | 11 + src-db/database/sourcedata/AD_TEXTINTERFACES.xml | 1221 ++++++++++ src-db/database/sourcedata/AD_TREENODE.xml | 53 +- src-db/database/sourcedata/OBUIAPP_PARAMETER.xml | 662 +++++ src-db/database/sourcedata/OBUIAPP_PROCESS.xml | 56 + src-db/database/sourcedata/OBUIAPP_REPORT.xml | 41 + src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 15 + src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml | 44 + src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck$1.class | 0 src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck$MergedModule.class | 0 src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck.class | 0 src-util/buildvalidation/src/org/openbravo/buildvalidation/MergeDependenciesCheck.java | 275 ++ src/org/openbravo/common/actionhandler/AgingBalanceReportActionHandler.java | 495 ++++ src/org/openbravo/common/actionhandler/CashflowForecastReportActionHandler.java | 197 + src/org/openbravo/common/actionhandler/CashflowForecast_data.xsql | 182 + src/org/openbravo/erpCommon/ad_reports/AgingDao.java | 405 +++ src/org/openbravo/erpCommon/ad_reports/AgingDao_data.xsql | 234 + src/org/openbravo/erpCommon/ad_reports/AgingData.java | 232 + src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailHTML.jrxml | 1089 ++++++++ src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailPDF.jrxml | 785 ++++++ src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailPDFDoubtfulDebt.jrxml | 913 +++++++ src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml | 568 ++++ src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml | 621 +++++ src/org/openbravo/erpCommon/ad_reports/AgingScheduleHTML.jrxml | 935 +++++++ src/org/openbravo/erpCommon/ad_reports/AgingSchedulePDF.jrxml | 770 ++++++ src/org/openbravo/erpCommon/ad_reports/AgingSchedulePDFDoubtfulDebt.jrxml | 862 +++++++ src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml | 758 ++++++ src/org/openbravo/erpCommon/ad_reports/CashflowForecast.jrxml | 228 + src/org/openbravo/erpCommon/ad_reports/CashflowForecastExcel.jrxml | 363 ++ src/org/openbravo/erpCommon/ad_reports/CashflowForecastLines.jrxml | 464 +++ src/org/openbravo/erpCommon/ad_reports/CashflowForecastLinesByDate.jrxml | 490 ++++ src/org/openbravo/erpCommon/ad_reports/CashflowForecastSummary.jrxml | 154 + 44 files changed, 13870 insertions(+), 10 deletions(-) diffs (truncated from 15190 to 300 lines): diff -r e6fef7749bc4 -r 078a7874e6d0 modules/org.openbravo.client.application/web/org.openbravo.client.application/js/utilities/ob-onchange-functions.js --- a/modules/org.openbravo.client.application/web/org.openbravo.client.application/js/utilities/ob-onchange-functions.js Tue Feb 21 16:04:04 2017 -0500 +++ b/modules/org.openbravo.client.application/web/org.openbravo.client.application/js/utilities/ob-onchange-functions.js Thu Feb 23 11:32:02 2017 +0100 @@ -40,4 +40,20 @@ if (item.getValue() === 'OBUIAPP_Report' && !classNameItem.getValue()) { classNameItem.setValue('org.openbravo.client.application.report.BaseReportActionHandler'); } +}; + +//** {{{OB.OnChange.agingProcessDefinitionOverdue}}}** +//Used by the parameters Overdue Days in Payable and Receivables Aging Balance Process Definition Reports. +//A warning message is shown if the range of overdue days is not correct. +OB.OnChange.agingProcessDefinitionOverdue = function (item, view, form, grid) { + var column1 = form.getItem('Column1').getValue(); + var column2 = form.getItem('Column2').getValue(); + var column3 = form.getItem('Column3').getValue(); + var column4 = form.getItem('Column4').getValue(); + if (column1 && column2 && column3 && column4 && !((column1 < column2 && column2 < column3 && column3 < column4))) { + item.setValue(''); + view.messageBar.setMessage(isc.OBMessageBar.TYPE_WARNING, null, OB.I18N.getLabel('OBUIAPP_OverdueNotValid')); + } else { + view.messageBar.hide(); + } }; \ No newline at end of file diff -r e6fef7749bc4 -r 078a7874e6d0 modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE_MERGE.xml --- a/modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE_MERGE.xml Tue Feb 21 16:04:04 2017 -0500 +++ b/modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE_MERGE.xml Thu Feb 23 11:32:02 2017 +0100 @@ -10,6 +10,26 @@ <!--10FBB7E64CFC495EB32B3C6F17D10197--> <MERGED_MODULE_NAME><![CDATA[Inventory Average Cost transactions]]></MERGED_MODULE_NAME> <!--10FBB7E64CFC495EB32B3C6F17D10197--></AD_MODULE_MERGE> +<!--12D2973485914E9AB38702464C531896--><AD_MODULE_MERGE> +<!--12D2973485914E9AB38702464C531896--> <AD_MODULE_MERGE_ID><![CDATA[12D2973485914E9AB38702464C531896]]></AD_MODULE_MERGE_ID> +<!--12D2973485914E9AB38702464C531896--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--12D2973485914E9AB38702464C531896--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--12D2973485914E9AB38702464C531896--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--12D2973485914E9AB38702464C531896--> <AD_MODULE_ID><![CDATA[0138E7A89B5E4DC3932462252801FFBC]]></AD_MODULE_ID> +<!--12D2973485914E9AB38702464C531896--> <MERGED_MODULE_UUID><![CDATA[391979C3E1A44A9D814B3F9756FC57F4]]></MERGED_MODULE_UUID> +<!--12D2973485914E9AB38702464C531896--> <MERGED_MODULE_NAME><![CDATA[Aging Balance Report]]></MERGED_MODULE_NAME> +<!--12D2973485914E9AB38702464C531896--></AD_MODULE_MERGE> + +<!--766B82ABD28C42E999EF034F80F73992--><AD_MODULE_MERGE> +<!--766B82ABD28C42E999EF034F80F73992--> <AD_MODULE_MERGE_ID><![CDATA[766B82ABD28C42E999EF034F80F73992]]></AD_MODULE_MERGE_ID> +<!--766B82ABD28C42E999EF034F80F73992--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--766B82ABD28C42E999EF034F80F73992--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--766B82ABD28C42E999EF034F80F73992--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--766B82ABD28C42E999EF034F80F73992--> <AD_MODULE_ID><![CDATA[0138E7A89B5E4DC3932462252801FFBC]]></AD_MODULE_ID> +<!--766B82ABD28C42E999EF034F80F73992--> <MERGED_MODULE_UUID><![CDATA[FF80808131D1689F0131D170F19A0006]]></MERGED_MODULE_UUID> +<!--766B82ABD28C42E999EF034F80F73992--> <MERGED_MODULE_NAME><![CDATA[Report: Cash Flow Forecast]]></MERGED_MODULE_NAME> +<!--766B82ABD28C42E999EF034F80F73992--></AD_MODULE_MERGE> + <!--9AF40DD3765F4F048F3C9764C3A82796--><AD_MODULE_MERGE> <!--9AF40DD3765F4F048F3C9764C3A82796--> <AD_MODULE_MERGE_ID><![CDATA[9AF40DD3765F4F048F3C9764C3A82796]]></AD_MODULE_MERGE_ID> <!--9AF40DD3765F4F048F3C9764C3A82796--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r e6fef7749bc4 -r 078a7874e6d0 src-db/database/model/functions/C_CONVERT_DOC_CURRENCY.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src-db/database/model/functions/C_CONVERT_DOC_CURRENCY.xml Thu Feb 23 11:32:02 2017 +0100 @@ -0,0 +1,82 @@ +<?xml version="1.0"?> + <database name="FUNCTION C_CONVERT_DOC_CURRENCY"> + <function name="C_CONVERT_DOC_CURRENCY" type="NUMERIC"> + <parameter name="p_amount" type="NUMERIC" mode="in"> + <default/> + </parameter> + <parameter name="p_curfrom_id" type="VARCHAR" mode="in"> + <default/> + </parameter> + <parameter name="p_curto_id" type="VARCHAR" mode="in"> + <default/> + </parameter> + <parameter name="p_convdate" type="TIMESTAMP" mode="in"> + <default/> + </parameter> + <parameter name="p_c_invoice_id" type="VARCHAR" mode="in"> + <default/> + </parameter> + <parameter name="p_fin_payment_id" type="VARCHAR" mode="in"> + <default/> + </parameter> + <parameter name="p_fin_finacc_transaction_id" type="VARCHAR" mode="in"> + <default/> + </parameter> + <parameter name="p_client_id" type="VARCHAR" mode="in"> + <default><![CDATA[0]]></default> + </parameter> + <parameter name="p_org_id" type="VARCHAR" mode="in"> + <default><![CDATA[0]]></default> + </parameter> + <body><![CDATA[/************************************************************************* +* The contents of this file are subject to the Openbravo Public License +* Version 1.1 (the "License"), being the Mozilla Public License +* Version 1.1 with a permitted attribution clause; you may not use this +* file except in compliance with the License. You may obtain a copy of +* the License at http://www.openbravo.com/legal/license.html +* Software distributed under the License is distributed on an "AS IS" +* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the +* License for the specific language governing rights and limitations +* under the License. +* The Original Code is Openbravo ERP. +* The Initial Developer of the Original Code is Openbravo SLU +* All portions are Copyright (C) 2011 Openbravo SLU +* All Rights Reserved. +* Contributor(s): ______________________________________. +************************************************************************/ + v_Rate NUMBER; + v_ConvDate DATE; +BEGIN + + IF(p_Amount=0 OR p_CurFrom_ID=p_CurTo_ID) THEN + RETURN p_Amount; + END IF; + + if (p_convdate > now()) then + v_ConvDate:=now(); + else + v_ConvDate:=p_convdate; + end if; + + if (p_fin_finacc_transaction_id is not null) then + select foreign_convert_rate into v_rate from fin_finacc_transaction fat where fin_finacc_transaction_id=p_fin_finacc_transaction_id; + elsif (p_fin_payment_id is not null) then + select finacc_txn_convert_rate into v_rate from fin_payment where fin_payment_id=p_fin_payment_id; + elsif (p_c_invoice_id is not null) then + select rate into v_Rate from c_conversion_rate_document where c_invoice_id=p_c_invoice_id and c_currency_id=p_curfrom_id and c_currency_id_to=p_curto_id; + end if; + + if (v_Rate is not null) then + return ROUND(p_Amount * v_Rate, C_GET_CURRENCY_PRECISION(p_CurTo_ID, 'A')); + else + RETURN C_CURRENCY_CONVERT(p_amount, p_curfrom_id, p_curto_id, p_convdate, null, p_client_id, p_org_id); + end if; + +EXCEPTION +WHEN OTHERS THEN + DBMS_OUTPUT.PUT_LINE(SQLERRM); + RAISE; +END C_CONVERT_DOC_CURRENCY +]]></body> + </function> + </database> diff -r e6fef7749bc4 -r 078a7874e6d0 src-db/database/model/functions/FIN_AGING_GETDOCNO.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src-db/database/model/functions/FIN_AGING_GETDOCNO.xml Thu Feb 23 11:32:02 2017 +0100 @@ -0,0 +1,52 @@ +<?xml version="1.0"?> + <database name="FUNCTION FIN_AGING_GETDOCNO"> + <function name="FIN_AGING_GETDOCNO" type="NVARCHAR"> + <parameter name="p_poreference" type="NVARCHAR" mode="in"> + <default/> + </parameter> + <parameter name="p_documentno" type="NVARCHAR" mode="in"> + <default/> + </parameter> + <parameter name="p_adorgid" type="VARCHAR" mode="in"> + <default/> + </parameter> + <body><![CDATA[/************************************************************************* +* The contents of this file are subject to the Openbravo Public License +* Version 1.1 (the "License"), being the Mozilla Public License +* Version 1.1 with a permitted attribution clause; you may not use this +* file except in compliance with the License. You may obtain a copy of +* the License at http://www.openbravo.com/legal/license.html +* Software distributed under the License is distributed on an "AS IS" +* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the +* License for the specific language governing rights and limitations +* under the License. +* The Original Code is Openbravo ERP. +* The Initial Developer of the Original Code is Openbravo SLU +* All portions are Copyright (C) 2016 Openbravo SLU +* All Rights Reserved. +* Contributor(s): ______________________________________. +************************************************************************/ + +v_hasSupplierRef NUMBER:= 0; + +BEGIN + + SELECT count(*) + INTO v_hasSupplierRef + FROM AD_ORGINFO oi + WHERE oi.ad_org_id = p_adorgid + AND oi.em_aprm_payment_desc = 'Supplier Reference'; + + IF (v_hasSupplierRef = 0) THEN + RETURN p_documentno; + ELSE + RETURN p_poreference; + END IF; + +EXCEPTION +WHEN OTHERS THEN + RETURN p_documentno; +END FIN_AGING_GETDOCNO +]]></body> + </function> + </database> diff -r e6fef7749bc4 -r 078a7874e6d0 src-db/database/model/functions/FIN_AGING_INVOICECURRENCY_RATE.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src-db/database/model/functions/FIN_AGING_INVOICECURRENCY_RATE.xml Thu Feb 23 11:32:02 2017 +0100 @@ -0,0 +1,70 @@ +<?xml version="1.0"?> + <database name="FUNCTION FIN_AGING_INVOICECURRENCY_RATE"> + <function name="FIN_AGING_INVOICECURRENCY_RATE" type="NUMERIC"> + <parameter name="p_invoice_id" type="VARCHAR" mode="in"> + <default/> + </parameter> + <parameter name="p_curto_id" type="VARCHAR" mode="in"> + <default/> + </parameter> + <parameter name="p_curfrom_id" type="VARCHAR" mode="in"> + <default/> + </parameter> + <body><![CDATA[/************************************************************************* +* The contents of this file are subject to the Openbravo Public License +* Version 1.1 (the "License"), being the Mozilla Public License +* Version 1.1 with a permitted attribution clause; you may not use this +* file except in compliance with the License. You may obtain a copy of +* the License at http://www.openbravo.com/legal/license.html +* Software distributed under the License is distributed on an "AS IS" +* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the +* License for the specific language governing rights and limitations +* under the License. +* The Original Code is Openbravo ERP. +* The Initial Developer of the Original Code is Openbravo SLU +* All portions are Copyright (C) 2016 Openbravo SLU +* All Rights Reserved. +* Contributor(s): ______________________________________. +************************************************************************/ + +v_count NUMBER:=0; +v_rate NUMBER:=1; +v_client_id c_invoice.ad_client_id%TYPE; +v_org_id c_invoice.ad_org_id%TYPE; +v_dateacct c_invoice.dateacct%TYPE; + +BEGIN + +IF(p_curfrom_id <> p_curto_id) THEN + SELECT count(*) + INTO v_count + FROM c_conversion_rate_document + WHERE c_invoice_id = p_invoice_id + and c_currency_id = p_curfrom_id + and c_currency_id_to = p_curto_id; + + IF(v_count = 1) THEN + SELECT rate + INTO v_rate + FROM c_conversion_rate_document + WHERE c_invoice_id = p_invoice_id + and c_currency_id = p_curfrom_id + and c_currency_id_to = p_curto_id; + ELSE + SELECT dateacct, ad_client_id, ad_org_id + into v_dateacct, v_client_id, v_org_id + from c_invoice + where c_invoice_id = p_invoice_id; + v_rate:=c_currency_rate(p_curfrom_id, p_curto_id, v_dateacct, 'S', v_client_id, v_org_id); + END IF; +END IF; + +RETURN v_rate; + +EXCEPTION +WHEN OTHERS THEN + RETURN NULL; +END FIN_AGING_INVOICECURRENCY_RATE +]]></body> + </function> + </database> diff -r e6fef7749bc4 -r 078a7874e6d0 src-db/database/model/functions/FIN_AGING_ISDOUBTFULTDEBT.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src-db/database/model/functions/FIN_AGING_ISDOUBTFULTDEBT.xml Thu Feb 23 11:32:02 2017 +0100 @@ -0,0 +1,53 @@ +<?xml version="1.0"?> + <database name="FUNCTION FIN_AGING_ISDOUBTFULTDEBT"> + <function name="FIN_AGING_ISDOUBTFULTDEBT" type="CHAR"> + <parameter name="p_finpaymentschedule_id" type="VARCHAR" mode="in"> + <default/> + </parameter> + <parameter name="p_currentdate" type="TIMESTAMP" mode="in"> + <default/> + </parameter> + <body><