Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0025859 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | minor | always | 2014-02-27 18:00 | 2014-02-28 19:50 | |||
| Reporter | AtulOpenbravo | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 0a192b614081 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | dmiguelez | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | Pre packaging ( pi ) | |||||||
| Regression date | 2014-02-11 | |||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/87765308f9bd4cdc21b7b53b437f1ed014f5a483 [^] | |||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0025859: Enable to run Payment Aging Reports | |||||||
| Description | Function 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 Solution | Parameter name in a function should not be same as column name used in the query used in the same function. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0064661) AtulOpenbravo (developer) 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 (developer) 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 (developer) 2014-02-27 18:50 |
Code Review + Testing Ok |
|
(0064700) hudsonbot (developer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-02-27 18:00 | AtulOpenbravo | New Issue | |
| 2014-02-27 18:00 | AtulOpenbravo | Assigned To | => AtulOpenbravo |
| 2014-02-27 18:00 | AtulOpenbravo | Modules | => Core |
| 2014-02-27 18:00 | AtulOpenbravo | Triggers an Emergency Pack | => No |
| 2014-02-27 18:05 | AtulOpenbravo | Status | new => scheduled |
| 2014-02-27 18:05 | AtulOpenbravo | fix_in_branch | => pi |
| 2014-02-27 18:13 | AtulOpenbravo | Regression level | => Pre packaging ( pi ) |
| 2014-02-27 18:13 | AtulOpenbravo | Regression date | => 2014-02-11 |
| 2014-02-27 18:13 | AtulOpenbravo | Regression introduced by commit | => https://code.openbravo.com/erp/devel/pi/rev/87765308f9bd4cdc21b7b53b437f1ed014f5a483 [^] |
| 2014-02-27 18:13 | AtulOpenbravo | fix_in_branch | pi => |
| 2014-02-27 18:19 | AtulOpenbravo | Note Added: 0064661 | |
| 2014-02-27 18:20 | AtulOpenbravo | Review Assigned To | => dmiguelez |
| 2014-02-27 18:25 | hgbot | Checkin | |
| 2014-02-27 18:25 | hgbot | Note Added: 0064663 | |
| 2014-02-27 18:25 | hgbot | Status | scheduled => resolved |
| 2014-02-27 18:25 | hgbot | Resolution | open => fixed |
| 2014-02-27 18:25 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0a192b614081020dde2ebee3952dd2e66e2d1e7c [^] |
| 2014-02-27 18:50 | dmiguelez | Note Added: 0064665 | |
| 2014-02-27 18:50 | dmiguelez | Status | resolved => closed |
| 2014-02-28 19:50 | hudsonbot | Checkin | |
| 2014-02-28 19:50 | hudsonbot | Note Added: 0064700 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |