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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0032424
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2016-03-07 12:472016-06-17 19:36
ReporteryogaskarnikView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityhighResolutionfixedFixed in Version3.0PR16Q3
StatusclosedFix in branchFixed in SCM revision24d0d8ebfed9
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0032424: New Account not created for Business Partner for organization F&B US, Inc. but works with F&B España, S.A

DescriptionNew Account not created for Business Partner for organization F&B US, Inc. but works with F&B España, S.A
Steps To Reproduce*Enable the General Ledgers tab in Organization window:
1.Login as system administrator to erp_mp_3.0PR15Q4.4
2.Navigate to Windows, Tabs and Fields, search for Organization and Enable the General Ledger tab

*Setup for new account creation
1.Login as client administrator to erp_mp_3.0PR15Q4.4
2.Navigate to Organization and select F&B US, Inc.
3.Go to General Ledgers tab and create a new record :
Create New Account for Business Partner=Y
Sequence for Business Partner=DocumentNo_C_BPartner
Account Length=7
Sub Account Length=11

*Business Partner creation
1.Navigate to Business Partner window:
2.Create new record:
search key=test
name=test
3.save the record and observe that the default account is added instead of new business partner account.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0034847 newmalsasua Unhomogeneous behavior when business partner is created: customer and employee accounting defaults 
causes defect 0033877 closedAtulOpenbravo Accounting default values not transferred from BP Category to Business Partner if the schema is assigned to a child organization 

-  Notes
(0085580)
AtulOpenbravo (developer)
2016-04-13 07:05
edited on: 2016-04-13 15:45

Test Plan for issue verification

* Enable the General Ledgers tab in Organization window:
1.Login as system administrator.
2.Navigate to Windows, Tabs and Fields, search for Organization and Enable the General Ledger tab

* Setup for new account creation
1.Login as F&B International Group Admin
2.Navigate to Organization and select F&B US, Inc.
3.Go to General Ledgers tab and create a new record :
Create New Account for Business Partner=Y
Sequence for Business Partner=DocumentNo_C_BPartner
Account Length=7
Sub Account Length=11
In Document Sequence for Business Partner, set Next Assigned Number = 500

* Go to "General Ledger Configuration", select F&B International Group US/Dollar general ledger. Go to defaults tab and check below accounts are shown within BP section:
** 1130 Accounts Receivable
** 2450 Customer Prepayment

* Business Partner creation
1.Navigate to Business Partner window:
2.Create new record:
org = F&B US Inc
search key=test
name=test
Configure it as a Customer.
3.save the record and go to Customer Accounting tab.
4. Check that customer receivables account added is default one, which is not correct.

Repeat same test as above for product.

(0085620)
psanjuan (manager)
2016-04-13 15:26

Issue verified.
(0085621)
psanjuan (manager)
2016-04-13 15:36

Correct behavior explained in this link:

http://wiki.openbravo.com/wiki/ManualDoc:T7580F9AE37704571BB0D3935252CAC5A [^]
(0085622)
psanjuan (manager)
2016-04-13 15:47
edited on: 2016-04-13 15:50

Test Plan

* Enable the General Ledgers tab in Organization window:
1.Login as system administrator.
2.Navigate to Windows, Tabs and Fields, search for Organization and Enable the General Ledger tab

* Setup for new account creation
1.Login as F&B International Group Admin
2.Navigate to Organization and select F&B US, Inc.
3.Go to General Ledgers tab and create a new record :
Create New Account for Business Partner=Y
Sequence for Business Partner=DocumentNo_C_BPartner
Account Length=7
Sub Account Length=11
In Document Sequence for Business Partner, set Next Assigned Number = 500

* Go to "General Ledger Configuration", select F&B International Group US/Dollar general ledger. Go to defaults tab and check below accounts are shown within BP section:
** 1130 Accounts Receivable

* Business Partner creation
1.Navigate to Business Partner window:
2.Create new record:
org = F&B US Inc
search key=test
name=test
Configure it as a Customer.
3.save the record and go to Customer Accounting tab.
4. Check that customer receivables account added is 11300500 and Customer Prepayment account added is 24500500

It is not 100% correct as length entered are not taken into account. Please double check.

Repeat same test as above for product.

(0085629)
aferraz (manager)
2016-04-13 19:37
edited on: 2016-04-14 10:03

Test plan II:

*Enable the General Ledgers tab in Organization window:
1.Login as system administrator to erp_mp_3.0PR15Q4.4
2.Navigate to Windows, Tabs and Fields, search for Organization and Enable the General Ledger tab

*In Document Sequence window, set Next Assigned Number = 500 for DocumentNo_C_BPartner.

*Setup for new account creation for F&B International Group organization:
1.Login as client administrator to erp_mp_3.0PR15Q4.4
2.Navigate to Organization and select F&B International Group
3.Go to General Ledgers tab and create a new record :
Create New Account for Business Partner=Y
Sequence for Business Partner=DocumentNo_C_BPartner
Account Length=4
Sub Account Length=7

*Setup for new account creation for F&B US, Inc. organization:
1.Login as client administrator to erp_mp_3.0PR15Q4.4
2.Navigate to Organization and select F&B US, Inc.
3.Go to General Ledgers tab and create a new record :
Create New Account for Business Partner=Y
Sequence for Business Partner=DocumentNo_C_BPartner
Account Length=4
Sub Account Length=9

*Setup for new account creation for F&B US East Coast organization:
1.Login as client administrator to erp_mp_3.0PR15Q4.4
2.Navigate to Organization and select F&B US East Coast
3.Go to General Ledgers tab and create a new record :
Create New Account for Business Partner=Y
Sequence for Business Partner=DocumentNo_C_BPartner
Account Length=4
Sub Account Length=11

*Business Partner creation
1.Navigate to Business Partner window:
2.Create new record:
org: F&B US, Inc.
search key=test
name=test
3.Check that customer receivables account added is 113000500 and Customer Prepayment account added is 245000500 (Account Length=4 and Sub Account Length=9) which is correct

(0085651)
hgbot (developer)
2016-04-14 19:29

Repository: erp/devel/pi
Changeset: 24d0d8ebfed92fd3bcee073b5780eb0afb7d40d9
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Apr 13 12:34:12 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/24d0d8ebfed92fd3bcee073b5780eb0afb7d40d9 [^]

Fixes Issue 32424:New Account not created for Business Partner

ORDER BY 1 DESC clause is now changed to DEFAULT that is ascending
order of the level of organization. As unique entry for every
acctschema is allowed. In the descending order case top most organization
setting were used to create entry in accounting tab. In the case mentioned
in the issue, F&B International Group org has level 3 and was first
to be inserted for schema F& International Group USD Account and for this
configuration create new bp account setting did not exists so deafult account
entry was made and though F&B US Inc had setting of new bp account but the
same acctschema could not be repeated in this case.

---
M src-db/database/model/triggers/C_BPARTNER_TRG.xml
---
(0085652)
hgbot (developer)
2016-04-14 19:29

Repository: erp/devel/pi
Changeset: 51adf3f34dbef5c80a620d1c90c41bb1d50f4853
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Apr 14 18:51:24 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/51adf3f34dbef5c80a620d1c90c41bb1d50f4853 [^]

Related to issue 32424: Code review improvements

Fix another call to AD_IsOrgIncluded where ad_org_id parameter was used instead of ad_client_id.
Retrieve only AD_Org_AcctSchema from business partner organization or from parent organizations, but not from children organizations.
Call to c_validcombination_clone only if first parameter is not null.
In c_validcombination_clone function, return null if first parameter is null.

---
M src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml
M src-db/database/model/triggers/C_BPARTNER_TRG.xml
---
(0085653)
aferraz (manager)
2016-04-14 19:30

Code review + Testing OK
(0087450)
hudsonbot (developer)
2016-06-17 19:36

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^]
Maturity status: Test
(0087451)
hudsonbot (developer)
2016-06-17 19:36

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2016-03-07 12:47 yogaskarnik New Issue
2016-03-07 12:47 yogaskarnik Assigned To => Triage Finance
2016-03-07 12:47 yogaskarnik Modules => Core
2016-03-07 12:47 yogaskarnik Resolution time => 1457478000
2016-03-07 12:47 yogaskarnik Triggers an Emergency Pack => No
2016-03-10 11:49 yogaskarnik Priority normal => high
2016-03-11 10:53 yogaskarnik Resolution time 1457478000 => 1459980000
2016-04-05 12:08 aferraz Assigned To Triage Finance => AtulOpenbravo
2016-04-12 06:29 AtulOpenbravo Status new => scheduled
2016-04-13 07:05 AtulOpenbravo Note Added: 0085580
2016-04-13 13:12 psanjuan Note Edited: 0085580 View Revisions
2016-04-13 15:25 psanjuan Note Edited: 0085580 View Revisions
2016-04-13 15:26 psanjuan Note Added: 0085620
2016-04-13 15:36 psanjuan Note Added: 0085621
2016-04-13 15:36 psanjuan Note Edited: 0085580 View Revisions
2016-04-13 15:45 psanjuan Note Edited: 0085580 View Revisions
2016-04-13 15:47 psanjuan Note Added: 0085622
2016-04-13 15:50 psanjuan Note Edited: 0085622 View Revisions
2016-04-13 19:37 aferraz Note Added: 0085629
2016-04-14 10:03 aferraz Note Edited: 0085629 View Revisions
2016-04-14 19:29 hgbot Checkin
2016-04-14 19:29 hgbot Note Added: 0085651
2016-04-14 19:29 hgbot Status scheduled => resolved
2016-04-14 19:29 hgbot Resolution open => fixed
2016-04-14 19:29 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/24d0d8ebfed92fd3bcee073b5780eb0afb7d40d9 [^]
2016-04-14 19:29 hgbot Checkin
2016-04-14 19:29 hgbot Note Added: 0085652
2016-04-14 19:30 aferraz Review Assigned To => aferraz
2016-04-14 19:30 aferraz Note Added: 0085653
2016-04-14 19:30 aferraz Status resolved => closed
2016-04-14 19:30 aferraz Fixed in Version => 3.0PR16Q3
2016-06-17 19:36 hudsonbot Checkin
2016-06-17 19:36 hudsonbot Note Added: 0087450
2016-06-17 19:36 hudsonbot Checkin
2016-06-17 19:36 hudsonbot Note Added: 0087451
2016-09-01 18:46 ngarcia Relationship added causes 0033877
2017-01-04 10:04 aferraz Relationship added related to 0034847


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker