Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0015498 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 03. Procurement management | major | always | 2010-12-21 12:46 | 2011-05-24 10:57 | |||
| Reporter | maite | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | cc99630a4ea2 | ||||
| Projection | none | ETA | none | Target Version | 2.50MP26 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP24 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0015498: Error when using form of payment "Cash" and payment term with several lines | |||||||
| Description | When trying to complete an invoice using "Cash" form of payment and payment term with several lines you obtain this error: Error: inserción o actualización en la tabla «c_cashline» viola la llave foránea «c_cashline_c_debt_payment» If Form of Payment of the invoice is "Bank deposit" instead of "Cash" than it complete successfully. | |||||||
| Steps To Reproduce | 1. Master Data Management || Business Partner Setup || Payment Term || Header : create record with Offset Month Due=1 2. Master Data Management || Business Partner Setup || Payment Term || Header >> Lines : add 2 lines: one line --> Percentage=60 ; Overdue Payment Days Rule=5; Form of Payment=bank deposit ; Uncheck "rest" flag another line --> Percentage=40 ; Overdue Payment Days Rule=1; Form of Payment=cash ; 3. Procurement Management || Transactions || Purchase Invoice || Header : create record setting Form of Payment=Cash and Payment Terms already created 4. Procurement Management || Transactions || Purchase Invoice || Header >> Lines : add one line 5. Come back to header and try to process. You will obtain error: Error: inserción o actualización en la tabla «c_cashline» viola la llave foránea «c_cashline_c_debt_payment» 6. Change Invoice header Form of Payment to "Bank deposit". Process and you will obtain successful message. Problem is that C_INVOICE_POST makes this comprobation "IF (v_paymentcheck <> 0) THEN" before inserting c_debt_payment (line 1524), But it does not make it before inserting in c_cashline (line 1642) | |||||||
| Tags | closingMay2011 | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0033734) hgbot (developer) 2011-01-18 18:48 |
Repository: erp/stable/2.50 Changeset: cc99630a4ea2c630a3f4a750a5398fe3fab9257e Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Tue Jan 18 18:47:11 2011 +0100 URL: http://code.openbravo.com/erp/stable/2.50/rev/cc99630a4ea2c630a3f4a750a5398fe3fab9257e [^] Fixes issue 0015498: Error when using form of payment Cash and payment term with several lines It has been added a check that avoids the constraint violation --- M src-db/database/model/functions/C_INVOICE_POST.xml --- |
|
(0033735) adrianromero (viewer) 2011-01-18 18:52 |
* Testing the issue Kindly follow the steps to test and verify that now the invoice can be processed. It is also needed to verify that normal cases of processing invoices continue working as expected: Purchase invoices with sample payment terms, Sales invoices. Generated invoices. * Other areas affected It has been modified the C_INVOICE_POST procedure. All flows that depends on this procedure may be affected. |
|
(0033736) adrianromero (viewer) 2011-01-18 18:53 |
To test this issue the APR module must not be installed because this issue depends on the old payments flow. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-12-21 12:46 | maite | New Issue | |
| 2010-12-21 12:46 | maite | Assigned To | => adrianromero |
| 2010-12-21 12:46 | maite | Modules | => Core |
| 2010-12-21 12:46 | maite | OBNetwork customer | => Yes |
| 2011-01-11 12:51 | adrianromero | Status | new => scheduled |
| 2011-01-11 12:51 | adrianromero | fix_in_branch | => pi |
| 2011-01-11 12:51 | adrianromero | Type | defect => backport |
| 2011-01-11 12:51 | adrianromero | fix_in_branch | pi => |
| 2011-01-11 12:52 | adrianromero | Issue cloned | 0015608 |
| 2011-01-11 12:52 | adrianromero | Relationship added | depends on 0015608 |
| 2011-01-17 09:23 | dalsasua | Assigned To | adrianromero => dalsasua |
| 2011-01-18 17:45 | maite | Steps to Reproduce Updated | View Revisions |
| 2011-01-18 18:48 | hgbot | Checkin | |
| 2011-01-18 18:48 | hgbot | Note Added: 0033734 | |
| 2011-01-18 18:48 | hgbot | Status | scheduled => resolved |
| 2011-01-18 18:48 | hgbot | Resolution | open => fixed |
| 2011-01-18 18:48 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.50/rev/cc99630a4ea2c630a3f4a750a5398fe3fab9257e [^] |
| 2011-01-18 18:52 | adrianromero | Note Added: 0033735 | |
| 2011-01-18 18:53 | adrianromero | Note Added: 0033736 | |
| 2011-05-24 10:03 | dalsasua | Tag Attached: closingMay2011 | |
| 2011-05-24 10:57 | dalsasua | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |