跳至内容
此问题已终结
journalodooOdoo13.0bills
7 回复
6649 查看
形象
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.

形象
丢弃
形象
Paresh Wagh
最佳答案

This may help

Create invoices/credit notes in odoo13 by code

形象
丢弃
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

形象
MUHAMMAD Imran
最佳答案

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
形象
丢弃
形象
Billiard R Made
最佳答案
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
                 })]
            })
形象
丢弃
相关帖文 回复 查看 活动
Add New Operation Type in Warehouse 已解决
odoo Odoo13.0
形象
形象
形象
2
12月 24
4474
Unable to use TensorFlow in Odoo module
odoo Odoo13.0
形象
形象
1
11月 24
3249
how to get values from a res config settings field 已解决
odoo Odoo13.0
形象
形象
形象
2
4月 23
18281
Getting password reset invitation mail for inactive user in Odoo13? 已解决
odoo Odoo13.0
形象
形象
1
3月 23
2480
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
形象
形象
形象
形象
形象
4
8月 24
24379