Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0002665Openbravo ERP09. Financial managementpublic2008-02-28 13:372008-06-18 17:51
psarobe 
dalsasua 
normalminoralways
closedfixed 
5
 
2.40alpha-r3 
No
Core
No
0002665: QA-MAS Error in COA AccountsSimplifiedUS06.csv
Error while importing the account 331 - Retained earnings. Invalid column.

This happens when you use the process Import accounts
No tags attached.
Issue History
2008-06-12 19:25wrcorleyNote Added: 0007692
2008-06-12 19:25wrcorleyIssue Monitored: wrcorley
2008-06-18 17:51plujanStatusresolved => closed

Notes
(0006254)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1903871 [^]
(0003258)
psarobe   
2008-02-28 19:13   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1500703
Originator: YES

More things:

Only two accounts are defined as Subaccount:
129
516

This is wrong
(0003259)
dalsasua   
2008-06-06 15:34   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1924288
Originator: NO

New version of this file uploaded at http://downloads.sourceforge.net/openbravo/AccountsSimplifiedUS06v3.csv [^]
(0007692)
wrcorley   
2008-06-12 19:25   
Someone please correct me if I'm wrong, but...

The resolution presented here via SimplifiedUS06v3 was to removed "RETAINEDEARNINGS_ACCT" value from the DEFAULT_ACCOUNT column. However, table C_ACCTSCHEMA_GL has column "RETAINEDEARNING_ACCT" (notice the different spelling). Wouldn't correcting the spelling resolve this instead of excluding the field value?