Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010131Openbravo ERP09. Financial managementpublic2009-07-30 14:042009-08-17 11:31
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP7 
Target Version2.40MP7Fixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010131: Bank statement created using "Create Lines from" from a payment with "Write-off Amount" quantity gives an error when processing
DescriptionWhen you create a bank statement using "Create Lines from" button and the payment you choose have quantity in "Write-off Amount" field, is not possible to process the bank statement. Error obtained is the following:

Error:
In line20 the amount does not match with amount of the debt payment
Steps To Reproduce1. Financial Management || Receivables & Payables || Transactions || Bank Statement --> create a new bank statement
2. Press Create Lines From button
3. Choose a Payment created in a settlement
4. Navigate to Lines and to Payment window
5. Set any quantity in Write-off Amount field and save it. This action shouldn't be allowed by the application
6. Go back to your bank statement header and try to Process it
7. Error "In line20 the amount does not match with amount of the debt payment" is obtained
Proposed SolutionAdd a check in C_DEBT_PAYMENT_TRG trigger, so write-off amount of a payment included in a settlement shouldn't be changed once the settlement is processed.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00101592.40MP7 closed dalsasua Bank statement created using "Create Lines from" from a payment with "Write-off Amount" quantity gives an error when processing 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-30 14:04networkbNew Issue
2009-07-30 14:04networkbAssigned To => rafaroda
2009-07-31 09:47rafarodaNote Added: 0018752
2009-07-31 09:47rafarodaAssigned Torafaroda => dalsasua
2009-08-01 00:16dalsasuaStatusnew => closed
2009-08-01 00:16dalsasuaNote Added: 0018773
2009-08-01 00:16dalsasuaResolutionopen => unable to reproduce
2009-08-02 00:00anonymoussf_bug_id0 => 2830933
2009-08-03 10:59dalsasuaStatusclosed => new
2009-08-03 10:59dalsasuaResolutionunable to reproduce => open
2009-08-03 10:59dalsasuaNote Added: 0018793
2009-08-03 10:59dalsasuaStatusnew => scheduled
2009-08-03 10:59dalsasuafix_in_branch => pi
2009-08-03 11:01dalsasuafix_in_branchpi =>
2009-08-03 11:01dalsasuaProposed Solution updated
2009-08-03 11:01dalsasuaSteps to Reproduce Updated
2009-08-03 11:05hgbotCheckin
2009-08-03 11:05hgbotNote Added: 0018794
2009-08-03 11:05hgbotStatusscheduled => resolved
2009-08-03 11:05hgbotResolutionopen => fixed
2009-08-03 11:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4f5cf4cb4d6c581ecb7de0dd2cf166f0cd41fe92 [^]
2009-08-17 11:31sureshbabuStatusresolved => closed
2009-08-17 11:31sureshbabuNote Added: 0018963
2009-08-17 11:31sureshbabuFixed in Version => pi

Notes
(0018752)
rafaroda   
2009-07-31 09:47   
David, can you please take action on this issue?

Thanks.
(0018773)
dalsasua   
2009-08-01 00:16   
Hi. In the steps to reproduce it says:

1. Financial Management || Receivables & Payables || Transactions || Bank Statement --> create a new bank statement
->Ok
2. Press Create Lines From button
->Ok
3. Choose any Payment
->Ok
4. Navigate to Lines and to Payment window
->Do you mean, navigate to lines tab, and then through the "Payment" link to the tab where the payment is created. Is it?
5. Set any quantity in Write-off Amount field and save it
->If payment is available in payment selector of create lines from pop-up in bank statement, it should correspond to a processed document (invoice, or manual settlement). In that case, it cannot be modified, as it is in a processed document. It seems the problem is in customer's environment: it is navegating to the incorrect payment, or document has been able to be un-processed although payment was included in a bank statement.
I would need access to the environment where this bug is happening, as I tried to reproduce it, and I cannot.

Regards.
(0018793)
dalsasua   
2009-08-03 10:59   
After discussing with support, we located what the issue was. It is a problem in the way customer wanted to manage the write-off amounts in a bank statement. Nevertheless, we agreed that a check could be included in the erp for this not to happen.
(0018794)
hgbot   
2009-08-03 11:05   
Repository: erp/devel/pi
Changeset: 4f5cf4cb4d6c581ecb7de0dd2cf166f0cd41fe92
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Aug 03 11:02:18 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4f5cf4cb4d6c581ecb7de0dd2cf166f0cd41fe92 [^]

Fixes issue 10131: Bank statement created using "Create Lines from" from a payment with "Write-off Amount" quantity gives an error when processing

---
M src-db/database/model/triggers/C_DEBT_PAYMENT_TRG.xml
---
(0018963)
sureshbabu   
2009-08-17 11:31   
Checked with Pablo Sarobe about the system behavior, right now system not allowing the user to edit the Payment line. And the system throws an error message "Document posted/processed"