Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015498
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 03. Procurement managementmajoralways2010-12-21 12:462011-05-24 10:57
ReportermaiteView Statuspublic 
Assigned Todalsasua 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisioncc99630a4ea2
ProjectionnoneETAnoneTarget Version2.50MP26
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP24SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015498: Error when using form of payment "Cash" and payment term with several lines

DescriptionWhen 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 Reproduce1. 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)
TagsclosingMay2011
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0015608 closedadrianromero Error when using form of payment "Cash" and payment term with several lines 

-  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 (manager)
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 (manager)
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.

- 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
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker