Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0033681
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2016-08-10 13:312017-01-13 13:22
ReportermaiteView Statuspublic 
Assigned Tononofrancisco 
PriorityimmediateResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033681: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00325353.0PR16Q3 closedmarkmm82 Report's currency and report's general ledger should be defaulted to organization's currency and organization's general ledger 
related to defect 0033040 closedSanjota Unhomogeneous behavior depending on Org Access when role is defined at "Organization" user level 
depends on feature request 0033650 closedAtulOpenbravo Add columns in AD_Org table to persist data in order to improve performance 
related to defect 0033798 schedulednonofrancisco General Ledger is not updated when organization changes 
related to defect 0033989 closedgorkaion Slow login loading organization's default ledgers 

-  Notes
(0089222)
nonofrancisco (developer)
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.

- Issue History
Date Modified Username Field Change
2016-08-10 13:31 maite New Issue
2016-08-10 13:31 maite Assigned To => Triage Finance
2016-08-10 13:31 maite Modules => Core
2016-08-10 13:31 maite Resolution time => 1472421600
2016-08-10 13:31 maite Triggers an Emergency Pack => No
2016-08-10 13:32 maite Issue Monitored: networkb
2016-08-10 13:33 maite Relationship added related to 0033086
2016-08-10 13:37 aferraz Relationship deleted related to 0033086
2016-08-10 13:37 aferraz Relationship added caused by 0033040
2016-08-10 13:38 aferraz Relationship added related to 0032535
2016-08-12 13:19 aferraz Regression level => Production - Confirmed Stable
2016-08-12 13:19 aferraz Regression date => 2016-06-02
2016-08-12 13:19 aferraz Regression introduced in release => 3.0PR16Q3
2016-08-12 13:19 aferraz Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/e1053e861351 [^]
2016-08-12 15:27 aferraz Assigned To Triage Finance => nonofrancisco
2016-08-16 12:27 aferraz Status new => scheduled
2016-08-18 18:37 nonofrancisco Note Added: 0089222
2016-08-19 11:46 maite Resolution time 1472421600 =>
2016-08-19 11:46 maite Regression level Production - Confirmed Stable =>
2016-08-19 11:46 maite Regression date 2016-06-02 =>
2016-08-19 11:46 maite Regression introduced in release 3.0PR16Q3 =>
2016-08-19 11:46 maite Regression introduced by commit https://code.openbravo.com/erp/devel/pi/rev/e1053e861351 [^] =>
2016-08-22 14:14 aferraz Relationship deleted caused by 0033040
2016-08-22 14:14 aferraz Relationship added related to 0033040
2016-08-24 19:47 nonofrancisco Relationship added related to 0033798
2016-09-09 15:15 aferraz Proposed Solution updated
2016-09-12 12:37 aferraz Relationship added depends on 0033650
2016-09-16 10:09 aferraz Relationship added related to 0033989


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker