Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0033681

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

minor

always

2016-08-10 13:31

2017-01-13 13:22

Reporter

maite

View Status

public

Assigned To

nonofrancisco

Priority

immediate

Resolution

open

Fixed in Version

Status

scheduled

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0033681: General Ledger's field default value should be modified in GL Journal Header and Tax Payment windows

Description

As 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 Reproduce

1. 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 Solution

We 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.

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0032535	3.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

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