Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2012-04-25 17:592012-04-30 09:56
ReporternaiaramartinezView Statuspublic 
Assigned Tonaiaramartinez 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision98096daa12a2
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0020353: 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'.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0009862pi closednaiaramartinez Create New sub-account: Fields Account length and sub-account length are set as mandatory and should be optional 

-  Notes
iciordia (manager)
2012-04-25 20:16


hgbot (developer)
2012-04-26 17:18

Repository: erp/devel/api-checks
Changeset: 98096daa12a245dc4775790271be8059a9d687b3
Author: Naiara Martinez <naiara.martinez <at>>
Date: Thu Apr 26 15:41:33 2012 +0200
URL: [^]

fixed bug 20353 API CHANGE: Add a contraint in AD_ORG_ACCTSCHEMA

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

- Issue History
Date Modified Username Field Change
2012-04-25 17:59 naiaramartinez New Issue
2012-04-25 17:59 naiaramartinez Assigned To => iciordia
2012-04-25 17:59 naiaramartinez Modules => Core
2012-04-25 17:59 naiaramartinez Relationship added related to 0009862
2012-04-25 20:16 iciordia Note Added: 0047982
2012-04-25 20:16 iciordia Assigned To iciordia => naiaramartinez
2012-04-26 17:18 hgbot Checkin
2012-04-26 17:18 hgbot Note Added: 0048054
2012-04-26 17:18 hgbot Status new => resolved
2012-04-26 17:18 hgbot Resolution open => fixed
2012-04-26 17:18 hgbot Fixed in SCM revision => [^]
2012-04-30 09:56 naiaramartinez Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker