Project:
| View Revisions: Issue #15498 | [ Back to Issue ] | ||
| Summary | 0015498: Error when using form of payment "Cash" and payment term with several lines | ||
| Revision | 2011-01-18 17:45 by maite | ||
| 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) |
||
| Revision | 2011-01-17 09:23 by maite | ||
| 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 ; 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) |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |