openerp-expert-accounting team mailing list archive

[Colin MacMillan <colin@xxxxxxxxxxxxxxxxxxxxxx>]

Hello Laurie,



We have a module that I think will solve your problem – ea_import.



I’ve just uploaded the latest version and the examples last night – you can
download from apps.openerp.com -
http://apps.openerp.com/?filter={%22order_by%22%3A+%22click_counter+desc%22}&text_search=ea_import<http://apps.openerp.com/?filter=%7b%22order_by%22%3A+%22click_counter+desc%22%7d&text_search=ea_import>

The examples are for partner and sale order import but it can be used for
importing journal lines as well.



There are also some tutorial videos you can review here on youtube – best
expand the screen.  You will need to study the module a bit in order to use
it … it’s designed to be an expert level module.



Video here - http://www.youtube.com/watch?v=9HEOH1Xlqxw



Regards

Colin







*From:* openerp-expert-accounting-bounces+colin=
publicus-solutions.com@xxxxxxxxxxxxxxxxxxx [mailto:
openerp-expert-accounting-bounces+colin=
publicus-solutions.com@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Laurie
Chrostowski
*Sent:* 31 May 2012 17:06
*To:* openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
*Subject:* [Openerp-expert-accounting] Journal Item Import via CSV



Good day,



I am working to determine a method for importing journal items using a csv
file.



For example the customer has a payroll entry he/she needs to import
bi-weekly.  We created an example file for import which includes all the
proper accounts for the entry.



The imported fields include: name, journal.id, partner.id, account_id,
debit, credit, date, period_id, move_id and ref



The issue I have encountered is the move_id field causes an error on import
- without the move_id I can import the file however the imported lines
because separate entires which are unbalanced because they are not
"batched" together.



To combat this situation I have been able to create a false move and then
use that in the file for import however this is not a very good solution.



I'm hoping this group of experts has determined a method for importing
journal items via csv using the move_id field or some other method to keep
the lines "batched" together?



Any feedback is appreciated.



Thank you.

-- 
Laurie Chrostowski
Business Analyst
NovaPoint Group, LLC
(586) 330-9170
skype: lchrostowski