Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013274
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2010-05-10 14:112010-06-17 00:00
ReporternataliaperuView Statuspublic 
Assigned Toharikrishnan 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision6acd1e0a7c95
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013274: "Create a new account for BP" does not filter by Client

DescriptionMore than one client is used in same environment.

Both have diferent COA.

In one client, Organization * is defined to create a new account for each BP created in the application. In fact, a sequence is used for it.

This sequence uses numbers, that any account has.

When entering a new BP this error appears:

"This is already a Account Element with same (Accounting Element, Search Key) (Accounting Element, Search Key) must be unique. You must change values entered.

It seems that this function is using SmallBazaar COA.
Steps To ReproduceCreate a new entity, for Mexican COA [sourceforge.net/projects/openbravo/files/04-openbravo-accounting/2.50, 2.40 and 2.35/AccountsMXOpenbravo.csv/download]

Change rol to new entity Admin.

Create a new organization (Initial Organization setup), as Legal with Accounting, using same COA.

Go to Organization window, and search the new one.
Check it as "Allow period control", and select the calendar.
Press "Set as ready".

Go to Financial Management > Accounting > Setup > Document sequence.
Createa a new one, as Autonumbering. As initial number, set 70000.
Go to Organization (*) > Org Schema, and select "Create a new account for BP", and select the sequence created.
As account length, and subaccount length, set 5.

Go to Master Data Management > Business Partner Setup > Business Partner Category.
Create a new one, called "Customer".

Go to Master Data Management > Business Partner.
Create a new one.

TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0027564)
adrianromero (manager)
2010-05-19 16:59

 The reason why it fails to create a new BP is because it are not defined neither the values Account Length nor Subaccount Length when there is checked the Create New Account for Business Partner field or Product field. These values have to be defined and also Subaccount Length must be greater than Account Length.
(0027607)
hgbot (developer)
2010-05-20 14:29

 Repository: erp/devel/pi
Changeset: c4c2e83df2d3d3e5121f9190624b74c8eee33604
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Thu May 20 17:58:34 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c4c2e83df2d3d3e5121f9190624b74c8eee33604 [^]

Fixes Issue 13274 In the function c_validcombination_clone their is a logic for generating the new value for the element value.In this logic they are subtracting the Account Length from Sub account Length.Hence if both are equal this value will become zero.Hence a both the values are checked in the org schema trigger.

---
M src-db/database/model/triggers/C_BPARTNER_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
A src-db/database/model/triggers/AD_ORG_ACCTSCHEMA_TRG2.xml
---
(0027608)
harikrishnan (reporter)
2010-05-20 14:30

 Steps to reproduce:

*Create a new client, organisation and business partner for the Organisation.

Root Cause:

In the function c_validcombination_clone their is a logic for generating the new value for the element value.In this logic they are subtracting the Account Length from Sub account Length.Hence if both are equal this value ll become zero.Hence a both the values are checked in the org schema trigger.

Impact:

Since i have checked only the not null in the trigger C_Bpartner_TRG.xml ,hence their is no impact in the existing functinality.
(0027624)
hgbot (developer)
2010-05-21 07:31

 Repository: erp/devel/pi
Changeset: 6acd1e0a7c950f4e288ba568fda619b8c30bcf81
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Fri May 21 11:00:28 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/6acd1e0a7c950f4e288ba568fda619b8c30bcf81 [^]

Fixes issue 13274 changes done for trigger should not work while deleting the record.

---
M src-db/database/model/triggers/AD_ORG_ACCTSCHEMA_TRG2.xml
---
(0027821)
hudsonbot (developer)
2010-05-29 09:47

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/c4c2e83df2d3 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/000000000000 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17407.obx [^]
(0027823)
hudsonbot (developer)
2010-05-29 09:47

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/6acd1e0a7c95 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/000000000000 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17407.obx [^]
(0028457)
psarobe (manager)
2010-06-15 17:59

 Arun is talking with the developer
(0028485)
harikrishnan (reporter)
2010-06-16 07:18

 Unable to reproduce.
(0028486)
arunkumar (reporter)
2010-06-16 07:19

 I was trying to reproduce the issue in a fresh environment. I am unable to reproduce this. I am closing the issue.

- Issue History
Date Modified Username Field Change
2010-05-10 14:11 nataliaperu New Issue
2010-05-10 14:11 nataliaperu Assigned To => adrianromero
2010-05-13 12:31 adrianromero Status new => scheduled
2010-05-13 12:31 adrianromero fix_in_branch => pi
2010-05-19 16:59 adrianromero Note Added: 0027564
2010-05-19 16:59 adrianromero Status scheduled => feedback
2010-05-20 14:25 adrianromero Status feedback => scheduled
2010-05-20 14:26 harikrishnan Assigned To adrianromero => harikrishnan
2010-05-20 14:29 hgbot Checkin
2010-05-20 14:29 hgbot Note Added: 0027607
2010-05-20 14:29 hgbot Status scheduled => resolved
2010-05-20 14:29 hgbot Resolution open => fixed
2010-05-20 14:29 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c4c2e83df2d3d3e5121f9190624b74c8eee33604 [^]
2010-05-20 14:30 harikrishnan Note Added: 0027608
2010-05-21 07:31 hgbot Checkin
2010-05-21 07:31 hgbot Note Added: 0027624
2010-05-21 07:31 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/c4c2e83df2d3d3e5121f9190624b74c8eee33604 [^] => http://code.openbravo.com/erp/devel/pi/rev/6acd1e0a7c950f4e288ba568fda619b8c30bcf81 [^]
2010-05-29 09:47 hudsonbot Checkin
2010-05-29 09:47 hudsonbot Note Added: 0027821
2010-05-29 09:47 hudsonbot Checkin
2010-05-29 09:47 hudsonbot Note Added: 0027823
2010-06-15 17:58 psarobe Status resolved => new
2010-06-15 17:58 psarobe Resolution fixed => open
2010-06-15 17:59 psarobe Note Added: 0028457
2010-06-15 17:59 psarobe Status new => scheduled
2010-06-16 07:18 harikrishnan Note Added: 0028485
2010-06-16 07:18 harikrishnan Status scheduled => resolved
2010-06-16 07:18 harikrishnan Resolution open => fixed
2010-06-16 07:19 arunkumar Note Added: 0028486
2010-06-16 07:19 arunkumar Status resolved => closed
2010-06-17 00:00 anonymous sf_bug_id 0 => 3017323

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker