Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0020798 | Openbravo ERP | 09. Financial management | public | 2012-06-19 10:37 | 2012-06-19 17:08 |
|
| Reporter | mirurita | |
| Assigned To | eduardo_Argal | |
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | no change required | |
| Platform | | OS | 20 | OS Version | Community Appliance |
| Product Version | pi | |
| Target Version | | Fixed in Version | | |
| 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
|
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0020771 | | closed | naiaramartinez | Automatic payment completing the invoice: two orders in same invoice creates incorrect payment |
|
| Attached Files |  Reactivate Payment orig error.png (11,211) 2012-06-19 10:37
https://issues.openbravo.com/file_download.php?file_id=5305&type=bug
|
|
| 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 |