Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

[Solved] Odoo 9 - Importing accounting entry with python code

By
Eric CATTELIN
on 10/6/16, 9:46 AM 168 views

Hello,

I try to import this files in my account journal entry.

NUMJL;DTOPE;NPIEC;INPIE;MONNAIE_IDENT;COURS;NUMCP;VMTDEB;VMTCRE;
PAY;30042016;0000000001;O.D.;EUR;0;633300;0.1;0;
PAY;30042016;0000000001;O.D.;EUR;0;448600;0;0.1;

For this i use this code :

def _import_data(self, data):
move_obj = self.env['account.move']
 line_obj = self.env['account.move.line']
 move = None
  for row in data:
if move and row['NPIEC'] != move.name:
move.post()
 move = None
move_vals = {}
line_vals = {}
for col in row:
value = row[col]
 if not move:
if col == 'NUMJL':
move_vals['journal_id'] = self._get_record_id(value, 'account.journal')
elif col == 'NUMPIEC':
move_vals['name'] = value
 elif col == 'DTOPE':
move_vals['ref'] = 'PAY-%s%s-01' % (value[4:],value[2:4])
 move_vals['date'] = self._get_date(value)
 if col == 'NUMCP':
line_vals['account_id'] = self._get_record_id(value, 'account.account')
 elif col == 'INPIE':
line_vals['name'] = value
 elif col == 'VMTDEB':
line_vals['debit'] = self._get_amount(value)
 elif col == 'VMTCRE':
line_vals['credit'] = self._get_amount(value)
 if not move:
move = move_obj.create(move_vals)
 line_vals['move_id'] = move.id
 line = line_obj.create(line_vals)
 if move:
 move.post()

But i've this message warning box in odoo :

"Cannot create unbalanced journal entry."

I've try to change my code like this without success

                 elif col == 'VMTDEB':
line_vals['debit'] = self._get_amount(value)
 if value <> 0:
line_vals['balance'] = self._get_amount(value)
 elif col == 'VMTCRE':
line_vals['credit'] = self._get_amount(value)
 if value <> 0:
line_vals['balance'] = self._get_amount(value) * -1

Can you help me please ?


I've finaly found the solution.
For line, we need to inhibit some controll by remplacing this
"line = line_obj.create(line_vals)"
by this
"line =line_obj.with_context(check_move_validity=False).create(line_vals)"


0
Eric CATTELIN
On 10/7/16, 2:47 AM

Thanks for you help Artem

I use french accounting so that why i've this format for accounting_id. My fonction self._get_record_id(value, 'account.account') helps me to find the right accounting_id with the name of my account.

I change my code and come soon to tell about the result.

'if col == 'NUMCP'' I think this does not work because 'col' is not equal 'NUMCP'. So to help I need to know 'data' variable format. Is it a list or dictionary or string or whatever....

Artem
on 10/7/16, 5:27 AM

I've finaly found the solution.

For line, we need to inhibit some controll by remplacing this

"line = line_obj.create(line_vals)"

by this

"line =line_obj.with_context(check_move_validity=False).create(line_vals)"

Eric CATTELIN
on 10/7/16, 11:26 AM

Using such context you create problems in the future. Suppose you will not able to post this entries later.

Artem
on 10/7/16, 3:51 PM
0
Artem
On 10/6/16, 5:40 PM

Field of account_move that are required : state, journal_id, date, name
Fields of account_move_line are required: date,  account_id, journal_id, debit, credit, date_maturity, move_id, name
For multi currency: currency_id, amount_currency
What is 'data' format? I'm not sure that 'if col == 'NUMCP'' works.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 10/6/16, 9:46 AM
Seen: 168 times
Last updated: 10/7/16, 11:27 AM