Skip to content
+1-888-319-3663

EONE BLOG

SmartConnect Sales Invoice Template for Business Central


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.

Leave a Comment





RECENT POSTS


Employee Spotlight: Giovanni Fragoso, Support
Popdock Bootcamp - Online, Fall 2021
D365 Business Central Integration Bootcamps - Online, Fall 2021
10 Reasons Why SmartConnect Users Won't Want to Miss the eOne Event 2021!
Dynamics GP Integration Bootcamp - Online, September 2021

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.