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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015424
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformminoralways2010-11-17 19:242010-12-15 19:54
ReportermiruritaView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branch2.50Fixed in SCM revision2fbe2449d3ac
ProjectionnoneETAnoneTarget Version2.50MP25
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0015424: 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 ]
blocks defect 00152173.0RC4 closedalostale Moving forward / back arrows not working in Reconciliation tab 

-  Notes
(0033173)
hgbot (developer)
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 (administrator)
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.

- Issue History
Date Modified Username Field Change
2010-12-14 15:56 alostale Type defect => backport
2010-12-14 15:56 alostale fix_in_branch => 2.50
2010-12-14 16:04 hgbot Checkin
2010-12-14 16:04 hgbot Note Added: 0033173
2010-12-14 16:04 hgbot Status scheduled => resolved
2010-12-14 16:04 hgbot Resolution open => fixed
2010-12-14 16:04 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/2fbe2449d3acd7b78fc83fd5d3c968f0cff3bf54 [^]
2010-12-15 19:54 shuehner Note Added: 0033217
2010-12-15 19:54 shuehner Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker