0022002: In new account selector, some accounts are not displayed

Description

When you install the new account selector, if you have two accounting schemas with the same tree, only one account combination for each account (to the two accounting schemas) is active.

Steps To Reproduce

. in F&B
. create new accounting schema using the tree "F&B España, S.A. Account Account"
. apply the new selector

Proposed Solution

replace in file:
src-util/modulescript/src/org/openbravo/modulescript/UniqueValidCombination_data.xsql

the query insertValidCombinations to:

        INSERT INTO C_VALIDCOMBINATION
          (C_VALIDCOMBINATION_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
           UPDATED, UPDATEDBY, ALIAS, COMBINATION, DESCRIPTION, ISFULLYQUALIFIED,
           C_ACCTSCHEMA_ID, ACCOUNT_ID, M_PRODUCT_ID, C_BPARTNER_ID, AD_ORGTRX_ID, C_LOCFROM_ID,
           C_LOCTO_ID, C_SALESREGION_ID, C_PROJECT_ID, C_CAMPAIGN_ID, C_ACTIVITY_ID, USER1_ID,
           USER2_ID)
        select get_uuid(), c_elementvalue.ad_client_id, c_elementvalue.ad_org_id, 'Y', now(), '100',
        now(), '100', c_elementvalue.value, c_elementvalue.value, '', 'Y',
        c_acctschema_element.c_acctschema_id, c_elementvalue.c_elementvalue_id, null, null, c_elementvalue.ad_org_id, null,
        null, null, null, null, null, null,
        null
        from c_elementvalue, c_acctschema_element
        where c_elementvalue.elementlevel = 'S'
        and c_elementvalue.c_element_id = c_acctschema_element.c_element_id
        and not exists (select 1 from c_validcombination
                                        where c_validcombination.account_id = c_elementvalue.c_elementvalue_id
                                        and isactive='Y'
                                        and c_validcombination.c_acctschema_id = c_acctschema_element.c_acctschema_id)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0053482) hgbot (developer) 2012-10-19 10:31	Repository: erp/devel/pi Changeset: 3cbd7046cd2c7d6cf9197ab8f98ed94a8355af14 Author: David Miguelez <david.miguelez <at> openbravo.com> Date: Fri Oct 19 10:31:02 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/3cbd7046cd2c7d6cf9197ab8f98ed94a8355af14 [^] Fixes issue 22002: Filter by accounting schemas when creating the query. --- M src-util/modulescript/src/org/openbravo/modulescript/UniqueValidCombination_data.xsql ---

(0053484) malsasua (developer) 2012-10-19 10:37	test plan: . steps: OK . code review: OK

(0053531) hudsonbot (developer) 2012-10-22 13:27	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/483f2e6dc1af [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2012-10-18 18:51	malsasua	New Issue
2012-10-18 18:51	malsasua	Assigned To	=> dmiguelez
2012-10-18 18:51	malsasua	Web browser	=> Google Chrome
2012-10-18 18:51	malsasua	Modules	=> Core
2012-10-19 10:31	hgbot	Checkin
2012-10-19 10:31	hgbot	Note Added: 0053482
2012-10-19 10:31	hgbot	Status	new => resolved
2012-10-19 10:31	hgbot	Resolution	open => fixed
2012-10-19 10:31	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/3cbd7046cd2c7d6cf9197ab8f98ed94a8355af14 [^]
2012-10-19 10:37	malsasua	Note Added: 0053484
2012-10-19 10:37	malsasua	Status	resolved => closed
2012-10-22 13:27	hudsonbot	Checkin
2012-10-22 13:27	hudsonbot	Note Added: 0053531