Skip to Content
This question has been flagged
accountinginvoiceimportingv15
1 Reply
1428 Views
Avatar
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! 

Avatar
Discard
Avatar
Lutz
Best Answer

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


Avatar
Discard
Related Posts Replies Views Activity
Get this user error "Cannot create unbalanced journal entry." when i write 'quantity' or 'price_unit' in invoice_line_ids
accounting invoice v15
Avatar
Avatar
Avatar
2
अप्रैल 24
1543
Odoo 15 - I need to automatically change the status to Paid on an invoice in another company.
accounting invoice v15
Avatar
0
अप्रैल 23
2351
Cannot create unbalanced journal entry Ids and Differences debit - credit
accounting invoice v15
Avatar
Avatar
1
अक्तू॰ 22
3840
Import Invoices with journal entries associated
accounting invoice importing odooV17
Avatar
0
अग॰ 24
901
How to add field in a model - which will have records from another model?
accounting invoice studio v15
Avatar
Avatar
2
जन॰ 24
1624