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= [email protected] [mailto: openerp-expert-accounting-bounces+colin= [email protected]] *On Behalf Of *Laurie Chrostowski *Sent:* 31 May 2012 17:06 *To:* [email protected] *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
_______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-accounting Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-accounting More help : https://help.launchpad.net/ListHelp
