Skip to content
+1-888-319-3663

COMMUNITY FORUM

Importing invoices into Business Central with multiple lines

Anthony Tait asked 3 years ago
Hello,
 
I am importing both sales and purchase invoices into Business Central from a csv bulk data source.  Both successfully work apart from those with more than one line per invoices.
 
I have line no. 10000, 20000 etc in my import file.  
 
No error from smartconnect is received from those invoices with more than one line when processing import.  
Any advice on how to successsfully import invoices with multiple lines into Business Central.
 
Thanks in advance
 
Anthony
Answers
Ethan Sorenson Staff answered 3 years ago
Anthony,
 
It sounds like the grouping on your line mapping window isn’t correct. Make sure you group on Document Number AND Line Number. If you just group on document number then only one line will be created.

If you would like to submit an answer or comment, please sign in to the eOne portal.