0006035: [QA-alpha-r1] Payment is not displayed when selecting a Cash Journal

Notes
(0010848) svnbot (reporter) 2008-12-01 15:28	Repository: openbravo Revision: 10785 Author: davidalsasua Date: 2008-12-01 15:28:05 +0100 (Mon, 01 Dec 2008) Fixes bug 0006035: [QA-alpha-r1] Payment is not displayed when selecting a Cash Journal --- U trunk/src-db/database/sourcedata/AD_TABLE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=10785&sc=1 [^]

(0011674) pjuvara (reporter) 2008-12-22 17:57	It seems that this issue is still open: https://sourceforge.net/forum/message.php?msg_id=5865852 [^]

(0011675) pjuvara (reporter) 2008-12-22 17:58	This issue is listed as fixed in alpha r3 in the release notes. If you confirm that it is still open, please do correct the release notes.

(0011676) svnbot (reporter) 2008-12-22 18:09	Repository: openbravo Revision: 11505 Author: davidalsasua Date: 2008-12-22 18:09:31 +0100 (Mon, 22 Dec 2008) Again same fix for same bug. Fixes Bug 0006035: [QA-alpha-r1] Payment is not displayed when selecting a Cash Journal --- U trunk/src-db/database/sourcedata/AD_TABLE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=11505&sc=1 [^]

(0013713) sureshbabu (reporter) 2009-02-19 08:31	I find the same isse still exists in the context 79.125.56.185/openbravotrunk. After selecting the payment, in the line page, the payment field shows ** instead of payment description. And after presssing the save button the correct value is displayed.

(0013843) vmromanos (manager) 2009-02-20 14:31	This bug seems to be a general problem of the application. The content of the sql_record_identifier column of the AD_Table table is being generated wrong all the time. Example: If we execute: select ad_column_identifier('C_Debt_Payment','19000115','en_US') from dual; the database will return '**', the same value the application is currently showing. But if we manually change the value of the sql_record_identifier of the AD_Table_ID='800018' record from: SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_BPartner TT WHERE TT.C_BPartner_ID=T.C_BPartner_ID) \|\|' - '\|\|(SELECT NAME FROM AD_REF_LIST_V WHERE AD_Language=L.AD_LANGUAGE AND Value=T.PaymentRule AND AD_Reference_ID=195)\|\|' - '\|\|TO_CHAR(COALESCE(TO_CHAR(T.Dateplanned),''))\|\|' - '\|\|TO_CHAR(COALESCE(TO_CHAR(T.Amount),''))\|\|' - '\|\|TO_CHAR(COALESCE(TO_CHAR(T.IsReceipt),'')) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_Debt_Payment T WHERE C_Debt_Payment_ID=':c_ID' to: SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_BPartner TT WHERE TT.C_BPartner_ID=T.C_BPartner_ID) \|\|' - '\|\|(SELECT NAME FROM AD_REF_LIST_V WHERE AD_Language=L.AD_LANGUAGE AND Value=T.PaymentRule AND AD_Reference_ID='195')\|\|' - '\|\|TO_CHAR(COALESCE(TO_CHAR(T.Dateplanned),''))\|\|' - '\|\|TO_CHAR(COALESCE(TO_CHAR(T.Amount),''))\|\|' - '\|\|TO_CHAR(COALESCE(TO_CHAR(T.IsReceipt),'')) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_Debt_Payment T WHERE C_Debt_Payment_ID=':c_ID' (see we have just changed AD_Reference_ID=195 by AD_Reference_ID='195'), the database will return the right value when executing the ad_column_identifier function again.

(0013852) svnbot (reporter) 2009-02-20 15:53	Repository: openbravo Revision: 13476 Author: davidalsasua Date: 2009-02-20 15:53:45 +0100 (Fri, 20 Feb 2009) Fixes Bug 6035: [QA-alpha-r1] Payment is not displayed when selecting a Cash Journal --- U trunk/src-db/database/model/functions/AD_COLUMN_IDENTIFIER_REF_SQL.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=13476&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-11-18 18:53	plujan	New Issue
2008-11-18 18:53	plujan	Assigned To	=> rafaroda
2008-11-18 18:53	plujan	sf_bug_id	0 => 2310395
2008-11-18 18:53	plujan	File Added: R250alpha_BUG_CashJournal.JPG
2008-11-18 18:53	plujan	Regression testing	=> No
2008-11-24 11:33	rafaroda	Assigned To	rafaroda => dalsasua
2008-11-24 11:33	rafaroda	Priority	normal => high
2008-11-24 11:33	rafaroda	Severity	trivial => major
2008-11-24 11:33	rafaroda	Status	new => scheduled
2008-12-01 15:28	svnbot	Checkin
2008-12-01 15:28	svnbot	Note Added: 0010848
2008-12-01 15:28	svnbot	Status	scheduled => resolved
2008-12-01 15:28	svnbot	Resolution	open => fixed
2008-12-01 15:28	svnbot	svn_revision	=> 10785
2008-12-18 12:08	krishna	Status	resolved => closed
2008-12-22 17:57	pjuvara	Status	closed => new
2008-12-22 17:57	pjuvara	Resolution	fixed => open
2008-12-22 17:57	pjuvara	Note Added: 0011674
2008-12-22 17:58	pjuvara	Note Added: 0011675
2008-12-22 18:09	svnbot	Checkin
2008-12-22 18:09	svnbot	Note Added: 0011676
2008-12-22 18:09	svnbot	Status	new => resolved
2008-12-22 18:09	svnbot	Resolution	open => fixed
2008-12-22 18:09	svnbot	svn_revision	10785 => 11505
2009-02-19 08:31	sureshbabu	Status	resolved => new
2009-02-19 08:31	sureshbabu	Resolution	fixed => open
2009-02-19 08:31	sureshbabu	Note Added: 0013713
2009-02-19 20:09	plujan	Relationship added	has duplicate 0007690
2009-02-19 20:09	plujan	Status	new => scheduled
2009-02-19 20:09	plujan	fix_in_branch	=> trunk
2009-02-20 14:31	vmromanos	Note Added: 0013843
2009-02-20 15:53	svnbot	Checkin
2009-02-20 15:53	svnbot	Note Added: 0013852
2009-02-20 15:53	svnbot	Status	scheduled => resolved
2009-02-20 15:53	svnbot	Resolution	open => fixed
2009-02-20 15:53	svnbot	svn_revision	11505 => 13476
2009-04-21 10:33	psarobe	Status	resolved => closed