openerp-expert-accounting team mailing list archive

["Borja López Soilán (Pexego)" <borjals@xxxxxxxxx>]

Antony Lesuisse escribió:
> I use the following query repeated to fill the database: (duplicate 
> line while keeping the account_move)
>
> insert into account_move_line 
> (journal_id,currency_id,partner_id,company_id, state, 
> debit,credit,account_id,date,move_id,period_id,name) select 
> journal_id,currency_id,partner_id,company_id, state, 
> debit,credit,account_id,date
> ,move_id,period_id,name from account_move_line;

The account_renumber module of extra-addons includes a script that you 
might find useful.

It's a little python script (a XML-RPC OpenERP client) that allows you 
to create as many moves as you want, to do performance testing: 
http://bazaar.launchpad.net/~openerp-commiter/openobject-addons/stable_5.0-extra-addons/annotate/head:/account_renumber/test/create_moves.py 
<http://bazaar.launchpad.net/%7Eopenerp-commiter/openobject-addons/stable_5.0-extra-addons/annotate/head:/account_renumber/test/create_moves.py>


--
Borja López Soilán
borjals@xxxxxxxxx

Pexego Sistemas Informáticos S.L.
Avenida de Magoi 66 - 27002 Lugo (España)
Tel./Fax 982801517
http://www.pexego.es