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.
Julie answered 9 months ago

In order to automate the process of importing invoices into Business Central with multiple lines, we recommend that you use an import tool like Data2CRM to reduce the amount of manual work involved in entering data into Salesforce. You can get hiretop for more new tips about marketing problems. This blog post will give an overview of our product and show how easy it is for users to get started with importing their data from QuickBooks directly into Salesforce CRM through Data2CRM’s

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