0031738: UniqueValidCombination modulescript is deactivating some account combinations and creating new ones when it should not

Description

UniqueValidCombination modulescript is deactivating some account combinations and creating new ones when it should not

- The problem is reproducible until 3.0PR15Q3.3 version, whenever an update.database is done
- It is only reproducible after 3.0PR15Q4 version if the upgrade is done from MP19 or a previous version due to the solution of the 30396 bug

Steps To Reproduce

As group admin Role (in a version previous to 3.0PR15Q4):
   Create a record in the General Ledger Configuration
   Add the Account type dimension to it and select an account tree already used in another General Ledger (F&B España, S.A. Account Account)
   Check a new account combination has been created for each element value in the tree but with the new General Ledger. This is correct
   Now deactivate all the accounting combinations related with the same Account (10000 - Capital social)

* Launch the ant smartbuild -Dlocal=no command and restart Tomcat

As group admin role:
   Check that for one of the general ledgers the account combination has been set as inactive and a new one has been created

Proposed Solution

The selectDuplicates and updateValidCombinationDeactivateDuplicated functions in the UniqueValidCombination_data.xsql should group by c_acctschema_id

Tags

Approved

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0031470

closed

aferraz

UniqueValidCombination modulescript is deactivating some account combinations and creating new ones when it should not

Notes
(0082838) hgbot (developer) 2015-12-17 16:00	Repository: erp/backports/3.0PR15Q4.2 Changeset: 8efd1130ca4652fe0be980adab2c2de6f6cb1e50 Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> Date: Tue Dec 01 18:20:18 2015 +0100 URL: http://code.openbravo.com/erp/backports/3.0PR15Q4.2/rev/8efd1130ca4652fe0be980adab2c2de6f6cb1e50 [^] Fixes issue 31738: UniqueValidCombination modulescript is deactivating accounts Add group by c_acctschema_id in selectDuplicates and updateValidCombinationDeactivateDuplicated queries in UniqueValidCombination modulescript. --- M src-util/modulescript/build/classes/org/openbravo/modulescript/UniqueValidCombinationData.class M src-util/modulescript/src/org/openbravo/modulescript/UniqueValidCombination_data.xsql ---

(0082840) vmromanos (manager) 2015-12-17 16:01	Code review + testing (Oracle & Postgres) OK

Issue History
Date Modified	Username	Field	Change
2015-12-16 17:43	vmromanos	Type	defect => backport
2015-12-16 17:43	vmromanos	Target Version	=> 3.0PR15Q4.2
2015-12-17 16:00	vmromanos	Tag Attached: Approved
2015-12-17 16:00	hgbot	Checkin
2015-12-17 16:00	hgbot	Note Added: 0082838
2015-12-17 16:00	hgbot	Status	scheduled => resolved
2015-12-17 16:00	hgbot	Resolution	open => fixed
2015-12-17 16:00	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/backports/3.0PR15Q4.2/rev/8efd1130ca4652fe0be980adab2c2de6f6cb1e50 [^]
2015-12-17 16:01	vmromanos	Note Added: 0082840
2015-12-17 16:01	vmromanos	Status	resolved => closed