Skip to Content
Меню
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
Це запитання позначене
1 Відповісти
479 Переглядів

I have attempted to import invoices via Excel where invoices may have multiple products lines by following what I believe to be the guidance of not putting certain data in the fields such as number, partner, etc...


Here is an example of the my test import in which multiple invoice are still created per product line.

Partner Number Invoice/Bill Date Due Date Journal Invoice Lines/Product Invoice Lines/Quantity Invoice Lines/Unit Invoice Lines/Unit Price
Client 1 1004 9/1/22 9/1/22 Sales Product 1 1 Units 250.00 
Sales Product 2 1 Units 75.00 

Аватар
Відмінити
Найкраща відповідь

Hello, 

Your excel file is actually quite accurate. On the journal column, you can remove the Journal on the second row. You can try re-importing after that. 

Аватар
Відмінити
Автор

I’ve tried that as well with same result, it still creates two separate invoices. I will try again just in case.

Автор

Update, that worked. I must have had another field when I was testing. That worked. Thank you Baraka!

You're welcome Phillip💪