This question has been flagged
3 Replies
16184 Views
importinvoicingimporting data from excel file
Avatar
Fara

Hi all, 

Am having issues to import the invoices with multiple items per invoice. How do we arrange it in the .csv file ya? Because in the excel file, they only allow us to go line by line. May I know the Best Format to do this?

Currently I use the following headers in excel:


Appreciate your Help. Thanks!


Partner Invoice Date Sales Person  Invoices Lines/Product  Account Invoices Lines/Description  Journal Payment Terms Invoices Lines/Quantity Invoices Lines/Unit of MeasureInvoices Lines/Unit Pricevoice Lines/Discount (%)Total Incl Tax
Avatar
Discard
Avatar
Douglas Tabut
Best Answer

Hi, just Export an xls copy of an invoice  that contains more than one product. This way, you will find a template you may use to format the excell sheet you already have. 

Regards. 

Avatar
Discard
Avatar
Amit
Best Answer

Hello ,

Browseinfo has following 3rd party app which helps to import invoice with multiple invoice line, please take look.

​https://apps.odoo.com/apps/modules/12.0/import_invoice/


Regards

Avatar
Discard
Avatar
Ray Carnes
Best Answer

The best way to understand the format of any import is to manually create a record, then export so Odoo creates the layout for you.

The help is worth reviewing:

https://www.odoo.com/documentation/user/11.0/general/base_import/import_faq.html

Avatar
Discard