Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020871Openbravo ERP09. Financial managementpublic2012-06-26 13:412012-06-28 13:03
Reportermirurita 
Assigned Tomirurita 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date2012-05-03
Regression introduced in release
Regression introduced by commit
Triggers an Emergency Packyes
Summary0020871: Details widget in Reconciliation tab is not working
DescriptionDetails widget in Reconciliation tab is not working.

The following query does not return any value since MP12 because the ad_message_trl table does not contain any record for en_US language.

select m.messageText as regType,
a.reconciledItems as itemNo , a.reconciledItemsAmount as itemAmt
from APRM_Rec_Detail_v as a, ADMessageTrl as m
where a.type = m.message.searchKey and a.reconciliation.id = :reconciliationId and m.language.language = :language
Steps To Reproduce1) Go to Financial Account window
2) Select Bank - Account 1
3) Go to Reconciliations tab
4) Select Reconciliation with document no= 1000000
5) Realize that the widget is not displaying any value
Proposed SolutionModify the query.
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Reconciliation widget.png (26,924) 2012-06-26 13:41
https://issues.openbravo.com/file_download.php?file_id=5327&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2012-06-26 13:41miruritaNew Issue
2012-06-26 13:41miruritaAssigned To => mirurita
2012-06-26 13:41miruritaFile Added: Reconciliation widget.png
2012-06-26 13:41miruritaModules => Core
2012-06-26 13:41miruritaOBNetwork customer => No
2012-06-26 13:42miruritaRegression level => Production - QA Approved
2012-06-26 13:42miruritaRegression date => 2012-05-03
2012-06-26 13:42miruritaRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/303dc1728c72bccac5be5f0df86590bd17348e0f [^]
2012-06-27 12:30hgbotCheckin
2012-06-27 12:30hgbotNote Added: 0050186
2012-06-27 12:30hgbotStatusnew => resolved
2012-06-27 12:30hgbotResolutionopen => fixed
2012-06-27 12:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2f5972a49dc224003e332a1693e2ee8a5dd0d310 [^]
2012-06-28 07:59hudsonbotCheckin
2012-06-28 07:59hudsonbotNote Added: 0050219
2012-06-28 13:03eduardo_ArgalNote Added: 0050252
2012-06-28 13:03eduardo_ArgalStatusresolved => closed

Notes
(0050186)
hgbot   
2012-06-27 12:30   
Repository: erp/devel/pi
Changeset: 2f5972a49dc224003e332a1693e2ee8a5dd0d310
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Wed Jun 27 12:30:03 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2f5972a49dc224003e332a1693e2ee8a5dd0d310 [^]

Fixes issue 20871: Details widget in Reconciliation tab is not working

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
A modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/APRMApplicationInitializer.java
---
(0050219)
hudsonbot   
2012-06-28 07:59   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c66e853c5cf4 [^]

Maturity status: Test
(0050252)
eduardo_Argal   
2012-06-28 13:03   
Tested and working in different languages