Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015217Openbravo ERPA. Platformpublic2010-11-17 19:242010-12-30 13:13
Reportermirurita 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0RC4Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015217: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00154242.50MP25 closed alostale Moving forward / back arrows not working in Reconciliation tab 
related to defect 0015438 closed alostale Sorting by more than one column (at the same time) fails in Reconciliation tab of the Financial Account window 
related to defect 0015446 closed alostale DataGrid.getColumnTotals fails in Financial Account->Reconciliation tab 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-11-17 19:24miruritaNew Issue
2010-11-17 19:24miruritaAssigned To => alostale
2010-11-17 19:24miruritaOBNetwork customer => No
2010-11-22 08:35alostaleStatusnew => scheduled
2010-12-14 15:53alostaleStatusscheduled => acknowledged
2010-12-14 15:56alostaleStatusacknowledged => scheduled
2010-12-14 15:56alostalefix_in_branch => pi
2010-12-14 15:56alostaleTarget Version2.50MP25 => 3.0RC4
2010-12-14 15:56alostalefix_in_branchpi =>
2010-12-14 15:57hgbotCheckin
2010-12-14 15:57hgbotNote Added: 0033169
2010-12-14 15:57hgbotStatusscheduled => resolved
2010-12-14 15:57hgbotResolutionopen => fixed
2010-12-14 15:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/17b85f344d497a65de9a222d57c757f6e1215257 [^]
2010-12-15 13:44shuehnerRelationship addedrelated to 0015438
2010-12-15 18:12shuehnerRelationship addedrelated to 0015446
2010-12-15 18:27shuehnerNote Added: 0033214
2010-12-15 18:27shuehnerStatusresolved => closed
2010-12-16 22:16anonymoussf_bug_id0 => 3138794
2010-12-30 13:13hudsonbotCheckin
2010-12-30 13:13hudsonbotNote Added: 0033444

Notes
(0033169)
hgbot   
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   
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   
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 [^]