Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020353Openbravo ERP09. Financial managementpublic2012-04-25 17:592012-04-30 09:56
Reporternaiaramartinez 
Assigned Tonaiaramartinez 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020353: API CHANGE: Add a contraint in AD_ORG_ACCTSCHEMA
DescriptionWe 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.
Steps To ReproduceTest 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'.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
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
---