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

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

ช่วยเหลือ

Unnecessary invoice lines when importing invoices

accounting invoice importing v15

1 ตอบกลับ

2608 มุมมอง

Chris

I’m having an issue when importing an invoice template into Odoo. The debit and credit amounts from the Journal Items/Account are being incorrectly listed under Journal Items/Quantity and Journal Items/Unit Price, causing Odoo to create empty product entries for accounts, which makes the import unusable.

Headers Used:

Due Date - Invoice/Bill Date - Payment Terms - Payment Reference - Journal - Journal Items/Product - Journal Items/Quantity - Journal Items/Unit Price - Journal Items/Account - Journal Items/Label - Journal Items/Debit - Journal Items/Credit - Journal Items/Taxes

Affected Accounts:

Accounts Receivable (debit amount)
Tax Account (credit amount for taxes)

Problem:

The debit and credit amounts are being treated as product entries, rather than remaining in the Journal Item section where they belong. This results in unnecessary empty product records that I have to manually remove.

Does anyone have a correct import template or a solution to prevent the debit/credit amounts from being listed as products? Ideally, I need them to remain in the Journal Item section and not in the product section. Any help is greatly appreciated, thank you in advance!

Lutz

I use Odoo 18 in Germany.

For me importing bulk invoice works, without creating products, when populating only the right fields. if i use the field "invoice_line_ids/name" for the product name, the product name will be shown on odoo on the invoice, but it will not be linked to a product in the product database. But if i would fill also the field "invoice_line_ids/product_id", it would search for an existing product, or it would create it.

I do the importing in the Accounting App under Customers / Invoices / Import

Using this table works for me as import, without creating products.

partner_id/name

journal_id

name

currency_id/name

invoice_date

invoice_line_ids/name

invoice_line_ids/amount_currency

invoice_line_ids/quantity

invoice_line_ids/product_id

invoice_line_ids/price_unit

invoice_line_ids/debit

invoice_line_ids/credit

invoice_line_ids/account_id

METRO

Customer Invoices

RE/2025/000040

EUR

2025-01-10

Dogs Hat

100,00

7,59

0,00

637,82

4400 Revenue, 19 % VAT

Cheeseburger

1,00

2,29

0,00

2,14

4300 Revenue, 7 % VAT

Shipping DPD

1,00

5,00

0,00

4,20

4400 Revenue, 19 % VAT

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

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

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
Get this user error "Cannot create unbalanced journal entry." when i write 'quantity' or 'price_unit' in invoice_line_ids accounting invoice v15	2 เม.ย. 24	2486
Odoo 15 - I need to automatically change the status to Paid on an invoice in another company. accounting invoice v15	0 เม.ย. 23	3324
Cannot create unbalanced journal entry Ids and Differences debit - credit accounting invoice v15	1 ต.ค. 22	4749
Import Invoices with journal entries associated accounting invoice importing odooV17	0 ส.ค. 24	1577
How to add field in a model - which will have records from another model? accounting invoice studio v15	2 ม.ค. 24	2631

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

Headers Used:

Affected Accounts:

Problem:

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