Community mailing list archives

community@mail.odoo.com

Re: OCA's account_reset_chart

by
gunnar wagner
- 08/20/2015 19:15:06
On 8/20/2015 11:57 AM, Caudal Eric wrote:

>> If you have not started any transaction, you can just remove the localization and CoA manually, after resetting the properties.

not 100% clear what you mean. I tried earlier to de-install the Chinese localization Module (where I picked the wrong (big) CoA from) and reinstall it again.
By reinstalling I ran into an error message (don't recall it exactly)

regarding accounting entries I realized I might have been not 100% precise .... there are products/customers/suppliers that have (automatically) assigned income- or expense accounts. maybe that was my problem.
If I can wipe all this away with account_reset_chart maybe that's a less work intense procedure then trying to fix any re-installation error

best ...Gunnar

<blockquote cite="mid:CABxYQ6WhZdyGRcoACXEZGbaunHua_Xtpe9hWxbbnvnp=ZuUPgw@mail.gmail.com" type="cite">
On Thu, Aug 20, 2015 at 11:36 AM Gunnar Wagner <gunnar.wagner@irisgermanica.com> wrote:
hi Marc,

thanks for your feedback

>> install and run the following script :

my guess: that's a python script?


we have 2 companies ... I guess, I have to replace 'res.company' in this line 
 
>> sock.execute(dbname, uid, pwd, 'res.company', 'reset_chart', 1)

with the correct database id of the company I want to reset the CoA of, right?



>> ...you must have serious reason to use it  ! You will lose all 
>> accounts, all journals, all default account properties (on products, on 
>> product categories, on partners...)

that's fine. I have only installed the wrong template CoA and want to replace it with another template CoA. 
I have not used any accounting entries yet.

best ...Gunnar


 
On 8/20/2015 10:17 AM, Marc Cassuto wrote:
<blockquote cite="mid:55D53758.1080501@gmail.com" type="cite">
just install and run the following script :

====
# First need to install module account_reset_chart from repository 
OCA/account-financial-tools
import xmlrpclib

username = 'admin' #the user
pwd = 'PLEASE_CHANGE_ME'      #the password of the user
dbname = 'test2'    #the database

# Get the uid
sock_common = xmlrpclib.ServerProxy ('http://localhost:8069/xmlrpc/common')
uid = sock_common.login(dbname, username, pwd)

#replace localhost with the address of the server
sock = xmlrpclib.ServerProxy('http://localhost:8069/xmlrpc/object
')
sock.execute(dbname, uid, pwd, 'res.company', 'reset_chart', 1)
====

This told, you must have serious reason to use it  ! You will lose all 
accounts, all journals, all default account properties (on products, on 
product categories, on partners...)

My 2 cents,
Marc


On 08/19/2015 09:53 PM, Gunnar Wagner wrote:
> the problem of replacing an existing chart of accounts has been
> discussed in various threads here. I was under the impression ... it's
> not possible really.
> Strangely an existing OCA module I bumped over just now which seems to
> solve this problem has never been mentioned in those discusstions.
>
> https://github.com/OCA/account-financial-tools/tree/8.0/account_reset_chart
>
> I want to try that but don't quit understand the usage instructions in
> the README file though. Maybe someone here can clarify
>
>   >> To prevent major disasters when this module is installed, no
> interface is provided. Please run through xmlrpc, for instance using
> erppeek:
>
> does this mean you can not access odoo through your browser
> [ip-addresse]:8069 as long as account_reset_chart is installed?
>
> then it proceeds ...
>
> >> import erppeek
> >>
> >> host = 'localhost'
> >> port = '8069'
> >> admin_pw = 'admin'
> >> dbname = 'openerp'
> >>
> >> client = erppeek.Client('http://%s:%s' % (host, port))
> >> client.login('admin', admin_pw, dbname)
> >> client.execute('res.company', 'reset_chart', 1)
>
> is this a script, a config file? how do you practically operate the
> reset process (if the above is a sctipt then I guess you run it (using
> the appropriate data for your case naturally)
>
> thanks
> Gunnar
>
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



--
Gunnar Wagner | Iris Germanica Co., Ltd. | Jin Qian Gong Lu 385, 8-201, Feng Xian District, 201404 Shanghai, P.R. CHINA
+86.159.0094.1702 | skype: professorgunrad | wechat: 15900941702

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

--

Eric  Caudal (from my mobile)

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



--
Gunnar Wagner | Iris Germanica Co., Ltd. | Jin Qian Gong Lu 385, 8-201, Feng Xian District, 201404 Shanghai, P.R. CHINA
+86.159.0094.1702 | skype: professorgunrad | wechat: 15900941702