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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015217
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2010-11-17 19:242010-12-30 13:13
ReportermiruritaView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision17b85f344d49
ProjectionnoneETAnoneTarget Version3.0RC4
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015217: Moving forward / back arrows not working in Reconciliation tab

DescriptionAll of the arrows for moving forward / back between rows are not working in Reconciliations tab (it's a view).

I get the following error:
ORA-00918: column ambiguously defined

Here the select statement:

SELECT Aprm_Reconciliation_V_ID, FIN_Reconciliation_ID
 FROM APRM_Reconciliation_v
left join (SELECT FIN_Reconciliation_ID, DocumentNo, Statementdate FROM FIN_Reconciliation) td0 on APRM_Reconciliation_v.FIN_Reconciliation_ID = td0.FIN_Reconciliation_ID
 WHERE APRM_Reconciliation_v.AD_Client_ID IN ('0','1000000')
 AND APRM_Reconciliation_v.AD_Org_ID IN ('0','1000000','1000002','1000003','1000004','1000005','1000006','1000008','1000009','1000007')
 AND APRM_Reconciliation_v.FIN_Financial_Account_ID = ?
ORDER BY APRM_Reconciliation_v.Statementdate DESC
Steps To Reproduce1) Install APRM module.
2) Apply the dataset of APRM.
3) Create a new Payment Method in Financial Management || Receivables & Payables || Setup || Payment Method
4) Create a new Financial Account in Financial Management || Receivables & Payables || Transaction || Financial Account and associate previously created payment method from Payment Method tab.
5) Go to to Financial Management || Receivables & Payables || Transaction || Financial Account >> Transactions tab and create a new Reconciliation.
  * Click on Reconcile button and click on Save button in the popup.
6) Go to Financial Management || Receivables & Payables || Transaction || Financial Account >> Reconciliations tab and click on any of the arrows for moving between records.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00154242.50MP25 closedalostale Moving forward / back arrows not working in Reconciliation tab 
related to defect 0015438 closedalostale Sorting by more than one column (at the same time) fails in Reconciliation tab of the Financial Account window 
related to defect 0015446 closedalostale DataGrid.getColumnTotals fails in Financial Account->Reconciliation tab 

-  Notes
(0033169)
hgbot (developer)
2010-12-14 15:57

Repository: erp/devel/pi
Changeset: 17b85f344d497a65de9a222d57c757f6e1215257
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Dec 14 15:57:09 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/17b85f344d497a65de9a222d57c757f6e1215257 [^]

fixed bug 15217: Moving forward / back arrows not working in Reconciliation tab

---
M src/org/openbravo/erpCommon/utility/TableSQLData.java
---
(0033214)
shuehner (administrator)
2010-12-15 18:27

Reviewed & tested on pi (rev: 7fb66e4a310f) on pgsql & oracle. By testing that that four (+switch to grid) actions of the navigation buttons work with filters + different sort orderings in the affected tab + a normal tab like Sales Order & the special ad_language tab.
(0033444)
hudsonbot (developer)
2010-12-30 13:13

A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/17b85f344d49 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7d7e5eebcc62 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19448.obx [^]

- Issue History
Date Modified Username Field Change
2010-11-17 19:24 mirurita New Issue
2010-11-17 19:24 mirurita Assigned To => alostale
2010-11-22 08:35 alostale Status new => scheduled
2010-12-14 15:53 alostale Status scheduled => acknowledged
2010-12-14 15:56 alostale Status acknowledged => scheduled
2010-12-14 15:56 alostale fix_in_branch => pi
2010-12-14 15:56 alostale Target Version 2.50MP25 => 3.0RC4
2010-12-14 15:56 alostale fix_in_branch pi =>
2010-12-14 15:57 hgbot Checkin
2010-12-14 15:57 hgbot Note Added: 0033169
2010-12-14 15:57 hgbot Status scheduled => resolved
2010-12-14 15:57 hgbot Resolution open => fixed
2010-12-14 15:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/17b85f344d497a65de9a222d57c757f6e1215257 [^]
2010-12-15 13:44 shuehner Relationship added related to 0015438
2010-12-15 18:12 shuehner Relationship added related to 0015446
2010-12-15 18:27 shuehner Note Added: 0033214
2010-12-15 18:27 shuehner Status resolved => closed
2010-12-16 22:16 anonymous sf_bug_id 0 => 3138794
2010-12-30 13:13 hudsonbot Checkin
2010-12-30 13:13 hudsonbot Note Added: 0033444


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker