Skip to Content
This question has been flagged
2 Replies
5324 Views
Avatar
Eric CATTELIN

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)"


Avatar
Discard
Avatar
Eric CATTELIN
Author Best Answer

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.

Avatar
Discard
Artem

'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....

Eric CATTELIN
Author

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)"

Artem

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

Avatar
Artem
Best Answer

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.

Avatar
Discard