Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0020798 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | minor | always | 2012-06-19 10:37 | 2012-06-19 17:08 | |||
| Reporter | mirurita | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | high | Resolution | no change required | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Advanced Payables and Receivables Mngmt | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0020798: Reactivate Payment: TADPI.FIN_PAYMENT_ORIGSCHEDDETAIL violated - child record found | |||||||
| Description | Configure the payment method of the invoice to generate automatically the payment. Put in the same invoice two orders and complete the invoice. If you reactivate this payment and then try to generate credit reusing the same payment it fails (see attached screenshot). Caused by: java.sql.BatchUpdateException: ORA-02292: integrity constraint (TADPI.FIN_PAYMENT_ORIGSCHEDDETAIL) violated - child record found at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) | |||||||
| Steps To Reproduce | 1) Create a Sales Order (SO1) for Alimentos. Total= 46.5€ 2) Create a Sales Order (SO2) for Alimentos. Total= 4.9€ 3) Configure payment method for Alimentos to create automatically the payment when completing the invoice. 4) Create a Sales Invoice (SI1) for Alimentos. Invoice both orders. Total= 51.4€ 5) Complete the Invoice 6) Reactivate automatically created payment 7) Click on add details button 8) Unmark the selected lines in the grid. The total amount will be left as credit. 9) Click Process button See attached screenshot | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  Reactivate Payment orig error.png [^] (11,211 bytes) 2012-06-19 10:37
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0049928) eduardo_Argal (viewer) 2012-06-19 17:08 |
Bug was present due to a wrong behavior in invoice processing (payment generation) |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-06-19 10:37 | mirurita | New Issue | |
| 2012-06-19 10:37 | mirurita | Assigned To | => eduardo_Argal |
| 2012-06-19 10:37 | mirurita | File Added: Reactivate Payment orig error.png | |
| 2012-06-19 10:37 | mirurita | Modules | => Advanced Payables and Receivables Mngmt |
| 2012-06-19 10:37 | mirurita | OBNetwork customer | => No |
| 2012-06-19 17:08 | eduardo_Argal | Relationship added | related to 0020771 |
| 2012-06-19 17:08 | eduardo_Argal | Note Added: 0049928 | |
| 2012-06-19 17:08 | eduardo_Argal | Status | new => closed |
| 2012-06-19 17:08 | eduardo_Argal | Resolution | open => no change required |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |