Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025859Openbravo ERP09. Financial managementpublic2014-02-27 18:002014-02-28 19:50
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelPre packaging ( pi )
Regression date2014-02-11
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/87765308f9bd4cdc21b7b53b437f1ed014f5a483 [^]
Triggers an Emergency PackNo
Summary0025859: Enable to run Payment Aging Reports
DescriptionFunction APRM_IsPaymentConfirmed method uses parameter fin_payment_scheduledetail_id which is used in the query having table with column fin_payment_scheduledetail_id. So there is ambiquity for column reference.
Steps To Reproduce- Navigate to Financial Management >> Receivable And Payables >> Analysis Tools >> Launch Receivables Aging Schedule or Payables Aging Schedule.
- Keeping default parameters for the report, click on search button.
- Notice that error message is displayed. could not load an entity batch: [Organization]
- In logs check ERROR: column reference "fin_payment_scheduledetail_id" is ambiguous

Note:- org.openbravo.agingbalance module should be installed.
Proposed SolutionParameter name in a function should not be same as column name used in the query used in the same function.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-02-27 18:00AtulOpenbravoNew Issue
2014-02-27 18:00AtulOpenbravoAssigned To => AtulOpenbravo
2014-02-27 18:00AtulOpenbravoModules => Core
2014-02-27 18:00AtulOpenbravoOBNetwork customer => No
2014-02-27 18:00AtulOpenbravoTriggers an Emergency Pack => No
2014-02-27 18:05AtulOpenbravoStatusnew => scheduled
2014-02-27 18:05AtulOpenbravofix_in_branch => pi
2014-02-27 18:13AtulOpenbravoRegression level => Pre packaging ( pi )
2014-02-27 18:13AtulOpenbravoRegression date => 2014-02-11
2014-02-27 18:13AtulOpenbravoRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/87765308f9bd4cdc21b7b53b437f1ed014f5a483 [^]
2014-02-27 18:13AtulOpenbravofix_in_branchpi =>
2014-02-27 18:19AtulOpenbravoNote Added: 0064661
2014-02-27 18:20AtulOpenbravoReview Assigned To => dmiguelez
2014-02-27 18:25hgbotCheckin
2014-02-27 18:25hgbotNote Added: 0064663
2014-02-27 18:25hgbotStatusscheduled => resolved
2014-02-27 18:25hgbotResolutionopen => fixed
2014-02-27 18:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0a192b614081020dde2ebee3952dd2e66e2d1e7c [^]
2014-02-27 18:50dmiguelezNote Added: 0064665
2014-02-27 18:50dmiguelezStatusresolved => closed
2014-02-28 19:50hudsonbotCheckin
2014-02-28 19:50hudsonbotNote Added: 0064700

Notes
(0064661)
AtulOpenbravo   
2014-02-27 18:19   
Test Plan
- Navigate to Financial Management >> Receivable And Payables >> Analysis Tools >> Launch Receivables Aging Schedule or Payables Aging Schedule.
- Keeping default parameters for the report, click on search button.
- Report is shown without any error.
(0064663)
hgbot   
2014-02-27 18:25   
Repository: erp/devel/pi
Changeset: 0a192b614081020dde2ebee3952dd2e66e2d1e7c
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Feb 27 22:54:19 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/0a192b614081020dde2ebee3952dd2e66e2d1e7c [^]

Fixes Issue 0025859: Enable to run Payment Aging Reports.

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml
---
(0064665)
dmiguelez   
2014-02-27 18:50   
Code Review + Testing Ok
(0064700)
hudsonbot   
2014-02-28 19:50   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/2a3305b1338e [^]
Maturity status: Test