Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
495 Widoki

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 

Awatar
Odrzuć
Najlepsza odpowiedź

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. 

Awatar
Odrzuć
Autor

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

Autor

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

You're welcome Phillip💪