İçereği Atla
Menü
Bu soru işaretlendi
1 Cevapla
497 Görünümler

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
Vazgeç
En İyi Yanıt

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
Vazgeç
Üretici

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

Üretici

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

You're welcome Phillip💪