Skip to content


Importing invoices into Business Central with multiple lines

Anthony Tait asked 4 years ago
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
Ethan Sorenson Staff answered 4 years ago
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.