details: http://code.openbravo.com/erp/devel/pi/rev/bae6b60e576b changeset: 3696:bae6b60e576b user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Fri Apr 24 19:13:19 2009 +0200 summary: Fixes bug 0008536: Manual accounting setup falis at the stage of Import Accounts
details: http://code.openbravo.com/erp/devel/pi/rev/6aeb33b7de0e changeset: 3697:6aeb33b7de0e user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Fri Apr 24 19:14:16 2009 +0200 summary: Fixes bug 0008169: Manual import of uploaded accounts chart file fails diffstat: src-db/database/model/functions/C_VALIDCOMBINATION_GET.xml | 2 +- src/org/openbravo/erpCommon/ad_process/ImportAccount_data.xsql | 6 +++--- 2 files changed, 4 insertions(+), 4 deletions(-) diffs (42 lines): diff --git a/src-db/database/model/functions/C_VALIDCOMBINATION_GET.xml b/src-db/database/model/functions/C_VALIDCOMBINATION_GET.xml --- a/src-db/database/model/functions/C_VALIDCOMBINATION_GET.xml +++ b/src-db/database/model/functions/C_VALIDCOMBINATION_GET.xml @@ -122,7 +122,7 @@ -- Existance Loop - Get first fully qualified matching combination -- FoundValue CHAR(1):='N'; - RetValue NUMBER:=NULL; + RetValue VARCHAR2(32):=NULL; fullyQualified CHAR(1) ; BEGIN -- 1a -- Fill with base info diff --git a/src/org/openbravo/erpCommon/ad_process/ImportAccount_data.xsql b/src/org/openbravo/erpCommon/ad_process/ImportAccount_data.xsql --- a/src/org/openbravo/erpCommon/ad_process/ImportAccount_data.xsql +++ b/src/org/openbravo/erpCommon/ad_process/ImportAccount_data.xsql @@ -414,7 +414,7 @@ UPDATED, UPDATEDBY, USESUSPENSEBALANCING, SUSPENSEBALANCING_ACCT, USESUSPENSEERROR, SUSPENSEERROR_ACCT, USECURRENCYBALANCING, CURRENCYBALANCING_ACCT, RETAINEDEARNING_ACCT,INCOMESUMMARY_ACCT, INTERCOMPANYDUETO_ACCT, INTERCOMPANYDUEFROM_ACCT,PPVOFFSET_ACCT, CFS_ORDER_ACCT) - VALUES (GET_UUID(), ?, ?, ?, 'Y', now(), ?, + VALUES (?, GET_UUID(), ?, ?, 'Y', now(), ?, now(), ?, 'N', ?, 'N', ?, 'N', ?, ?, ?, ?, ?, ?, ?) @@ -456,7 +456,7 @@ B_UNALLOCATEDCASH_ACCT, B_PAYMENTSELECT_ACCT, B_SETTLEMENTGAIN_ACCT, B_SETTLEMENTLOSS_ACCT, B_REVALUATIONGAIN_ACCT, B_REVALUATIONLOSS_ACCT, CH_EXPENSE_ACCT, CH_REVENUE_ACCT, UNEARNEDREVENUE_ACCT, NOTINVOICEDRECEIVABLES_ACCT, NOTINVOICEDREVENUE_ACCT, NOTINVOICEDRECEIPTS_ACCT, CB_ASSET_ACCT, CB_CASHTRANSFER_ACCT, CB_DIFFERENCES_ACCT,CB_EXPENSE_ACCT, CB_RECEIPT_ACCT, PROCESSING, - A_ACCUMDEPRECIATION_ACCT, A_DEPRECIATION_ACCT, A_DISPOSAL_GAIN,A_DISPOSAL_LOSS, C_ACCTSCHEMA_DEFAULT_ID, STATUS) + A_ACCUMDEPRECIATION_ACCT, A_DEPRECIATION_ACCT, A_DISPOSAL_GAIN,A_DISPOSAL_LOSS, C_ACCTSCHEMA_DEFAULT_ID) VALUES (?, ?, ?, 'Y',now() ,?,now() ,? , ? ,? ,? ,? , ? ,? ,? ,? ,? ,? , @@ -470,7 +470,7 @@ ? ,? ,? ,? ,? ,? , ? ,? ,? ,? ,? ,? , ? ,? ,? ,? ,? ,'N' , - ? ,? ,? ,? ,?, 'DE' ) + ? ,? ,? ,? ,?) ]]> </Sql> <Parameter name="cAcctschemaId"/> ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensign option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits