Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0008536 | Openbravo ERP | 02. Master data management | public | 2009-04-10 00:50 | 2009-05-05 00:00 |
| Reporter | stalker | ||||
| Assigned To | eduardo_Argal | ||||
| Priority | urgent | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 30 | OS Version | 2.6.27-11-generic | |
| Product Version | 2.50beta | ||||
| Target Version | Fixed in Version | 2.50MP1 | |||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0008536: Manual accounting setup falis at the stage of Import Accounts | ||||
| Description | postgresql log: 2009-04-10 02:24:56 MSD ERROR: column "status" of relation "c_acctschema_default" does not exist at character 1504 2009-04-10 02:24:56 MSD STATEMENT: INSERT INTO C_ACCTSCHEMA_DEFAULT (C_ACCTSCHEMA_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, W_INVENTORY_ACCT, W_INVACTUALADJUST_ACCT, W_DIFFERENCES_ACCT, W_REVALUATION_ACCT, P_REVENUE_ACCT, P_EXPENSE_ACCT, P_ASSET_ACCT,P_PURCHASEPRICEVARIANCE_ACCT, P_INVOICEPRICEVARIANCE_ACCT, P_TRADEDISCOUNTREC_ACCT, P_TRADEDISCOUNTGRANT_ACCT, P_COGS_ACCT, C_RECEIVABLE_ACCT,C_PREPAYMENT_ACCT, V_LIABILITY_ACCT, V_LIABILITY_SERVICES_ACCT, V_PREPAYMENT_ACCT, PAYDISCOUNT_EXP_ACCT, WRITEOFF_ACCT , PAYDISCOUNT_REV_ACCT, UNREALIZEDGAIN_ACCT, UNREALIZEDLOSS_ACCT, REALIZEDGAIN_ACCT, REALIZEDLOSS_ACCT, WITHHOLDING_ACCT, E_PREPAYMENT_ACCT , E_EXPENSE_ACCT, PJ_ASSET_ACCT, PJ_WIP_ACCT, T_EXPENSE_ACCT, T_LIABILITY_ACCT, T_RECEIVABLES_ACCT, T_DUE_ACCT, T_CREDIT_ACCT, B_INTRANSIT_ACCT, B_ASSET_ACCT, B_EXPENSE_ACCT,B_INTERESTREV_ACCT, B_INTERESTEXP_ACCT, B_UNIDENTIFIED_ACCT, 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) VALUES ($1, $2, $3, 'Y',now() ,$4,now() ,$5 , $6 ,$7 ,$8 ,$9 , $10 ,$11 ,$12 ,$13 ,$14 ,$15 , $16 ,$17 ,$18 ,$19 ,$20 ,$21 , $22 ,$23 ,$24 , $25 ,$26 ,$27 , $28 ,$29 ,$30 ,$31 , $32 ,$33 , $34 ,$35 ,$36 ,$37 ,$38 ,$39 , $40 ,$41 ,$42 ,$43 ,$44 , $45, $46 ,$47 ,$48 ,$49 ,$50 ,$51 , $52 ,$53 ,$54 ,$55 ,$56 ,$57 , $58 ,$59 ,$60 ,$61 ,$62 ,'N' , $63 ,$64 ,$65 ,$66 ,$67, 'DE' ) | ||||
| Steps To Reproduce | 1. load correct accounts file 2. from Import Account form run "Import Accounts" process | ||||
| Proposed Solution | root@LinSrv:/opt/250beta/src/org/openbravo/erpCommon/ad_process# diff ImportAccount_data.xsql ImportAccount_data.xsql.orig 459c459 < A_ACCUMDEPRECIATION_ACCT, A_DEPRECIATION_ACCT, A_DISPOSAL_GAIN,A_DISPOSAL_LOSS, C_ACCTSCHEMA_DEFAULT_ID) --- > A_ACCUMDEPRECIATION_ACCT, A_DEPRECIATION_ACCT, A_DISPOSAL_GAIN,A_DISPOSAL_LOSS, C_ACCTSCHEMA_DEFAULT_ID, STATUS) 473c473 < ? ,? ,? ,? ,?) --- > ? ,? ,? ,? ,?, 'DE' ) ... or .... alter table c_acctschema_default and add due column, if some functionality has been supposed. | ||||
| Additional Information | |||||
| Tags | 250MP1 | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2009-04-10 00:50 | stalker | New Issue | |||
| 2009-04-10 00:50 | stalker | Assigned To | => rafaroda | ||
| 2009-04-22 19:09 | psarobe | Status | new => scheduled | ||
| 2009-04-22 19:09 | psarobe | Note Added: 0015577 | |||
| 2009-04-22 19:09 | psarobe | Assigned To | rafaroda => eduardo_Argal | ||
| 2009-04-22 19:09 | psarobe | fix_in_branch | => pi | ||
| 2009-04-22 19:10 | psarobe | Priority | normal => urgent | ||
| 2009-04-22 19:10 | psarobe | Severity | minor => major | ||
| 2009-04-22 19:10 | psarobe | fix_in_branch | pi => | ||
| 2009-04-23 16:04 | psarobe | Tag Attached: 250MP1 | |||
| 2009-04-24 19:15 | hgbot | Checkin | |||
| 2009-04-24 19:15 | hgbot | Note Added: 0015724 | |||
| 2009-04-24 19:15 | hgbot | Status | scheduled => resolved | ||
| 2009-04-24 19:15 | hgbot | Resolution | open => fixed | ||
| 2009-04-24 19:15 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/bae6b60e576b95dd17b2eaadee459ba287d9dfd5 [^] | ||
| 2009-05-04 19:10 | psarobe | Regression testing | => No | ||
| 2009-05-04 19:10 | psarobe | Status | resolved => closed | ||
| 2009-05-05 00:00 | anonymous | sf_bug_id | 0 => 2786896 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||