Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012858 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 03. Procurement management | critical | have not tried | 2010-04-01 09:01 | 2010-05-18 12:12 | |||
| Reporter | arunkumar | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 3e7d26d481a3 | ||||
| Projection | none | ETA | none | Target Version | 2.50MP17 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0012858: Unable to complete purchase/sales order and purcahse/sales invoice | |||||||
| Description | Create a complete purchase order. Also Create & complete purchase invoice. You will see an error message "This record cannot be deleted because it is associated with other existing elements. Please see Linked Items" | |||||||
| Steps To Reproduce | Purchase order: Login as Openbravo/openbravo with "Openbravo Admin" role. Go to procurement management -> Transactions -> Purchase order -> Header. Create a new record and select the business partner Mcgiver supplies. In lines create a new record.Enter the product "Hat" and ordered quantity as 10. Go back to header and complete. You will see an error message "This record cannot be deleted because it is associated with other existing elements. Please see Linked Items" Purchase Invoice: Login as Openbravo/openbravo with "Openbravo Admin" role. Go to procurement management -> Transactions -> Purchase Invoice-> Header. Create a new record and select the business partner Mcgiver supplies. In lines create a new record.Enter the product "Hat" and invoiced quantity as 10. Go back to header and complete. You will see an error message "This record cannot be deleted because it is associated with other existing elements. Please see Linked Items" | |||||||
| Tags | Regression QA | |||||||
| Attached Files |  purchaseorder.JPG [^] (153,797 bytes) 2010-04-01 09:01
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0025867) psarobe (viewer) 2010-04-02 11:40 |
The same happens in Sales order and sales invoice |
|
(0025885) dalsasua (viewer) 2010-04-06 09:31 |
This is the error returned from database when executing the 'C_Order Post' process in a fresh installation, in revision e9504e6a07ae: @ERROR=ORA-02291: restricción de integridad (TAD_PI.FIN_PAYMENTMETHOD_PAYMENT_SCH) violada - clave principal no encontrada |
|
(0025891) adrianromero (viewer) 2010-04-06 12:36 |
From Hari investigations: The issue rises in the FIN_GEN_PAYMENTSCHEDULE_INV.xml prodcedure.This occurs in Insert statement of this procedure. Lines Numbers: 1)https://code.openbravo.com/erp/devel/pi/file/e9504e6a07ae/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml#l170 [^] In this line In this column "fin_paymentmethod_id" foreign key inserting value is "to-do" 2)https://code.openbravo.com/erp/devel/pi/file/e9504e6a07ae/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml#l241 [^] In this the foreign key constraints are inserting null |
|
(0025916) hgbot (developer) 2010-04-07 01:22 |
Repository: erp/devel/pi Changeset: 3e7d26d481a36e9e2b29e01c39ae3ce74f066e9f Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Wed Apr 07 01:33:48 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/3e7d26d481a36e9e2b29e01c39ae3ce74f066e9f [^] Fixes bug 0012858: Unable to complete purchase/sales order and purcahse/sales invoice --- M src-db/database/sourcedata/AD_EP_PROCEDURES.xml --- |
|
(0026148) psarobe (viewer) 2010-04-13 17:30 |
Tested, working fine |
|
(0026421) hudsonbot (viewer) 2010-04-19 21:12 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/3e7d26d481a3 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-04-01 09:01 | arunkumar | New Issue | |
| 2010-04-01 09:01 | arunkumar | Assigned To | => adrianromero |
| 2010-04-01 09:01 | arunkumar | File Added: purchaseorder.JPG | |
| 2010-04-01 09:01 | arunkumar | OBNetwork customer | => No |
| 2010-04-01 09:01 | arunkumar | Status | new => scheduled |
| 2010-04-01 09:01 | arunkumar | fix_in_branch | => pi |
| 2010-04-02 11:40 | psarobe | Note Added: 0025867 | |
| 2010-04-02 11:40 | psarobe | Target Version | => 2.50MP15 |
| 2010-04-02 11:40 | psarobe | fix_in_branch | pi => |
| 2010-04-02 11:40 | psarobe | Summary | Unable to complete purchase order and purcahse invoice => Unable to complete purchase/sales order and purcahse/sales invoice |
| 2010-04-02 11:40 | psarobe | Steps to Reproduce Updated | View Revisions |
| 2010-04-03 01:40 | eintelau | Issue Monitored: eintelau | |
| 2010-04-06 09:31 | dalsasua | Note Added: 0025885 | |
| 2010-04-06 11:36 | plujan | Assigned To | adrianromero => eduardo_Argal |
| 2010-04-06 12:36 | adrianromero | Note Added: 0025891 | |
| 2010-04-06 12:56 | psarobe | Tag Attached: Regression QA | |
| 2010-04-07 01:22 | hgbot | Checkin | |
| 2010-04-07 01:22 | hgbot | Note Added: 0025916 | |
| 2010-04-07 01:22 | hgbot | Status | scheduled => resolved |
| 2010-04-07 01:22 | hgbot | Resolution | open => fixed |
| 2010-04-07 01:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/3e7d26d481a36e9e2b29e01c39ae3ce74f066e9f [^] |
| 2010-04-13 17:30 | psarobe | Note Added: 0026148 | |
| 2010-04-13 17:30 | psarobe | Status | resolved => closed |
| 2010-04-14 00:01 | anonymous | sf_bug_id | 0 => 2986802 |
| 2010-04-19 21:12 | hudsonbot | Checkin | |
| 2010-04-19 21:12 | hudsonbot | Note Added: 0026421 | |
| 2010-05-18 12:12 | gorka_gil | Target Version | 2.50MP15 => 2.50MP17 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |