Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033681Openbravo ERP09. Financial managementpublic2016-08-10 13:312017-01-13 13:22
Reportermaite 
Assigned Tononofrancisco 
PriorityimmediateSeverityminorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket43199
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033681: General Ledger's field default value should be modified in GL Journal Header and Tax Payment windows
DescriptionAs a consequence of changes associated to https://issues.openbravo.com/view.php?id=33086 [^] , currenct default value (@$C_ACCTSCHEMA_ID@) is not properly working
Steps To Reproduce1. Access to GL Journal window, create record for España Norte organization
2. Create record in Header tab and realize that F&B España, S.A. US/A/Euro is defaulted to General Ledger field
3. Navigate to General Ledger and edit name to leave it as "zzzF&B España, S.A. US/A/Euro"
4. Logout / login
5. Create new GL Journal record and Header record and realize that now "F&B International Group US/A/US Dollar" is defaulted, which is wrong

Same behavior is reproducible in Tax Payment window
Proposed SolutionWe need to create a new table to save inherited values for each organization such as c_acctschema_id and c_currency_id and avoid calls to ad_isorgincluded function wich does not perform well.

Once this development is done, we should review every call to ad_isorgincluded db function and try to change it making use of this new table.

In this case, we should make two changes:

1.- Retrieve default c_acctschema_id for document organization in GL_Journal and C_TaxPayment tables, querying this new table.

2.- Avoid loop in LoginUtils.java, doing only one query to this new table to retrieve the c_acctschema_id of the login organization.
Additional Information
TagsNo tags attached.
Relationships
related to defect 00325353.0PR16Q3 closed markmm82 Report's currency and report's general ledger should be defaulted to organization's currency and organization's general ledger 
related to defect 0033040 closed Sanjota Unhomogeneous behavior depending on Org Access when role is defined at "Organization" user level 
depends on feature request 0033650 closed AtulOpenbravo Add columns in AD_Org table to persist data in order to improve performance 
related to defect 0033798 scheduled nonofrancisco General Ledger is not updated when organization changes 
related to defect 0033989 closed gorkaion Slow login loading organization's default ledgers 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-08-10 13:31maiteNew Issue
2016-08-10 13:31maiteAssigned To => Triage Finance
2016-08-10 13:31maiteOBNetwork customer => Yes
2016-08-10 13:31maiteModules => Core
2016-08-10 13:31maiteSupport ticket => 43199
2016-08-10 13:31maiteResolution time => 1472421600
2016-08-10 13:31maiteTriggers an Emergency Pack => No
2016-08-10 13:32maiteIssue Monitored: networkb
2016-08-10 13:33maiteRelationship addedrelated to 0033086
2016-08-10 13:37aferrazRelationship deletedrelated to 0033086
2016-08-10 13:37aferrazRelationship addedcaused by 0033040
2016-08-10 13:38aferrazRelationship addedrelated to 0032535
2016-08-12 13:19aferrazRegression level => Production - Confirmed Stable
2016-08-12 13:19aferrazRegression date => 2016-06-02
2016-08-12 13:19aferrazRegression introduced in release => 3.0PR16Q3
2016-08-12 13:19aferrazRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/e1053e861351 [^]
2016-08-12 15:27aferrazAssigned ToTriage Finance => nonofrancisco
2016-08-16 12:27aferrazStatusnew => scheduled
2016-08-18 18:37nonofranciscoNote Added: 0089222
2016-08-19 11:46maiteResolution time1472421600 =>
2016-08-19 11:46maiteRegression levelProduction - Confirmed Stable =>
2016-08-19 11:46maiteRegression date2016-06-02 =>
2016-08-19 11:46maiteRegression introduced in release3.0PR16Q3 =>
2016-08-19 11:46maiteRegression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/e1053e861351 [^] =>
2016-08-22 14:14aferrazRelationship deletedcaused by 0033040
2016-08-22 14:14aferrazRelationship addedrelated to 0033040
2016-08-24 19:47nonofranciscoRelationship addedrelated to 0033798
2016-09-09 15:15aferrazProposed Solution updated
2016-09-12 12:37aferrazRelationship addeddepends on 0033650
2016-09-16 10:09aferrazRelationship addedrelated to 0033989

Notes
(0089222)
nonofrancisco   
2016-08-18 18:37   
Test Plan

- Access to GL Journal window, create record for España Norte organization
- Create record in Header tab and realize that F&B España, S.A. US/A/Euro is defaulted to General Ledger field
- Navigate to General Ledger and edit name to leave it as "zzzF&B España, S.A. US/A/Euro"
- Logout / login
-- Create new GL Journal record and Header record and realize that "zzzF&B España, S.A. US/A/Euro" is defaulted.