Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006035Openbravo ERP09. Financial managementpublic2008-11-18 18:532009-04-21 10:33
Reporterplujan 
Assigned Todalsasua 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50beta 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006035: [QA-alpha-r1] Payment is not displayed when selecting a Cash Journal
DescriptionI create a Cash Journal, I create a line, Type Debt Payment. I select a Payment. After selecting the payment, the page shows ** instead of payment description. See attach.
Please note that after saving the correct value is displayed.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0007690 closed rafaroda On a Cash Journal, when selecting a Payment for a line I see only ** 
Attached Filesjpg R250alpha_BUG_CashJournal.JPG (72,308) 2008-11-18 18:53
https://issues.openbravo.com/file_download.php?file_id=436&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2008-11-18 18:53plujanNew Issue
2008-11-18 18:53plujanAssigned To => rafaroda
2008-11-18 18:53plujansf_bug_id0 => 2310395
2008-11-18 18:53plujanFile Added: R250alpha_BUG_CashJournal.JPG
2008-11-18 18:53plujanRegression testing => No
2008-11-24 11:33rafarodaAssigned Torafaroda => dalsasua
2008-11-24 11:33rafarodaPrioritynormal => high
2008-11-24 11:33rafarodaSeveritytrivial => major
2008-11-24 11:33rafarodaStatusnew => scheduled
2008-12-01 15:28svnbotCheckin
2008-12-01 15:28svnbotNote Added: 0010848
2008-12-01 15:28svnbotStatusscheduled => resolved
2008-12-01 15:28svnbotResolutionopen => fixed
2008-12-01 15:28svnbotsvn_revision => 10785
2008-12-18 12:08krishnaStatusresolved => closed
2008-12-22 17:57pjuvaraStatusclosed => new
2008-12-22 17:57pjuvaraResolutionfixed => open
2008-12-22 17:57pjuvaraNote Added: 0011674
2008-12-22 17:58pjuvaraNote Added: 0011675
2008-12-22 18:09svnbotCheckin
2008-12-22 18:09svnbotNote Added: 0011676
2008-12-22 18:09svnbotStatusnew => resolved
2008-12-22 18:09svnbotResolutionopen => fixed
2008-12-22 18:09svnbotsvn_revision10785 => 11505
2009-02-19 08:31sureshbabuStatusresolved => new
2009-02-19 08:31sureshbabuResolutionfixed => open
2009-02-19 08:31sureshbabuNote Added: 0013713
2009-02-19 20:09plujanRelationship addedhas duplicate 0007690
2009-02-19 20:09plujanStatusnew => scheduled
2009-02-19 20:09plujanfix_in_branch => trunk
2009-02-20 14:31vmromanosNote Added: 0013843
2009-02-20 15:53svnbotCheckin
2009-02-20 15:53svnbotNote Added: 0013852
2009-02-20 15:53svnbotStatusscheduled => resolved
2009-02-20 15:53svnbotResolutionopen => fixed
2009-02-20 15:53svnbotsvn_revision11505 => 13476
2009-04-21 10:33psarobeStatusresolved => closed

Notes
(0010848)
svnbot   
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   
2008-12-22 17:57   
It seems that this issue is still open:
https://sourceforge.net/forum/message.php?msg_id=5865852 [^]
(0011675)
pjuvara   
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   
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   
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   
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   
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 [^]