Skip to Content
This question has been flagged
journalodooOdoo13.0bills
7 Replies
5822 Views
Avatar
Pawan Kumar Sharma

Hello Community,

Recently I have been trying to create vendor bills in odoo13 by code by apparently every time I run the code I get a message "Cannot create unbalanced journal entry. Ids: [177] Differences debit - credit: [3.5]"

3.5 in my unit_price.

My code is below:

payment_move = self.env['account.move'].create({
    'type': 'in_invoice',
    'partner_id': self.client.id,
})
payment_move.invoice_line_ids.create({'move_id': payment_move.id,
                                      'quantity': 1.0,
                                      'price_unit': 3.5,
                                      'account_id': self.env['account.account'].search(
        [('user_type_id', '=', self.env.ref('account.data_account_type_expenses').id)], limit=1).id})

Thanks in advance.

Avatar
Discard
Avatar
Paresh Wagh
Best Answer

This may help

Create invoices/credit notes in odoo13 by code

Avatar
Discard
vbhargav31@gmail.com

hello paresh wagh can you share your answer here i think your link can't find page.

Thank You in advance.

Paresh Wagh

The link seems to be working fine. It's a link to another thread where this same topic was discussed.

LukaszK

@Paresh i also check and link don't work :(

Paresh Wagh

Pasting the link here since there are multiple posts in the thread that provide contextual information.

https://www.odoo.com/forum/help-1/question/create-invoices-credit-notes-in-odoo13-by-code-163575#answer-163579

If this does not work, please report an issue with Odoo at

https://github.com/odoo/odoo/issues

Avatar
MUHAMMAD Imran
Best Answer

See That works fine for me. 

This is becuse you are giving just one entry for example debit or credit you must do two entries with same amount like that.

'line_ids': [
            (0, 0, {
                'account_id': account,
                'debit': sale_orders[0].charger_id,
            }),
            (0, 0, {
                'account_id': account_other,
                'credit': sale_orders[0].charger_id,
            }),

I created below invoice too. I hope this will help you too.
def _prepare_invoice_values(self, order, name, amount, so_line):
    invoice_line = super(VisioJournalItem, self)._prepare_invoice_values(order, name, amount, so_line)
    account_a = self.env.ref('visio_chargers_journal_item.visio_b_dividends').id
    account_id = self.env.ref('visio_chargers_journal_item.visio_a_dividends').id
    account_o = self.env.ref('visio_chargers_journal_item.visio_c_dividends').id

  

    sale_orders = self.env['sale.order'].browse(self._context.get('active_ids', []))
    order = sale_orders[0]
    so_line = order.order_line[0]
    line1= {
        'name': 'Freight Charger',
        'price_unit': order.charger_id,
        'account_id': account_id,
        'exclude_from_invoice_tab': True,

    }
    line2 = {
        'name': 'Insurance Amount',
        'price_unit': order.insurance_amount_id,
        'account_id': account_a,
        'exclude_from_invoice_tab': True,

    }
    line3 = {
        'name': 'Tax Amount NTN',
        'price_unit': order.tax_id,
        'account_id': account_o,
        'exclude_from_invoice_tab': True,
    }
    lines = [line1, line2, line3]
    for line in lines:
        line['quantity'] = 1.0
        line['sale_line_ids'] = [(6, 0, [so_line.id])]
        line['analytic_tag_ids'] = [(6, 0, so_line.analytic_tag_ids.ids)]
        line['analytic_account_id'] = order.analytic_account_id.id or False

        invoice_line['invoice_line_ids'].append(line)
   
    return invoice_line

Regards
MUHAMMAD IMRAN
Technical and Functional Consultant  (ODOO)

Softtar Technologies Pvt. Ltd. Contact : Pakistan (+92)-3037701373
 
Address:
  Allhafeez Shopping Mall
Lahore
Pakistan  (Branch Office)
http://sofftar.com
Avatar
Discard
Avatar
Billiard R Made
Best Answer
See how I handle invoice_line_ids below:

            invoice_move = self.env['account.move'].create({
                'type': 'out_invoice',
                'partner_id': client_partner_id_variable,
            })
            invoice_move.write({
                'invoice_line_ids': [(0, 0, {
                    'move_id': invoice_move.id,
                    'quantity': 1.0,
                    'price_unit': 3.5,
                    'account_id': self.env['account.account'].search( [('user_type_id', '=', self.env.ref('account.data_account_type_expenses').id)], limit=1 ).id
                 })]
            })
Avatar
Discard
Related Posts Replies Views Activity
Unable to use TensorFlow in Odoo module
odoo Odoo13.0
Avatar
Avatar
1
Nov 24
1612
how to get values from a res config settings field Solved
odoo Odoo13.0
Avatar
Avatar
Avatar
2
Apr 23
14521
Getting password reset invitation mail for inactive user in Odoo13? Solved
odoo Odoo13.0
Avatar
Avatar
1
Mar 23
1134
Sorry, you are not allowed to access documents of type 'Unknown' (_unknown). No group currently allows this operation. - (Operation: read, User: 2)
odoo Odoo13.0
Avatar
Avatar
Avatar
Avatar
Avatar
4
Aug 24
21111
Asset value depreciated but it's stage still running and can't dispose
odoo Odoo13.0
Avatar
0
Dec 21
1466