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

Description

All 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 Reproduce

1) 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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0015217

3.0RC4

closed

alostale

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