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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010131
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2009-07-30 14:042009-08-17 11:31
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision4f5cf4cb4d6c
ProjectionnoneETAnoneTarget Version2.40MP7
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP7SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010131: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00101592.40MP7 closeddalsasua Bank statement created using "Create Lines from" from a payment with "Write-off Amount" quantity gives an error when processing 

-  Notes
(0018752)
rafaroda (developer)
2009-07-31 09:47

David, can you please take action on this issue?

Thanks.
(0018773)
dalsasua (reporter)
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 (reporter)
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 (developer)
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 (reporter)
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"

- Issue History
Date Modified Username Field Change
2009-07-30 14:04 networkb New Issue
2009-07-30 14:04 networkb Assigned To => rafaroda
2009-07-31 09:47 rafaroda Note Added: 0018752
2009-07-31 09:47 rafaroda Assigned To rafaroda => dalsasua
2009-08-01 00:16 dalsasua Status new => closed
2009-08-01 00:16 dalsasua Note Added: 0018773
2009-08-01 00:16 dalsasua Resolution open => unable to reproduce
2009-08-02 00:00 anonymous sf_bug_id 0 => 2830933
2009-08-03 10:59 dalsasua Status closed => new
2009-08-03 10:59 dalsasua Resolution unable to reproduce => open
2009-08-03 10:59 dalsasua Note Added: 0018793
2009-08-03 10:59 dalsasua Status new => scheduled
2009-08-03 10:59 dalsasua fix_in_branch => pi
2009-08-03 11:01 dalsasua fix_in_branch pi =>
2009-08-03 11:01 dalsasua Proposed Solution updated
2009-08-03 11:01 dalsasua Steps to Reproduce Updated
2009-08-03 11:05 hgbot Checkin
2009-08-03 11:05 hgbot Note Added: 0018794
2009-08-03 11:05 hgbot Status scheduled => resolved
2009-08-03 11:05 hgbot Resolution open => fixed
2009-08-03 11:05 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4f5cf4cb4d6c581ecb7de0dd2cf166f0cd41fe92 [^]
2009-08-17 11:31 sureshbabu Status resolved => closed
2009-08-17 11:31 sureshbabu Note Added: 0018963
2009-08-17 11:31 sureshbabu Fixed in Version => pi


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker