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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015517
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2010-12-02 19:442011-05-24 10:57
ReportermaiteView Statuspublic 
Assigned Todalsasua 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision1933e86e2cc6
ProjectionnoneETAnoneTarget Version2.40MP13
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP12SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015517: Error in message obtained when processing Bank Statement

DescriptionUnder some conditions, error "In line the debt payment has a change status later than the selected Account Date" is thrown which is wrongly composed because it does not indicate line number
Steps To Reproduce1. Sales Management || Transactions || Sales Invoice || Header : create invoice with date 02/12/2010, document type "AR Invoice" and any line and COMPLETE it
2. Financial Management || Receivables & Payables || Transactions || Remittance || Header : create remittance for date 02/12/2010 and pressing "create lines from" choose payment associated to previous invoice. Process remittance
3. Financial Management || Receivables & Payables || Transactions || Bank Statement || Header : create bank statement with date 01/12/2010 and "pressing create lines from" choose negative payment associated to the remmitance
4. Try to process Bank Statement and you will obtain:
error "In line the debt payment has a change status later than the selected Account Date"
without indicating line number

Error is located in C_DP_MANAGEMENT_POST in query
IF(NOT FINISH_PROCESS) THEN
      SELECT count(*), MAX(ml.line)
      INTO v_Aux, v_line
      FROM C_DP_ManagementLine ml,
        C_DP_Management m
      WHERE ml.C_DP_Management_ID=m.C_DP_Management_ID
        AND m.C_DP_Management_ID=v_Record_ID
        AND exists
        (SELECT 1
        FROM C_DP_ManagementLine ml1,
          C_DP_Management m1
        WHERE m1.C_DP_Management_ID=ml1.C_DP_Management_ID
          AND ml1.C_Debt_Payment_ID=ml.C_Debt_Payment_ID
          AND m1.processed='Y'
          AND m1.DateAcct>m.DateAcct
        )
        ;
      if v_Aux!=0 then
        
       RAISE_APPLICATION_ERROR(-20000, '@Inline@'||v_line||' '||'@LaterChangeStatus@') ;
      end if;
    END IF;--FINISH_PROCESS

TagsclosingMay2011
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00153632.40MP13 closeddalsasua Error in message obtained when processing Bank Statement 

-  Notes
(0033397)
dalsasua (reporter)
2010-12-27 09:13

 This is the current process executed if the bank statement described in steps to reproduce is processed:

1.- C_BankStatement_Post procedure do create a new payment status management document automatically.
2.- This payment status management document do have always just two lines.
3.- Once the payment status management is created, it is processed, running C_DP_Management_Post process
4.- If the process fails, the error is returned to the C_BankStatment_Post, and shown in the UI.
5.- If it occurs that, as described in the steps to reproduce, the C_DP_Management_Post process fails, because there exists one payment status management prior to the new one, it will show the error:
In line XX the debt payment has a change status later than the selected Account Date
The XX will belong to the line in the newly created payment status management document (so, whether 10 or 20). In any case, nothing to do with the line number of the payment status management document that already exists.

There exists a bug in C_BankStatement_Post. Because of this, the lines created in the new payment status management document are not set. When the error mentioned in the issue is displayed, it shows "In line the debt...", while it must say "In line 10 the debt..." or "In line 20 the debt...".

I will fix this, and line number will be shown, but this will not help the reporter, as the line number of the existing payment status management document is expected, and not the line number of the new one. I think, also the message must enhanced to show this information.
(0033403)
hgbot (developer)
2010-12-27 12:23

 Repository: erp/stable/2.40
Changeset: 1933e86e2cc6943762dfa489a59e90830f0b3a81
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Dec 27 12:22:21 2010 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/1933e86e2cc6943762dfa489a59e90830f0b3a81 [^]

Fixes issue 15517: Error in message obtained when processing Bank Statement

---
M src-db/database/model/functions/C_BANKSTATEMENT_POST.xml
M src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---

- Issue History
Date Modified Username Field Change
2010-12-23 18:24 dalsasua Type defect => backport
2010-12-23 18:24 dalsasua fix_in_branch => 2.40
2010-12-27 09:13 dalsasua Note Added: 0033397
2010-12-27 12:23 hgbot Checkin
2010-12-27 12:23 hgbot Note Added: 0033403
2010-12-27 12:23 hgbot Status scheduled => resolved
2010-12-27 12:23 hgbot Resolution open => fixed
2010-12-27 12:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/1933e86e2cc6943762dfa489a59e90830f0b3a81 [^]
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