Se rendre au contenu
Menu
Cette question a été signalée
1 Répondre
482 Vues

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 

Avatar
Ignorer
Meilleure réponse

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. 

Avatar
Ignorer
Auteur

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

Auteur

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

You're welcome Phillip💪