Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010113Openbravo ERP09. Financial managementpublic2009-07-29 14:282009-08-21 00:00
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.50MP2 
Target VersionFixed in Versionpi 
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
Summary0010113: process "import account" does not creates all accounts defaults
Descriptionin csv file, in column "default", there are accounts to
 CB_CASHTRANSFER_ACCT and NOTINVOICEDRECEIVABLES_ACCT

but "import process" does not create validcombination to this accounts, and in table acctschema_default , columns CB_CASHTRANSFER_ACCT and NOTINVOICEDRECEIVABLES_ACCT are voids.
Steps To Reproduce. Master Data Management || Import Data || Import File Loader || Import File Loader -> import csv file

. Master Data Management || Import Data || Import Account || Import Account -> process accounts
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-29 14:28networkbNew Issue
2009-07-29 14:28networkbAssigned To => rafaroda
2009-07-30 13:00psarobeStatusnew => scheduled
2009-07-30 13:00psarobeAssigned Torafaroda => dalsasua
2009-07-30 13:00psarobefix_in_branch => pi
2009-07-30 20:58dalsasuaNote Added: 0018734
2009-07-30 20:59dalsasuaNote Edited: 0018734
2009-07-31 18:43hgbotCheckin
2009-07-31 18:43hgbotNote Added: 0018770
2009-07-31 18:43hgbotStatusscheduled => resolved
2009-07-31 18:43hgbotResolutionopen => fixed
2009-07-31 18:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fd9f5ae4943df80af6ec48a366c024856c150990 [^]
2009-08-20 12:25dalsasuaNote Added: 0019094
2009-08-20 17:15sureshbabuStatusresolved => closed
2009-08-20 17:15sureshbabuNote Added: 0019130
2009-08-20 17:15sureshbabuFixed in Version => pi
2009-08-21 00:00anonymoussf_bug_id0 => 2841458

Notes
(0018734)
dalsasua   
2009-07-30 20:58   
(edited on: 2009-07-30 20:59)
Hi,

Problem has been detected, and is not related to the concrete default values CB_CASHTRANSFER_ACCT and NOTINVOICEDRECEIVABLES_ACCT, but to any default value in an imported chart of accounts that didn't exists previously in the client account tree (no valid combination was asigned to this default value in acct.schema default window).

I'm working on it, and expect to have a fix by tomorrow first hour in the morning.

Regards.
(0018770)
hgbot   
2009-07-31 18:43   
Repository: erp/devel/pi
Changeset: fd9f5ae4943df80af6ec48a366c024856c150990
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Jul 31 18:43:19 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/fd9f5ae4943df80af6ec48a366c024856c150990 [^]

Fixes issue 10113: process "import account" does not creates all accounts defaults

---
M src/org/openbravo/erpCommon/ad_process/ImportAccount.java
M src/org/openbravo/erpCommon/ad_process/ImportAccount_data.xsql
---
(0019094)
dalsasua   
2009-08-20 12:25   
Hi,

In order to be able to reproduce this issue proceed like this:

Perform an initial client setup with a chart of accounts where no account has got the default NOTINVOICEDRECEIVABLES_ACCT. Check that in c_acctschema_default, there is no value for this.
Perform an import accounts with same chart of accounts, but this time with some account with NOTINVOICEDRECEIVABLES_ACCT default value.
Check that in c_acctschema_default, before fixing the bug, continued to be null. After fixing the bug, is populated.

Regards.
(0019130)
sureshbabu   
2009-08-20 17:15   
Tested, values are assigned to the columns CB_CASHTRANSFER_ACCT and NOTINVOICEDRECEIVABLES_ACCT in the table C_ACCTSCHEMA_DEFAULT