Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015424Openbravo ERPA. Platformpublic2010-11-17 19:242010-12-15 19:54
Reportermirurita 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version2.50MP25Fixed 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
Summary0015424: 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
blocks defect 00152173.0RC4 closed alostale Moving forward / back arrows not working in Reconciliation tab 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-12-14 15:56alostaleTypedefect => backport
2010-12-14 15:56alostalefix_in_branch => 2.50
2010-12-14 16:04hgbotCheckin
2010-12-14 16:04hgbotNote Added: 0033173
2010-12-14 16:04hgbotStatusscheduled => resolved
2010-12-14 16:04hgbotResolutionopen => fixed
2010-12-14 16:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/2fbe2449d3acd7b78fc83fd5d3c968f0cff3bf54 [^]
2010-12-15 19:54shuehnerNote Added: 0033217
2010-12-15 19:54shuehnerStatusresolved => closed

Notes
(0033173)
hgbot   
2010-12-14 16:04   
Repository: erp/stable/2.50
Changeset: 2fbe2449d3acd7b78fc83fd5d3c968f0cff3bf54
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Dec 14 16:03:46 2010 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/2fbe2449d3acd7b78fc83fd5d3c968f0cff3bf54 [^]

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

---
M src/org/openbravo/erpCommon/utility/TableSQLData.java
---
(0033217)
shuehner   
2010-12-15 19:54   
Exactly same code-change as the defect for this backport so no extra testing needed again. But also tested by reporter that the issue doesn't happen anymore for him in a 2.50 branch with this changeset applied also.