How to Import Invoices with Many Products per Invoice through excel? How do we arrange the line items?

Question

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:

Partner  Invoice Date  Sales Person   Invoices Lines/Product   Account  Invoices Lines/Description   Journal  Payment Terms  Invoices Lines/Quantity  Invoices Lines/Unit of Measure Invoices Lines/Unit Price voice Lin

Douglas Tabut · 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.

Amit · 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*

Ray Carnes · 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 [1]

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

Bài viết liên quan	Trả lời	Lượt xem
Import csv file with related field other than id, external id, name import csv importing data from excel file	4 thg 11 24	12864
How to import Sales Data from previous years in Odoo Đã xử lý import sale importing data from excel file	1 thg 11 23	6853
How to import a product in english and arabic with fields such as website description and advantages and benefits and features in odoo 12? import importing importing data from excel file	1 thg 7 22	5176
V14 Import File Error import inventory importing data from excel file	2 thg 6 21	4897
import button not showing Đã xử lý import importing data from excel file v14	2 thg 2 21	8158

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!