Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0029040Openbravo ERP09. Financial managementpublic2015-02-24 09:402015-07-30 18:15
AtulOpenbravo 
dmiguelez 
lowminoralways
scheduledopen 
5
 
 
Core
No
0029040: API Change: Add unique constraint to C_AcctSchema_Element for Accounting Schema and Element Type
In order to avoid duplicate accounting combination for same account schema and account element, need a unique constraint in C_AcctSchema_Element for columns C_AcctSchema_ID and ElementType so that user cannot define a single element type for same accounting schema multiple times.
- Login as F&B International Group Admin
- Navigate to General Ledger Configuration and select any one record.
- Navigate to Dimension Tab.
- Try to add any Type multiple times. Check that you are able to add same element type multiple times.
No tags attached.
related to defect 0028978 closed vmromanos Duplicated account combinations when inserting an element value in an account tree referenced twice from a General Ledger Dimens 
? FixDuplicatedAcctCombinationsScript (4,459) 2015-07-30 18:14
https://issues.openbravo.com/file_download.php?file_id=8322&type=bug
Issue History
2015-02-24 09:40AtulOpenbravoNew Issue
2015-02-24 09:40AtulOpenbravoAssigned To => Sandrahuguet
2015-02-24 09:40AtulOpenbravoModules => Core
2015-02-24 09:40AtulOpenbravoTriggers an Emergency Pack => No
2015-02-24 09:42AtulOpenbravoRelationship addedblocks 0028978
2015-07-14 09:42vmromanosRelationship deletedblocks 0028978
2015-07-14 09:43vmromanosTypedefect => design defect
2015-07-14 09:43vmromanosPriorityhigh => low
2015-07-14 09:43vmromanosSeveritymajor => minor
2015-07-14 09:43vmromanosRelationship addedrelated to 0028978
2015-07-30 18:10dmiguelezFile Added: FixDuplicatedAcctCombinationsScript
2015-07-30 18:11dmiguelezStatusnew => scheduled
2015-07-30 18:13dmiguelezFile Deleted: FixDuplicatedAcctCombinationsScript
2015-07-30 18:14dmiguelezAssigned ToSandrahuguet => dmiguelez
2015-07-30 18:14dmiguelezFile Added: FixDuplicatedAcctCombinationsScript
2015-07-30 18:15dmiguelezNote Added: 0079136

Notes
(0079136)
dmiguelez   
2015-07-30 18:15   
Attached Script to fix wrong data for a Customer (Postgresql)