Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

account.move.line with API

api account.move account.move.line

3 ตอบกลับ

21816 มุมมอง

f.welter@netinteract.com

Hi all,

there are major differences between V12 and V13. In V13 i can add an invoice via API and then i try to add account.move.line to that invoice. I always get the error

Cannot create unbalanced journal entry
Differences debit - credit

i set the following fields:

'account_id' => $account_id,
'move_id' => $odoo_move_id,
'product_id' => 174,
'tax_ids' => [[6, 0, [$odoo_tax_id]]],
'quantity' => 2.0,
'price_unit' => 1.99,
'name' => 'TEST'

Do i really have to add serveral lines in order to make it work? whatelse do i have to do in order to have odoo add the lines automatically just as it does when it do it via the UI?

Fritz

selvi

คำตอบที่ดีที่สุด

Hi, I have faced the same problem in v13.

Done some code changes, now its working for me.

I here share some of my changes, you may check if its useful for your's.

# Journal

journal_id = self.env['account.journal'].search([('type','=','sale')])[0]

# Move Line creation:

invoice_lines = []

for line in lines:

invoice_lines.append((0,0,{

'name': line.name,

'display_name': line.name,

'price_unit': price,

'quantity': qty,

'product_uom_id': uoms.id,

'product_id': line.product_id.id,

'tax_ids': [(6, 0, tax.ids)],

}))

# Move creation:

account_move = self.env['account.move'].sudo().create({

'name': doc_name,

'invoice_origin': doc_name,

'invoice_date': date.today(),

'type': 'out_invoice',

'partner_id': partner.id,

'invoice_line_ids': invoice_lines,

'journal_id': journal_id.id,

'company_id': self.env.user.company_id.id,

})

Thanks.

UAB Inovacijos

Hi,

Python code example for Odoo 13:

...

from odoo.tests.common import Form

class AccountMove(models.Model):
_inherit = 'account.move'

def add_invoice_line(self):

    with Form(self) as move_form:
          with move_form.invoice_line_ids.new() as line:
              line.name ='Product Name'
              line.product_uom_id =
              line.price_unit = 1.0
              line.quantity = 1.0
              line.account_id =
          move_form.save()

Zbik

Read my answer in this question:
Create invoices/credit notes in odoo13 by code.

f.welter@netinteract.com

ผู้เขียน

Thanks, i had a lock on it.

I do a account.move create in the first place. Then i use the move_id to add account.move.line .

And there is the problem. as in former verions i expected that all nessesary lines are being created. at the moment with v13 it looks like i have to submit 3 lines in order to get the balance right.

Is there any way odoo api can add all lines by itself and automatically refere to the customer profile with all tax settings?

I would appreciate an example on how to add an invoice with all lines in V13. Is there any documentation available? I really could not find it.

Best regards and many thanks,

Fritz

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
Write permission problem in account.move via API api account.move	0 พ.ย. 24	2296
account.invoice.line account.move account.move.line	2 มี.ค. 22	8019
Track Deletions via API and Efficiently Sync account.move.line Records (V17.2) api account.move.line deleted	0 ก.ย. 24	1950
[SOLVED] get data from mrp.production into account.move.line, but it won't show account.move account.move.line mrp.production	0 มิ.ย. 24	4282
add my custum field in account.move.line view in odoo 16 enterprise account.move tree_view account.move.line	2 พ.ย. 23	4911

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!