Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034101Openbravo ERP09. Financial managementpublic2016-09-27 16:072016-09-29 23:30
Reporterngarcia 
Assigned ToSanjota 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q4 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034101: When creating a new general ledger, some tables from other general ledgers are being activated
DescriptionWhen creating a new general ledger, some tables from other general ledgers are being activated
Steps To ReproduceCheck through database the tables that are set as default accounting:

SELECT tablename FROM AD_TABLE WHERE ISDEFAULTACCT='Y'

As group admin role:
   Set as inactive that tables in an already existing General Ledger Configuration (Active tables)
   Create a new General Ledger
   Check the tables have been activated in the old General Ledger Configuration
Proposed SolutionAdd the new.C_ACCTSCHEMA_ID filter to the update made in the c_acctschema_trg
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-09-27 16:07ngarciaNew Issue
2016-09-27 16:07ngarciaAssigned To => Triage Finance
2016-09-27 16:07ngarciaModules => Core
2016-09-27 16:07ngarciaResolution time => 1477519200
2016-09-27 16:07ngarciaTriggers an Emergency Pack => No
2016-09-27 16:08ngarciaIssue Monitored: networkb
2016-09-28 09:27aferrazAssigned ToTriage Finance => Sanjota
2016-09-29 08:37SanjotaStatusnew => scheduled
2016-09-29 08:46SanjotaNote Added: 0090367
2016-09-29 14:32hgbotCheckin
2016-09-29 14:32hgbotNote Added: 0090376
2016-09-29 14:32hgbotStatusscheduled => resolved
2016-09-29 14:32hgbotResolutionopen => fixed
2016-09-29 14:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fda6c9f97c7ff78697a7cd44b78172a25b9e8d43 [^]
2016-09-29 14:32hgbotCheckin
2016-09-29 14:32hgbotNote Added: 0090377
2016-09-29 14:35aferrazReview Assigned To => aferraz
2016-09-29 14:35aferrazNote Added: 0090379
2016-09-29 14:35aferrazStatusresolved => closed
2016-09-29 14:35aferrazFixed in Version => 3.0PR16Q4
2016-09-29 23:30hudsonbotCheckin
2016-09-29 23:30hudsonbotNote Added: 0090395
2016-09-29 23:30hudsonbotCheckin
2016-09-29 23:30hudsonbotNote Added: 0090396

Notes
(0090367)
Sanjota   
2016-09-29 08:46   
Test plan:

Check through database the tables that are set as default accounting:

SELECT tablename FROM AD_TABLE WHERE ISDEFAULTACCT='Y'

As group admin role:
   Set as inactive that tables in an already existing General Ledger Configuration (Active tables)
   Create a new General Ledger
   Observe the tables inactive(in same state as in before creation of new general ledger) in the General Ledger Configuration.
   Only tables in new General Ledger Configuration are active.
(0090376)
hgbot   
2016-09-29 14:32   
Repository: erp/devel/pi
Changeset: fda6c9f97c7ff78697a7cd44b78172a25b9e8d43
Author: Sanjota <sanjota.nelagi <at> promantia.com>
Date: Thu Sep 29 12:10:49 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/fda6c9f97c7ff78697a7cd44b78172a25b9e8d43 [^]

Fixes issue 34101: Fix to activation of tables in old GL due to new GL creation

Made changes to fix issue with activation of inactive tables when creating new general ledger

---
M src-db/database/model/triggers/C_ACCTSCHEMA_TRG.xml
---
(0090377)
hgbot   
2016-09-29 14:32   
Repository: erp/devel/pi
Changeset: e9a62bbc525c1259aeba266879fa348ff170106c
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Sep 29 14:11:19 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e9a62bbc525c1259aeba266879fa348ff170106c [^]

Related to issue 34101: Code review improvements

---
M src-db/database/model/triggers/C_ACCTSCHEMA_TRG.xml
---
(0090379)
aferraz   
2016-09-29 14:35   
Code review + Testing OK
(0090395)
hudsonbot   
2016-09-29 23:30   
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/9f5481831914 [^]
Maturity status: Test
(0090396)
hudsonbot   
2016-09-29 23:30   
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/9f5481831914 [^]
Maturity status: Test