Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015518Openbravo ERP09. Financial managementpublic2010-12-02 19:442011-01-27 18:41
Reportermaite 
Assigned Todalsasua 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP12 
Target Version2.40MP13Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015518: 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

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to backport 00155262.50MP26 closed dalsasua error message is wrong to process a bank statement 
blocks defect 00153632.40MP13 closed dalsasua Error in message obtained when processing Bank Statement 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-12-23 18:24dalsasuaTypedefect => backport
2010-12-23 18:24dalsasuafix_in_branch => 2.50
2011-01-10 12:04hgbotCheckin
2011-01-10 12:04hgbotNote Added: 0033561
2011-01-10 12:04hgbotStatusscheduled => resolved
2011-01-10 12:04hgbotResolutionopen => fixed
2011-01-10 12:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/e0d091677fc6f126539cc286189a07f1e90897fc [^]
2011-01-27 18:41psarobeStatusresolved => closed
2011-01-28 10:33dalsasuaRelationship addedrelated to 0015526

Notes
(0033561)
hgbot   
2011-01-10 12:04   
Repository: erp/stable/2.50
Changeset: e0d091677fc6f126539cc286189a07f1e90897fc
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Jan 10 12:03:29 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/e0d091677fc6f126539cc286189a07f1e90897fc [^]

Fixes issue 15518: Error in message obtained when processing Bank St.

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