Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020353Openbravo ERP09. Financial managementpublic2012-04-25 17:592012-04-30 09:56
naiaramartinez 
naiaramartinez 
normalmajoralways
closedfixed 
5
 
 
Core
No
0020353: API CHANGE: Add a contraint in AD_ORG_ACCTSCHEMA
We need to add the next contraints:
CONSTRAINT ad_org_acctschema_bpfields_chk CHECK (isbpnewaccount = 'N'::bpchar OR isbpnewaccount = 'Y'::bpchar AND ad_sequence_bp_id IS NOT NULL AND acct_length IS NOT NULL AND subacct_length IS NOT NULL),
CONSTRAINT ad_org_acctschema_prfields_chk CHECK (isprnewaccount = 'N'::bpchar OR isprnewaccount = 'Y'::bpchar AND ad_sequence_pr_id IS NOT NULL AND acct_length IS NOT NULL AND subacct_length IS NOT NULL)

This change is an API change. We have verified in differente client's BBDD and there is no risk.
Test Plan:
  Go to General Setup || Enterprise Model || Organization
  Select 'F&A EspaƱa, S.A.' organization.
  Go to 'Org Schema' tab.
  Create new record:
     Select an accounting schema and save the record.
  If you see the newly create record in grid view, you will be able to see that there are no values for 'Sequence for Business Partner' and 'Sequence for Product'.
No tags attached.
related to defect 0009862pi closed naiaramartinez Create New sub-account: Fields Account length and sub-account length are set as mandatory and should be optional 
Issue History
2012-04-25 17:59naiaramartinezNew Issue
2012-04-25 17:59naiaramartinezAssigned To => iciordia
2012-04-25 17:59naiaramartinezModules => Core
2012-04-25 17:59naiaramartinezRelationship addedrelated to 0009862
2012-04-25 20:16iciordiaNote Added: 0047982
2012-04-25 20:16iciordiaAssigned Toiciordia => naiaramartinez
2012-04-26 17:18hgbotCheckin
2012-04-26 17:18hgbotNote Added: 0048054
2012-04-26 17:18hgbotStatusnew => resolved
2012-04-26 17:18hgbotResolutionopen => fixed
2012-04-26 17:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/98096daa12a245dc4775790271be8059a9d687b3 [^]
2012-04-30 09:56naiaramartinezStatusresolved => closed

Notes
(0047982)
iciordia   
2012-04-25 20:16   
Approved.

Ismael
(0048054)
hgbot   
2012-04-26 17:18   
Repository: erp/devel/api-checks
Changeset: 98096daa12a245dc4775790271be8059a9d687b3
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Thu Apr 26 15:41:33 2012 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/98096daa12a245dc4775790271be8059a9d687b3 [^]

fixed bug 20353 API CHANGE: Add a contraint in AD_ORG_ACCTSCHEMA

---
M model/src-db/database/model/tables/AD_ORG_ACCTSCHEMA.xml
---