Skip to Content
Menu
This question has been flagged
1 Reply
464 Views

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
Discard
Best Answer

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
Discard
Author

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

Author

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

You're welcome Phillip💪