Openbravo Issue Tracking System - Openbravo ERP | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0022002 | Openbravo ERP | 09. Financial management | public | 2012-10-18 18:51 | 2012-10-22 13:27 |
Reporter | malsasua | ||||
Assigned To | dmiguelez | ||||
Priority | high | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | OS | 20 | OS Version | Community Appliance | |
Product Version | |||||
Target Version | Fixed in Version | ||||
Merge Request Status | |||||
Review Assigned To | |||||
OBNetwork customer | |||||
Web browser | Google Chrome | ||||
Modules | Core | ||||
Support ticket | |||||
Regression level | |||||
Regression date | |||||
Regression introduced in release | |||||
Regression introduced by commit | |||||
Triggers an Emergency Pack | No | ||||
Summary | 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) | ||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | |||||
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 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|