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!