Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0007442 | Openbravo ERP | 02. Master data management | public | 2009-02-09 18:09 | 2009-04-21 10:54 |
| Reporter | mirurita | ||||
| Assigned To | AinhoaPagola | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 20 | OS Version | rPath Linux | |
| Product Version | pi | ||||
| Target Version | Fixed in Version | 2.50beta | |||
| 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 | 0007442: Import Orders process fails selecting paymentrule | ||||
| Description | When paymentrule1 field of I_Order table is specified Import Order process fails. Import Order error: javax.servlet.ServletException: @CODE=0@ERROR: column "amount" is of type numeric but expression is of type character varying LOG 16:37:01 [http-8080-2] ERROR org.openbravo.erpCommon.ad_process.CDebtpaymentData - SQL error in query: INSERT INTO C_DEBT_PAYMENT (C_DEBT_PAYMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_BPARTNER_ID, C_CURRENCY_ID, PAYMENTRULE, ISPAID, AMOUNT, DATEPLANNED, ISMANUAL, ISVALID, CHANGESETTLEMENTCANCEL, CANCEL_PROCESSED, GENERATE_PROCESSED, GLITEMAMT, ISDIRECTPOSTING, STATUS, STATUS_INITIAL, C_ORDER_ID) VALUES ( ?, ?, ?, 'Y', TO_DATE(now()), ?, TO_DATE(now()), ?, ?, ?, ?, ?, ?, TO_DATE(?), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)Exception:org.postgresql.util.PSQLException: ERROR: column "amount" is of type numeric but expression is of type character varying | ||||
| Steps To Reproduce | Follow this test case: http://wiki.openbravo.com/wiki/QA_test_plan_2.50/Test_cases [^] with one modification: - create one record more: Name: Paymentrule1 Column: PaymentRule1 Data type: constant Constant value: B Then, go to Master Data Management -> Import Data -> Import Orders Fill Price List field and press Import Orders button | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | commsup_sprint6 | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2009-02-09 18:09 | mirurita | New Issue | |||
| 2009-02-09 18:09 | mirurita | Assigned To | => rafaroda | ||
| 2009-02-09 18:09 | mirurita | sf_bug_id | 0 => 2582133 | ||
| 2009-02-09 18:09 | mirurita | Issue Monitored: mirurita | |||
| 2009-02-09 18:09 | mirurita | Issue End Monitor: mirurita | |||
| 2009-02-09 18:11 | AinhoaPagola | Assigned To | rafaroda => AinhoaPagola | ||
| 2009-02-11 11:33 | AinhoaPagola | Status | new => scheduled | ||
| 2009-02-11 11:33 | AinhoaPagola | fix_in_branch | => trunk | ||
| 2009-02-12 12:26 | svnbot | Checkin | |||
| 2009-02-12 12:26 | svnbot | Note Added: 0013402 | |||
| 2009-02-12 12:26 | svnbot | Status | scheduled => resolved | ||
| 2009-02-12 12:26 | svnbot | Resolution | open => fixed | ||
| 2009-02-12 12:26 | svnbot | svn_revision | => 13088 | ||
| 2009-02-13 10:43 | AinhoaPagola | Tag Attached: commsup_sprint6 | |||
| 2009-04-21 10:54 | psarobe | Status | resolved => closed | ||
| Notes | |||||
|
|
|||||
|
|
||||