It makes sense: accountants love Excel and Business Central is for accountants. Out of the box, Business Central offers ‘Edit in Excel’ functionality but it just doesn’t cut it for most users. Thankfully if you own SmartConnect, we have a solution!

Our Sales Invoice template lets you do something ‘Edit in Excel’ could never do; import a transaction! Business Central stores invoice headers and invoice lines separately. That separation prevents the built-in ‘Edit in Excel’ functionality from making changes to both tables simultaneously. SmartConnect doesn’t have that limitation because your header and line data can be ‘grouped’ to form a complete Business Central transaction. Grouping makes SmartConnect very powerful!

The mapping and grouping are handled for you with the Sales Invoice template; you can create your sales invoices through SmartConnect without ever leaving Excel.

The Sales Invoice template is free to use for every SmartConnect.com customer. Instructions on how to get the template working can be found within the Excel workbook and on the download page here.

If you need some help getting things set up, we have a service offering to getting the template up and running for you.