Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] E. Translationminoralways2020-03-27 22:242020-04-08 23:21
ReporterlbressanView Statuspublic 
Assigned Toinigo_lerga 
PrioritynormalResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0PR19Q3.2SCM revision 
Review Assigned To
Web browserGoogle Chrome
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0043603: Journal Entries Report not showing the traslation from account tree

DescriptionWhen the Account tree have elements value translation, the translations are not fetched into the Journal Entries Report with the languaje profile that the user selects. The ReportGeneralLedgerJournal_data.xsql does not query from c_elementvalue_trl table.
Steps To Reproduce1.- Go to Account Tree Window and select any account.
2.- Select any element in the Element value tab.
3.- Create a record in "Translation" Tab for any language (e.i. Spanish) and check the traslation checkbox. (See image 1)
4.- Change the profile languaje to Spanish (See image 2)
5.- Execute the Journal entries report (See image 3)
TagsNo tags attached.
Attached Filespng file icon 1.png [^] (71,350 bytes) 2020-03-27 22:24

png file icon 2.png [^] (89,810 bytes) 2020-03-27 22:25

png file icon 3.png [^] (76,436 bytes) 2020-03-27 22:26

diff file icon 43603-join.diff [^] (5,075 bytes) 2020-04-03 11:44 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
lbressan (developer)
2020-03-30 15:21

The problem affects any screen that displays or searches ledger accounts, for example, daily ledgers, balance sheets.
inigo_lerga (reporter)
2020-04-02 10:22

--Test Plan Mantis--
As the System Administrator role:
  - Go to the Language window. Open the "Spanish (Spain)"
    record and enable the System Language checkbox.
    Save the record.

Log out and Log in.
As the F&B International Group Admin role and Spanish as
Profile's language:
  - Go to the Account Tree window. Select the "F&B International
    Group Account Account" record.
  - Go to the Element Value Tab and search for the "Inventory Asset"
    record and select it.
  - Go to the Translation Subtab and open the Spanish(Spain) record.
    Put any desired name and enable the Translation checkbox.
    Save the record.
  - Go to the Journal Entries Report window. Select "F&B España, S.A" as
    Organization and "F&B International Group US/A/US Dollar" as General Ledger.
    Press the Search button.

  #In this moment the previously translation appears instead of Inventory Asset#
dmiguelez (developer)
2020-04-03 11:44

The severity of this issue has been updated to minor following the Bug Reporting Guidelines: [^]

Also, answering the previous comment, reviewing all accounting reports can not be reported as an Issue, since it is a Design Defect that requires analysis of every report, one by one.

Finally, as for the solution of this issue, a proposed patch is attached. However, performance must be tested in any client before applying this patch in production. The query of this report can retrieve plenty of data and is prone to have performance issues if not tested properly

- Issue History
Date Modified Username Field Change
2020-03-27 22:24 lbressan New Issue
2020-03-27 22:24 lbressan Assigned To => platform
2020-03-27 22:24 lbressan File Added: 1.png
2020-03-27 22:24 lbressan Web browser => Google Chrome
2020-03-27 22:24 lbressan Modules => Core
2020-03-27 22:24 lbressan Resolution time => 1588284000
2020-03-27 22:24 lbressan Triggers an Emergency Pack => No
2020-03-27 22:25 lbressan File Added: 2.png
2020-03-27 22:26 lbressan File Added: 3.png
2020-03-30 06:53 alostale Assigned To platform => Triage Finance
2020-03-30 08:13 Alberto_Sola Issue Monitored: Alberto_Sola
2020-03-30 12:03 inigo_lerga Assigned To Triage Finance => inigo_lerga
2020-03-30 12:03 inigo_lerga Status new => scheduled
2020-03-30 15:21 lbressan Note Added: 0118876
2020-04-02 10:22 inigo_lerga Note Added: 0118916
2020-04-03 11:41 dmiguelez Web browser Google Chrome => Google Chrome
2020-04-03 11:41 dmiguelez Severity major => minor
2020-04-03 11:44 dmiguelez Note Added: 0118935
2020-04-03 11:44 dmiguelez File Added: 43603-join.diff
2020-04-08 09:48 dmiguelez Web browser Google Chrome => Google Chrome
2020-04-08 09:48 dmiguelez Resolution time 1588284000 =>
2020-04-08 09:48 dmiguelez Type defect => design defect
2020-04-08 23:21 eugeni Issue Monitored: eugeni

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker